I have a 4 tier nested SQL statement that is being created in a VB.NET application. The Query contains different 'Where' statements based on the item selected on the VB form.
I would normally use Parameters and pass those into the report but in this case, the data filters (where statements) are in the nexted SQL statements and not in the top level statement.
I need to set the SQL statement as a Command selection within the Database configuration of the Crystal Report (using CR 2008).
How do I pass in the SQL statement into a Crystal Report and set it as the Database source for the report data?
IP Logged
