Skip to Content
Former Member
Feb 04, 2010 at 03:23 AM

Crystal Report on BW Query



Weu2019re on BI 7, Crystal Report 2008 V1 and SAP Integration Kit 3.1.

Query is created in BEx Query Designer, with Variable. In Crystal Report, I have set to use the MDX driver u2013 recommended by SAP.

I have created the Crystal Report on top of this BW Query. When I click on Preview, I have Variable screen appeared. I have 5 Variables on the screen:

1) I noticed that we MUST enter the value into the Variable (all of them) else I got nothing to display on the screen. Why? The Variable is configured as u201COptionalu201D in the BEx Query.

2) I have entered the specific value for the Varible i.e. Product = A001, but I still have other Product being display on the screen. Why?

3) And I dont see to have the option to select all value (*) for each of these Variable. Why?

4) In Crystal Report ->Field Explorer ->Parameters, I can see that the Variables defined in BEx Query is there. What can we do with these Paramaters?

Please advise, thank you.

Edited by: lynn on Feb 4, 2010 4:34 AM