cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic parameter doesn't shows Drop Down list of values

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Abhilash,

Thanks for your quick reply!

Yes, I followed  the same steps, but it does not work. Is there any configuration or setup to do before?

Thanks!

Nordine

abhilash_kumar
Active Contributor
0 Kudos

It doesn't work in the CR Designer too?

-Abhilash

Former Member
0 Kudos

Hi Abhilash,

no, it doesn't work in the CR Designer.

Thanks,

Nordine

former_member280812
Active Participant
0 Kudos

Hi Nordine,

Maybe your query in the command object doesn't return anything.

Try the query below as your object in your parameter.

SELECT 'A' AS [TEST]

UNIION ALL

SELECT 'B'

UNIION ALL

SELECT 'C'

UNIION ALL

SELECT 'D'

Regards

--careLess

Former Member
0 Kudos

Hi CareLess,

I have already done a similar test without success. I tested my query in the Toad tool and returns rows.

Any other idea.

Thanks!

Nordine

abhilash_kumar
Active Contributor
0 Kudos

What is the exact version of Crystal Reports you're using?

-Abhilash

Former Member
0 Kudos

Hey Abhilash,

My CR details:

Crystal reports 2008

Version 12.7.2.2279

Thanks,

Nordine.

former_member280812
Active Participant
0 Kudos

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