default values 2

[charltonc]

Hey everyone
when I try to do default values from the parameter fields

I chose a field from the database and clicked default values

but then only part of all the different values in that field comes up.

Why?

Thanks

 

[Turkbear]

Hi,
Check the docs..There is a limitation on 'pick-list' values, I believe.

 

[charltonc]

there is only a length limit (256 characters or something), no number of values limit

=(

help!
thanks!

 

[Turkbear]

Hi, In v9 using DHTML, only 50 values will be shown..
It is a known bug..

See..

http://support.businessobjects.com/library/kbase/articles/c2013093.asp

to see if it applies to your situation/

 

[charltonc]

But I am not using Crystal Enterprise and Eportfolio when I see this problem.

I can't even get the full list in Crystal Reports (ie where I make my layout and design)

any ideas?

 

[Turkbear]

Hi, Sorry I missed that..

In my CR I get 500 in the list ( out of > 5000 possible)
which is the default..
It is controlled by a registry setting ( according to postings in this group)
HKEY_CURRENT_USER\Software\Seagate Software\Crystal Reports\Database Server\MaxNBrowseValues

 

[lbass]

There is a method for changing the registry setting, but as I understand it, you should only do that if you really know what you are doing. Another option is to create a report in Crystal that has your default values, export it to a text file, and then import that for your picklist. There is a white paper on the Business Objects website or reading thread149-39169 might help.

-LB

 

[charltonc]

That solved my problem

Thanks SO MUCH!!!

 

[SFLLC]

If a third party solve is acceptable to you, we make a product called SPL(TM) 2 (Smart Pick Lists) which is now in it's 3rd generation.

It allows you to retrieve the latest list of default values for your pick list parameters from any number of databases, including support cascading parameters (i.e. depending on what you select for country, region will display different values, etc.) with out actually modifying the report template itself.

Or if you're not looking for a dynamic list driven by a database, you may wish to look at our recently launched .rpt Inspector(TM) 2 Professional Suite which allows you to modify default values (and lots more, like set location, change driver, verify, and more) across multiple parameters across one or more reports.

Both products are available for a FREE 30 day trial.

Software Forces, LLC
now available ".rpt Inspector 2 Professional Suite (for CR5.x-CR8.5)" and ".rpt Inspector 2 Professional Suite (for CR9.x)"
=====> download your FREE 30-day trial today! @

http://www.softwareforces.com

proud makers of ".rpt Inspector" brand for Crystal Reports,
"SPL (Smart Pick Lists)" for Crystal Enterprise, and "SmartObjects" for Seagate Info & Crystal Enterprise.

Coming soon ".rpt Inspector 3 Enterprise Suite" for Crystal Enterprise