Why the output of my crsytal report is different with my c# project report.(Same report produces different outputs). The preview of the crystal report is correct. When I using C# to call the output of the report it is not correct. Both(*Crystal report and c#) also pass the same parameter. In the Show SQL Query, i have put a line as "WHERE 't_trn1'.'status' <> 9. The preview of crsytal report will show the output of which status not equal to 9. But in C# the output is show all without checking the status != 9.
You might want to move the WHERE clause to the record selection formula. That's the standard way of filtering your record set. I've gotten mixed results when I've changed the SQL in the SHOW SQL window of the .rpt file. So your record selection formula would be as simple as "table.column <> 9".
I hope this helps.
Thursday, March 01, 2007 10:00 PM
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.