Answered by:
crystal reports and subreports with mysql database connection

Question
-
Hi,
I want to create reports and subreports in vb.net 2008 using crystal reports.
Can someone please guide me?
I have followed some tutorial and grasp the basic. Still, having trouble mostly with the subreports.
Thank you.
sheetal.
sheetal
- Moved by Jie Bao Monday, May 28, 2012 9:29 AM (From:Visual Basic General)
Friday, May 25, 2012 4:54 PM
Answers
-
Hi. This is not the forum to be asking CR questions in. Please try a forum dedicated to CR. Since MS has shut down their own VS/CR forum you might want to try one like http://www.crystalreportsbook.com/forum/default.asp. SAP should have one as well (they own it now).
I'll go one step further than Cor on this one. I don't hate CR because of its weird design quirks, I hate it because their version for Visual Studio was terribly written and is nearly impossible to debug. I think their own report tools might be better though.
Here's just one reason why I hate it... I'm still living with a pernicious problem with a CR project I wrote (in VS 2005) -- the way it uses the SQL Native Client provider causes a new SQL process (SPID) to be started with every report rendering and it will not release the process even after the report is disposed. Only closing the app will cause the processes to be closed. So If I look at the processes running on SQL Server I can have up to 20 or 30 running even though no report is active. It must be some COM issue, but the project is so fragile that when I open it up I often get some of ther reports to become corrupted when opened in the designer. Again, just a few reasons I don't like CR for VS.
- Marked as answer by Mr. Wharty Tuesday, June 5, 2012 1:17 AM
Sunday, May 27, 2012 2:20 AM -
Sheetal
There are few programmers who like Crystal reports, not that it is not a good product, but it has its own ways.
Try the forums for Crystal report, it is not a Microsoft product it is currently from SAP
Success
Cor- Proposed as answer by Mark Liu-lxf Monday, May 28, 2012 5:00 AM
- Marked as answer by Mr. Wharty Tuesday, June 5, 2012 1:16 AM
Saturday, May 26, 2012 9:03 AM
All replies
-
Sheetal
There are few programmers who like Crystal reports, not that it is not a good product, but it has its own ways.
Try the forums for Crystal report, it is not a Microsoft product it is currently from SAP
Success
Cor- Proposed as answer by Mark Liu-lxf Monday, May 28, 2012 5:00 AM
- Marked as answer by Mr. Wharty Tuesday, June 5, 2012 1:16 AM
Saturday, May 26, 2012 9:03 AM -
Saturday, May 26, 2012 9:06 AM
-
hello, thank you
i have followed a tutorial, i have been able to do the report with only a minor issue with the sql.
The main problem is the sub report.
Thanks for the links.
sheetal.
sheetal
Saturday, May 26, 2012 3:18 PM -
Hi. This is not the forum to be asking CR questions in. Please try a forum dedicated to CR. Since MS has shut down their own VS/CR forum you might want to try one like http://www.crystalreportsbook.com/forum/default.asp. SAP should have one as well (they own it now).
I'll go one step further than Cor on this one. I don't hate CR because of its weird design quirks, I hate it because their version for Visual Studio was terribly written and is nearly impossible to debug. I think their own report tools might be better though.
Here's just one reason why I hate it... I'm still living with a pernicious problem with a CR project I wrote (in VS 2005) -- the way it uses the SQL Native Client provider causes a new SQL process (SPID) to be started with every report rendering and it will not release the process even after the report is disposed. Only closing the app will cause the processes to be closed. So If I look at the processes running on SQL Server I can have up to 20 or 30 running even though no report is active. It must be some COM issue, but the project is so fragile that when I open it up I often get some of ther reports to become corrupted when opened in the designer. Again, just a few reasons I don't like CR for VS.
- Marked as answer by Mr. Wharty Tuesday, June 5, 2012 1:17 AM
Sunday, May 27, 2012 2:20 AM