locked
Different output for the same report

    Question

  • 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.  

    Thanks for people who are helping.Thanks a lot.

    Friday, February 23, 2007 1:02 AM

All replies

  • 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