Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: append all database value Post Reply Post New Topic
Author Message
lamnguyen1978
Newbie
Newbie
Avatar

Joined: 17 Jun 2011
Location: Canada
Online Status: Offline
Posts: 3
Quote lamnguyen1978 Replybullet Topic: append all database value
    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


Edited by lamnguyen1978 - 17 Jul 2011 at 8:08am
Lam Nguyen
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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
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.