Query Selection Screen in Report Designer/WAD

[Former Member]

Hi Gurus,

Please help. Iam try to copy two BEx queries into one report using Report Designer & Web Application Designer. Iam sucessfull in it, however when I execute the report either by report designer or WAD, the report does not populate the selection screen, it just gives you the output of the two queires into one page. Is there a pre-settings we need to perform to get the selection screen for each of this report?

Thanks!

[edwin_harpino]

hi Syed,

try below block 'web items', there is block 'properties of web tempalte', click tab 'web item', and find 'force variable screen', make sure it's marked.

hope this helps

[Former Member]

Hi Edwin,

Thanks for your response. When I see the block 'Properties' , I see only two tabs, General & Web Item Properties. However both of these tabs or folders do not have 'force variable screen'. Am I doing something wrong, please suggest.

Thanks.

[Former Member]

What Support Package are you on? "Force Variable Screen" was introduced in a later support package (I think SPS8 or 9)...

[Former Member]

Hi Prakash,

Below are the details we are using;

Release 2004s, Patch 702, Revision 82.

Maybe I should request to apply the latest SP.

By the way, earlier versions did not have this option?

Thanks

[Former Member]

Yes, upgrade your support package.

[Former Member]

Thanks Prakash & Edwin.

I have requested for SP9 front end.

Will write back if I still encounter any errors.

[Karol-K]

Hi,

Front-end upgrade will not help in this case. This feature "Display Variable Screen [VARIABLE_SCREEN]" was introduced in SP8 backend. You need SP8 backend to be able to use it.

You will find this setting in "Properties" -> "Web Template" (in combo box) -> "Web Template Parameters" -> "Behaviour" -> "Display Variable Screen"

This setting is defined in metadata and required an implementation on Java side (also SP8 required)

Regards, Karol Kalisz

SAP BI Development