Hello everyone,
I am very new to Crystal Reports, and was unable to find a solution for my particular problem. I am using CR 2008. I created a report that originally ran directly against a database. The report prompted the user for a start date and end date. This prompt was in the Record Group Selection area as a formula:
{IVR.CALL_DATE} in {?Start Date} to {?End Date}
This worked fine , and when I selected Show SQL query it would give the appropriate query with a Where clause using the user defined dates, and would bring back the correct results.
However the problem arose when I changed the report to use a universe. Now for some reason the prompt parameters do not show up when I choose Show SQL query, and I am only getting partial results.
I have confirmed that my new report that runs against a universe is exactly the same as the report that ran directly against the database.
Any help would be appreciated.
Regards,
I am very new to Crystal Reports, and was unable to find a solution for my particular problem. I am using CR 2008. I created a report that originally ran directly against a database. The report prompted the user for a start date and end date. This prompt was in the Record Group Selection area as a formula:
{IVR.CALL_DATE} in {?Start Date} to {?End Date}
This worked fine , and when I selected Show SQL query it would give the appropriate query with a Where clause using the user defined dates, and would bring back the correct results.
However the problem arose when I changed the report to use a universe. Now for some reason the prompt parameters do not show up when I choose Show SQL query, and I am only getting partial results.
I have confirmed that my new report that runs against a universe is exactly the same as the report that ran directly against the database.
Any help would be appreciated.
Regards,