I am using Crystal Reports XI and MS SQL 2000.
I have a parameter in a SQL command for my report called "Report Date" which both filters records returned to the report as well as assists with calculations of a loan balance at that date using a sub-query. If I run the report with just this parameter then all goes well.
The report starts to do weird things when I create a second parameter within the report to allow the users to further filter out information. I create a dynamic parameter called Portfolios which I base on a second SQL command within the report that returns a distinct list of values.
I set the second parameter up using the Report Selection Formula so that I can utilise the "multiple values" option.
Now when I try to preview the report I am presented with multiple prompt screens. The first time the prompt screen pops up I am asked for the Report Date. When the prompt screen pops up a second time I am asked for the Report Date again and also for the Portfolios that I want in the report.
Matt
I have a parameter in a SQL command for my report called "Report Date" which both filters records returned to the report as well as assists with calculations of a loan balance at that date using a sub-query. If I run the report with just this parameter then all goes well.
The report starts to do weird things when I create a second parameter within the report to allow the users to further filter out information. I create a dynamic parameter called Portfolios which I base on a second SQL command within the report that returns a distinct list of values.
I set the second parameter up using the Report Selection Formula so that I can utilise the "multiple values" option.
Now when I try to preview the report I am presented with multiple prompt screens. The first time the prompt screen pops up I am asked for the Report Date. When the prompt screen pops up a second time I am asked for the Report Date again and also for the Portfolios that I want in the report.
Matt