CR2008 and SAP BW - Only limited number of values for static parameter

[former_member593901]

Hello Experts,

we have the following constellation / problem:

- SAP Query BW 7.0 with variables

- a report built upon this query with Crystal Reports 2008

- now if we execute the report and try to fill in the parameters (= SAP BW variables), not all values are displayed for selection and there seems to be no possibility to further scroll down; e.g. the months 01.1993-08.2006 are displayed, but not later than 08.2006

This is really a problem for us since the users won´t be able to select e.g. the desired time range !

I read already the SAP notes 1218588 and 1211902 and I 'implemented' 1211902, but still only a few values are displayed (the same as before I changed the values for BrowseTimeout and MaxNBrowseValues). Besides that, in the solutions in the SAP notes Crystal Reports 2008 is not explicitly mentioned (so I manually created the DWORD-keys).

Many thanks for your help in advance !

Frank

[roland_hoeller2 · Accepted solution]

Hi Frank

The value is limited to 200 by default but can be amended.

Back up the registry then change the MaxPickListSize Paramater in HKEY\LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\BWQueryReportWrapper

Roland

[IngoH · Accepted solution]

Hi,

in the designer the values are limited and the number can be changed as Roland mentioned.

In InfoView after publishing the list if online

ingo

[former_member593901 · Accepted solution]

Thanks, that solves the problem. SAP has also announced a SAP note concerning this topic (SAP Note 1263041 - Only limited number of values are displayed for a SAP BW parameter list).