Is this possible ? and if how do I proceed?

I'm using Crystal Reports XI

 

Thanks in advance

 

Rene

 

by static you want from a predefined list of values?

 

if you are talking data selections...CR only selects once

 

if you are talking parameters, I would make use of the cascading parameters, and if you want to pull from a static list to begin with, I would use a command and 'select' the values that you want into a pseudo table using unions like:

 

select x as colName

union

select y

union

select z

 

then you could link your command table to your other tables and have the parameter cascade from them

 

HTH

 

At least that is what I would do.

 

First create a command for your main report with an embedded static parameter, example to follow;

 

select
matter.number
 
from client
 
join matter
on client.clientindex = matter.client
and client.number = '{?client}'

 

This is simply the list of matters that belong to the client, the result from matter.number will be the options in my second paramter.

 

Now create an additional dynamic parameter (I called mine @Matter) and set the datasource as the result set generated by the above query (matter.number).

 

Now create a command for your subreport (this should contain all the data you actually want to display to the user), this should also have an embedded static parameter to filter the data, my example follows;

 

select
matter.number,
matter.displayname
 
from matter
 
where matter.number = '{?matter}'

 

Now link your subreport static {?matter} parameter to the dynamic {?matter} parameter in your main report.

 

This is what I think you're after, it works fine for me but if I haven't explained the process of implementing it very well let me know.

 

Regards,

Ryan.