Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Custom reports

web-app

I don't understand how to write custom reports.

I've started a new WebApp project, added a User Control which inherits from ReportBaseControl, and have the code behind it.

How do I connect the the database to retrieve data? How do I choose the data to be used in the report? How do I turn that data into a viewab;e form using System.Web.UI.DataVisualization?
alitheg
· 1 		alitheg
Thursday, September 10, 2009, 12:33:54 PM
Replies (5)
helpful
0
not helpful

Please refer to this post to learn more about adding custom reports to your Gemini.

http://support.countersoft.com/forums/thread/11858.aspx
Bikram
· 1 		Bikram
Thursday, September 10, 2009, 1:00:30 PM
helpful
0
not helpful

Hi Bikram, thanks for the quick response.

That's the post I've been looking at, and it's got me as far as I am. I've got the connection string method and everything else described in that post, but I still can't work out how to actually obtain data and then how to use it to make a report.
alitheg
· 1 		alitheg
Thursday, September 10, 2009, 1:02:56 PM
helpful
0
not helpful

You'll need to generate SQL queries/stored procedures to pull the required data. Once you have the required data, you can present it in tabular form or use third party tools such MS Charts.
Bikram
· 1 		Bikram
Thursday, September 10, 2009, 1:35:18 PM
helpful
0
not helpful

Ok, that helps, but I can't see how to connect to the database in the first place. Which libraries am I meant to use? I presume that once I know which one it'll be well documented online, but I can't seem to find one that contains methods for database connection (I found plenty for queries and the like, but not how to connect)
alitheg
· 1 		alitheg
Thursday, September 10, 2009, 2:30:56 PM
helpful
0
not helpful

You can refer to this link for more info on connecting to DB.

http://msdn.microsoft.com/en-us/library/dw70f090(VS.71).aspx
Bikram
· 1 		Bikram
Thursday, September 10, 2009, 4:07:58 PM