Dear all,
I have developed a report with one dynamic parameter. The list of values for this parameter shall be retrieved from column x in table A. However, not all values in column x shall be retrieved but only those that fulfill a specific condition based on other fields in table A, e. g. only the values of x in rows shall be displayed where column y = true AND column z = "some string".
Is there a way to achieve this with CR XI R2?
Thanks for any hints,
AnDi
Hi,
This is possible only when you create an Add Command.
Generate your own SQL like :
Select * from table where y=true and z= 'soem string'
This will filter all the records and get the data into your report now you create a dynamic parameter at report level. The list of values will be based on off you SQL conditon.
Thanks,
Sastry
Add a comment