Skip to Content

Creating Parameters in SQL Command

I've created a report via the Add Command option rather than pulling directly from the tables and that works great.  However, I need to create a dynamic parameter for user to select records from the many thousands of records on the report.

I created a parameter in the Parameter area of the Add Command screen & integrated that in the WHERE clause of my SQL commands and the parameter seems to work okay.

However, I just discover that the parameter was "STATIC" instead of dynamic as I intended it to be.  Is it possible to make it dynamic?  Any help would be greatly appreciated.

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 29, 2015 at 06:02 PM

    Hi Fione,

    1) Create a new command object and type in the SQL that would return just the List of Values. E.g:

    Select distinct table.field from table

    2) DO NOT Join this command object with the other command object

    3) Ignore the warning.

    4) Edit the prompt from the Field Explorer > Set it to 'Dynamic' > From the 'Value' options choose the field from the Command Object you created in Step 1

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded