Forum Discussion

Byzbkr's avatar
Byzbkr
Frequent Visitor
4 years ago

Changing the Database Names in Edit Parameters

Hi,

 

I have multiple databases in my server and all of the tables are the same in those databases. I designed my report for a specific database and I am changing the datasource with parameters. When I click edit parameters; I am choosing server and database names. But I dont want to see db names in drop-down. I have seperate table and in that table I have db names in one column and other column includes the names that I want to see in drop-down. Is there a way to do that? Thank for your helps in advance.

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Byzbkr , Under manage parameter. In the suggested value option. You have an option for the query. Choose on of the table /query there

    • Byzbkr's avatar
      Byzbkr
      Frequent Visitor
      4 years ago

      Thanks. But with this option we can just create list with the existing database names. For example,  our SQL database name is "1234_2021" but while I am choosing my database name in parameters pane from the list I want to see "Apple" instead of "1234_2021". How can I do that in query? Can you give me an example query for that issue?