Print Page | Close Window

Default Values of Parameter Not Updating Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22935 Printed Date: 27 Apr 2024 at 6:11pm Topic: Default Values of Parameter Not Updating Posted By: jsh8286 Subject: Default Values of Parameter Not Updating Date 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. Replies: Posted By: kevlray Date 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. Posted By: jsh8286 Date 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. Posted By: kevlray Date Posted: 27 Apr 2021 at 4:15am I checked and it looks like dynamic parameters were introduced with Crystal Reports XI Posted By: jsh8286 Date Posted: 28 Apr 2021 at 3:29am Yes switched to V11 and all good now. Thanks for your info.

Print Page | Close Window