I have one dataset called DatabasesOnServer:
SELECT name FROM
Report Parameter is string, from query, and from Dataset above - DatabasesOnServer.
The other dataset in my report is called TablesOnTheSameServer:
= "SELECT * FROM " & Parameters!DatabasesOnServer.Value & ".sys.tables
Basically, in my Table, I would like to show all tables in Server Databases.
Table uses TablesOnTheSameServer dataset.
In a report preview, when I choose one database, everything works fine - I get all tables from
one database selected.
My question is:
Is there a way to show my table n times in the report, depending on the n - number of databases,
without having to choose parameter - exact database name?
For example: If Data set DatabasesOnServer returns three databases - A, B, C - my Table shows A.tables, B.tables, and C.tables?
Thanks everyone in advance!
P.S. I'm aware that I could create different datasets and different Tables depending on those datasets, for each database on the server. But, the structure of the table is always the same, so I thought maybe there's a way to create only one Table that uses something like For Each ParameterName(database), run report consecutively?