on 05-07-2015 3:01 PM
Hi experts,
I am creating a report based on Oracle stored procedure. It's working fine with static parameters but I want to change some of the parameters from static to dynamic.
The problem is the dynamic parameters doesn't shows Drop Down list of values (based on simple command query).
Please helps!
Thanks,
Nordine.
Hi Nordine,
Since you're reporting off of a Stored Procedure, here's what you need to do:
1) Open the Database Expert > Expand the database connection > Select 'Add Command' and type in a SQL Query to generate the List of Values. E,g:
Select Distinct table.field from table
2) Go to the Links tab and Delete any links from this table to the SP. CR will throw a warning that you can ignore
3) Open the Field Explorer > Right-click the prompt > Edit > Select 'Dynamic' under 'List of Values'. Under the 'Value' column, choose the field from the 'Command Object'.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nordine,
Did you try to use static and populate the values manually? If this method is not also working then maybe you had registry key issue. try to change the "MaxRowsetRecords" in your registry.
Try this key:
HKEY_CURRENT_USER\Software\SAP BusinessObjects\Suite12.0\Crystal Reports\DatabaseOptions
or this one:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite 12.0\DatabaseOptions\LOV
Maybe yours is different. Just play around on it.
Regards
--careLess
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.