lbass,
Any parameters used in the record selection formula do not appear in the Show SQL query. And here lies the problem. I am try to reduce the number of records presented to Crystal to reduce the time the report takes to run.
Regards,
Bob
How do I add a parameter created in Crystal Reports 8.5 to the SQL from 'Show SQL Query' under Database. If I add {?Test} to restrict records I receive several errors.
Regards,
Bob
synapsevampire,
The subreport is in the Report Header of the main report. If I show the details it displays okay. Once I hide the details the formula no longer displays any information.
What I am ultimately trying to do is use a Parameter in the main report to filter the subreport and use...
I am using 8.5. I can obtain information from a subreport using a shared variable. I can display and used this shared variable in a formula in the detail section of the main report. If I hide the detail section and allow drilldown then this formula only displays a blank and not the shared...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.