Skip to Content
author's profile photo Former Member
Former Member

How to assign a default value or add another value to a parameter?


I have created a report using command. I have added "DATABASE NAME" as a parameter. Below is my query in command.

"SELECT * FROM {?DatabaseName}.TableName". This is working fine.

Now, I added another dynamic parameter from the same command and set value for it and refresh report but unable to fill default value in parameter.

E,g. Pull designation column from User table and fill all into new parameter.

Can anybody help me please?


Bhavin Panchal

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Dec 11, 2014 at 10:46 AM

    Hi Bhavin,

    Dynamic prompts cannot have a 'Default' Value.

    Could you please elaborate on what you're trying to achieve?


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Abhilash Kumar


      I already tried to add another command in the same connection but when I click on OK button Database Expert not responding suddenly I don't know why.

      The logic behind database parameter is I have multiple databases with same schema and I created single report for all databases.

      I am trying to fill all existing column value in the parameter.

      If this is not feasible way then suggest another way please.

      My actual requirement is create single report and connect it to multiple databases without any programming language. We have Crystal Reports 2013

      Bhavin Panchal

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.