Print Page | Close Window

append all database value

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
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=13775
Printed Date: 20 Apr 2025 at 1:39pm


Topic: append all database value
Posted By: lamnguyen1978
Subject: append all database value
Date Posted: 17 Jul 2011 at 6:36am
Hi everyone
 
In window Field Explorer-> Parameter Fields->nameField->Edit->"Edit a parameter and list of values " of Crystal report,  I want a drop down menu with all of the values of  my table for my parameter for users to choose.  In option "Action", I choosed "Append all database value". There it works, It add all value from table of database.
 
But when run the programme and I add a new value on my table, througth cms,  It doesn't  add this new value on my drop down menu of crystal report
 
I tried to do it by programmtically from c# with ParameterField

and with plurals parameter discrete ParameterDiscreteValue

but it doesn'nt work , nothing is dysplayed. Can anybody help me ?
thanks


-------------
Lam Nguyen


Replies:
Posted By: hilfy
Date Posted: 20 Jul 2011 at 5:21am
You need to create a dynamic parameter that will read the data from the database.
 
In the parameter editor - at the top right of the screen there is a drop-down that will let you change the type of the parameter from static to dynamic.  You then just have to point it to the correct field in your report to get the list you're looking for.
 
There are other ways to do this, but this is the easiest.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window