Is it possible to cascade Command prompts.
I created a second command to provide LOVs but when I try to cascade the command prompts Crystal just creates another Report Parameter which I can not see in the Command dialog box.
Thank you
Ian
Hi Ian,
Please see if this works:
1. Create a New Report with the following Command SQL as its datasource:
Select distinct table.field1, table.field2 from table
2. Create the Cascading prompt in this same report against the two fields in this command sql.
3. Add your original report as a Subreport in this new report created in Step 1 and place it on the Report Header.
4. Suppress all other sections of this report except the Report Header.
5. Right-click the Subreport > Change Subreport Links > Link each prompt in the Main Report with the prompts in the Subreport.
I hope this helps.
-Abhilash
I would not say it is not possible, because my experience tells me there are so many tricks in CR to bypass ByDesign limitations, so I am trying to avoid "not possible" statement.
But the idea of Cascade is to narrow down a list of values in multiple steps, so all the steps should be done within the same dataset, but not separate command objects.
And there is a chance I misunderstood the question. More details would really help.
This is a sample of my dataset which works fine for individual list of branches, tills and users.
However, if I try to link then crystal creates a report parameter which I can't use in command.
I would like to limit such that if Croydon selected only Tills and users with Till CRO* are visible in Tills and user parameters.
Thank you
Ian