Crystal Report Cascading Parameter and Null value.
Posted on 2013-06-03
I am using CR XI R2,
Can second cascading dynamic parameter be empty?
I have dynamic cascading parameter composed of Par1 and Par2.
Par1 could have option A,B,C,D Par2 have related values for Par1 A -> Par2 = 1,2.3; for Par1 B-> Par2 = 4,5,6 and on.
Why I need those parameters. I am excluding records from report that have value from parameter Par2.
What I am doing I first pull out records that have value for Par1 e.g. A and B it populates parameter Par2 with related values: 1,2,3,4,5,6.
Now I need to select from parameter Par2 which value or values I will exclude from report.
Problem is that sometimes I want all records from Par1 and I do not want to exclude none from Par2.
But I am prompted to enter value in Par2 as report will not run.
How to go around this, I can not use command that Is not part of solution.