You can use the COmmand Data for that but you do not actually write it in the command. IN order fot the cascading element to work your COmmand has to retrieve all the values to persent as parameter options then in the crystal select statement you filter teh data.
Not including data params go into your report (assuming your Cmmand returns all values you want to start with).
Create a New Param (likels as a string)
make it DYNAMIC
In the Value option select the Group field from the command and click in the right column Parameters to make a parameter out of it.
Click in Row 2 of the Value column and select the Agent field from the Command and then click to create a param in that row.
Save this
Now in your crystal select statement use these 2 params you just created...something like this:
command.group=?Group and command.agent=?agent.
Now you can add the date range as a seperate param as either one date with a range or a begin and end date param
Note from a performance standpoint I prefer Views (or stored procs) to commands becuase COmamnds tend to bog my set up down considerably.
Edited by DBlank - 08 Feb 2010 at 8:01am
IP Logged
