Hello All,
I have four prompts in my report and all prompts are having same static choices
ex: P1 having static choices are 1,2,3,4 and P2 having static choices are 1,2,3,4 and P3 having static choices are 1,2,3,4 and P4 having static choices are 1,2,3,4
when i run the report and select '1' in P1, it should not show in P2,P3 & P4
same as if i select '1' in P1 & '2' in P2 then both should not show in P3 & P4
Please help how to get this one?
Many thanks in advance
Thanks & Regards,
Krishna
Quote from: gurralakrishna on 11 Sep 2014 12:55:07 AM
Hello All,
I have four prompts in my report and all prompts are having same static choices
ex: P1 having static choices are 1,2,3,4 and P2 having static choices are 1,2,3,4 and P3 having static choices are 1,2,3,4 and P4 having static choices are 1,2,3,4
when i run the report and select '1' in P1, it should not show in P2,P3 & P4
same as if i select '1' in P1 & '2' in P2 then both should not show in P3 & P4
Please help how to get this one?
Many thanks in advance
Thanks & Regards,
Krishna
Hi,
Static choices are, as the name suggests, static choices. Unlike dynamic choices which are driven by a query and can be filtered, static choices are predefined and static.
Do you have an option to get the choices in a table you can read? Alternatively, you could create "virtual SQL" in your report to drive values into queries for your prompts, eg
select * from (
values (
cast('ONE' as varchar(10))),
('TWO'),
('THREE'),
('FOUR')
)
MFPromptContents (MFPromptValue)
Cheers!
MF.
Hi MF,
Thanks for your replay!
Can you please explain more
Thanks,
Krishna
Quote from: gurralakrishna on 12 Sep 2014 12:18:08 AM
Hi MF,
Thanks for your replay!
Can you please explain more
Thanks,
Krishna
Sure. What do you need explained?
MF.