Parameter Default Values

[MTarkington]

Good afternoon,

Using Crystal 10, Cache database.

I have a parameter field that is looking at a numeric ID field. I want to have default values, however, since there are new records created daily, I need the 'Default Values' to update automatically.

Right now, the users would have to know the ID number to run the report, however, this information is not readily available to them, thus I want the dropdown to give them the most current ID numbers.

Please let me know if you need any further information.

TIA,
Mark

 

[synapsevampire]

CR 10 doesn't support dynamic parameter picklists ( I think it copuld be done with dynamic connecting business views), you need CR XI for this, or 3rd party Crystal viewers.

I know, a bloody nuisance, they were unfathomably slow about implementing this, and there are kludgy workarounds, here's a blurb on it:

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

-k

 

[IdoMillet]

Either use Crystal XI (it's the 1st version that provides dynamic parameters) or, if you need to stay with Crystal 10, use a 3rd-party tool (see list at:

http://www.kenhamady.com/bookmarks.html)

that provides dynamic parameters.

For example, my DataLink Viewer provides that functionality for any version of Crystal. To use that functionality, you would need to create a 2nd Crystal report that lists the ID numbers. That 2nd report would then act as the dynamic paramter list.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[MTarkington]

Thanks for the replies.

I have actually found another option.

In the 'Edit Parameter Field' screen, under the prompting text, I used an sql query and it updates the dropdown automatically. The statement looks like this:
Select ID To Display [SELECT DISTINCT ClientID FROM client_table]

There is nothing in the Default Values screen, and it has no problems that I have seen as of yet.

Thought this might help someone else down the road...

Thanks again,
Mark

 

[MTarkington]

Please allow me to follow up on this....

The external application that we use changes the parameter and allows the dropdown, it does not do this within Crystal. I'm not sure exactly whay the application does this, but it did solve my situation...

Mark