Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Default Values of Parameter Not Updating Post Reply Post New Topic
Author Message
jsh8286
Groupie
Groupie
Avatar

Joined: 09 Mar 2012
Online Status: Offline
Posts: 46
Quote jsh8286 Replybullet Topic: Default Values of Parameter Not Updating
    Posted: 25 Apr 2021 at 1:08pm
Have created a Crystal Report where we have created a parameter and setup the default values to pick out the vendor/supplier name from a table and for our purposes we have included all the names from the field.

One issue has arisen. Assuming there is a vendor we do not order from anymore we remove the vendor and vendor name from the table we are accessing but the name and vendor deleted still shows under the Default Values of the parameter. The parameter does not "refresh" automatically and the vendor in question is still in the list. Unless we don't include them in the list or if we exclude all the vendors and then reinclude them all in the list and save will the parameter refresh.

So is there a way to make the parameter refresh automatically when the report runs?

Hope this makes sense.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 26 Apr 2021 at 6:45am
Yes.  You have to make it a dynamic parameter.  I normally make a separate query (command) to pull in the parameter data and use that as the data source for the dynamic parameter.
IP IP Logged
jsh8286
Groupie
Groupie
Avatar

Joined: 09 Mar 2012
Online Status: Offline
Posts: 46
Quote jsh8286 Replybullet Posted: 26 Apr 2021 at 11:57am
Thanks kevlray. I like to use the old V10 of crystal but it doesn't appear that the dynamic parameter is available with that version so will have to go to another one.

Thanks for the information.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 27 Apr 2021 at 4:15am
I checked and it looks like dynamic parameters were introduced with Crystal Reports XI


Edited by kevlray - 27 Apr 2021 at 6:48am
IP IP Logged
jsh8286
Groupie
Groupie
Avatar

Joined: 09 Mar 2012
Online Status: Offline
Posts: 46
Quote jsh8286 Replybullet Posted: 28 Apr 2021 at 3:29am
Yes switched to V11 and all good now. Thanks for your info.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.