Forum Discussion

Bodo's avatar
Bodo
Helper I
3 years ago
Solved

How to use parameters in report builder with a Postgresql DB using odbc?

Hi all,   I am having problems using a parameter in a paginated report with a postgresql database. I am using an ODBC connection to connect to postgresql.   This is the test query I am using:  ...
Need Help
  • Bodo's avatar
    Bodo
    3 years ago

    Alright, 

     

    I have found a solution to my problem with external help now. With an ODBC connection parameters are created by using the questionmark sign (?). But you are not allowed to use any namens for the parameters anymore.

     

    If you use ? in your SQL, parameters are automatically created in the report builder.
    You have to pay attention to the order of the parameters and you are not allowed to rename it afterwards.

    Here's an example which works for me:

     

Bodo's avatar
Bodo
Helper I
3 years ago

Alright, 

 

I have found a solution to my problem with external help now. With an ODBC connection parameters are created by using the questionmark sign (?). But you are not allowed to use any namens for the parameters anymore.

 

If you use ? in your SQL, parameters are automatically created in the report builder.
You have to pay attention to the order of the parameters and you are not allowed to rename it afterwards.

Here's an example which works for me: