BUG - Crystal report SQL command line get executed twice!!! 
Author Message
 BUG - Crystal report SQL command line get executed twice!!!

I have a vb.net console app. that takes a SQL query as a parameter,
fill a dataset and pass it to my Crystal Report, then print the

I went through a special bug where as soon as I called my report's
PrintToPrinter method, it executed the SQL command line defined inside
the report whereas my .SetDataSource method was already called passing
a valid dataset as parameter.

This meant that it executed 2 SQL commands, the 1st one was OK, it was
the one I sent to fill my dataset and pass it to the .SetDataSource
method but the 2nd one was unwanted (because it is used only for
design purposes) and called upon PrintToPrinter execution.

The only way to get rid of this situation was to completely uninstall
the redistibutable framework (dotnetfx.exe) and replace it by the full
framework SDK one along with the framework SP2 (build 1.0.3705.288).


Sylvain Audet - MCP+SB
Astuces .NET mensuels sur

Mon, 25 Jul 2005 21:36:01 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Execute Multi-Line SQL Commands?

2. click of a command button executing twice

3. How to execute a command line command from a *.HTA

4. Executing command to command line from VB App

5. Printing a Crystal report from the Command line

6. Launching a Crystal Report from a command line

7. Crystal Reports from the command line

8. Crystal Report - Command Line

9. Good Reporting Tool for VB to SQL (Currently Use Crystal) or Crystal w/SQL Help Appreciated

10. Crystal Report Graph Problem (No Zero and No Lines attached in Line Graph)

11. Executing a command line using code

12. Executing command line function from VBA (Excel)


Powered by phpBB® Forum Software