Post a New ReplyShow Printable VersionSubscribe to this Thread Search This Thread Advanced Search   Email address Please enter your email address. Ask Golden Search  |  Chat Golden Consulting > Message Board > Default Value for Dynamic Parameter   Thread Tools  | Search This Thread  Reply   Author Comment   Satish      08/22/08 at 02:26 AM Reply with quote #1 I want the 'ALL'  value I've added using a union query to the be the default value for dynamic parameters in my report instead of the blank value which crystal XI report adds as default. Is there anyway to achieve this? Alan      08/22/08 at 06:05 AM Reply with quote #2 There is a way to display this using the union. Below is some sample code for the parameter SELECT Country, Region, City // Type the fields that you want the "All" option to be available. FROM Customer (your table) UNION SELECT Country, Region, '"All' FROM Customer Previous Thread | Next Thread Reply   Bookmarks    Digg  del.icio.us  StumbleUpon  Google