question on prompt

building reports desktopintelligence
1

Hi All,
I have a report which gets ‘Budget Numbers’ from a columns called ‘Budget_01_MTD’ & ‘Budget_31_MTD’. I have to provide with a prompt , if a user picks ‘01’ he has to see the ‘01’ like wise the ‘31’.

How do I do this.

Thanks
DB

bdkhyd :us: (BOB member since 2002-08-21)

2

Try:


CASE WHEN @Prompt('Please enter code','A',{'01','31'},,) = '01' then budget_01_mtd ELSE budget_31_mtd END

Regards,
Mark

3

Check this link too.

mkumar (BOB member since 2002-08-26)

4

Hey Mark,
Thanks for the inputs, I did set it up like an object that did work.

Thanks,
DB

bdkhyd :us: (BOB member since 2002-08-21)