Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anbalagan
Starting Member
5 Posts |
 Posted - 2007-10-03 : 08:31:33
|
| In my report i have 2 cascading parameters. Parameter2 should be populated based on parameter1Say Parameter1 has values ofALL ABCDi had set ALL as default parameter in Report Parameters window for Parameter1 and Parameter2 has values of ALL1 (A)2 (A)3 (A)4 (B)5 (B)6 (C)7 (C)8 (D)9 (D)I had set ALL as default parameter in Report Parameters window for Parameter2If i choose ALL the all the values above should be available in Parameter2.If i choose A then only ALL,1,2,3 should be available in parameter2.same for B (ALL,4,5) ,C (ALL,6,7) ,D(ALL,8,9)This is working if i select only once while running the report.If i choose A in Parameter1 and only 2,3 in Parameter2 and then go back to Parameter1 and tried to change from A to B. Parameter2 is showing as blank.But i need ALL should be selected by default(as i specified) |
|
|
|
|
|
issue with cascading parameter(Urgent)