changing sql query of crystal reports from program
this has been eating me up lately. suppose i designed a report which selects all the fields of 'Credit' Table
in Xtreme sample database. now i can easily display the data columns using a query embedded in the report. but say
i want to cutomize the report and say i want to display the credit amount of customer with Id=1 or say display all
the customers with credit amount greater than $500. how can i do this without using paramter fields. can i change the
query embedded in the report without altering the database fields but altering the criteria of record selection fron the
code programmatically. really need ur help on this.
|