Genrate Report

[CAVESTER]

Hi Guys,

Wonder if anyone can point me in the right direction here?

Been looking for a way to create a report from data I have in MySQL. However I would like the end user to be able to change the report style on-site. I thought I would look into XML and XSL in order to create a HTML page for the report so that the user could edit the XSL file if required. However this is a C# desktop app rather than a web app so I was wondering...

A) Am I looking at the right method to do the job i.e. XML & XSL (I am also stuggling to find any examples)?

or

B) Should I look into Crystal Reports for a better solution (is this free to distribute with your app when you use the .NET integrated version)?

Thanks,

Lee.

 

[dakota97]

Well, Ill put my 2 cents in and say this.

In my VB.Net app I used Crystal Reports. I then created some menu items so that the user can select the type of report that they want to display. For example, my app is a retail point-of-sale program (http://www.cgdesign.net/download.asp). For the reports, I gave the user the options to view daily, weekly, and monthly sales reports. For the inventory, I gave them the option to generate reports by customer, product ID, category, and department. So actually I created different reports that pull the corresponding information from the database, based on the menu item that the user selected.

One thing I will tell you is that it takes a little time to get used to using Crystal Reports. The best thing I did was to purchase the book Crystal Reports .Net Programming by Brian Bischof (http://www.crystalreportsbook.com). I looked all over for tutorials and help using Crystal Reports, and found that this book is all I needed.

I hope this helps you out.

Chris

 

[neodatatype]

One thing I will tell you is that it takes a little time to get used to using Crystal Reports.

Im working on a little reporting tool, its really simple to use and does not cost as much as CR
Yes, it is not so powerful as CR, but you can give it a look

www.neodatatype.net