May 19, 2009 at 12:57 pm
I am doing a simple report by stored proc where in it has display 5 columns of similar table from 3 different servers. Server name would be the parameter, upon selecting the server name from drop down i want list the table on that server. How do i do that?
I have 120 records in the table and i get 1 record for each page in the report like 120 pages of report of 120 records. How do i get them in a list
May 19, 2009 at 1:04 pm
In you data source, set the connection string to "expression" and use the pararmeter you created @servername and use master database. In the data source use SELECT * FROM sys.sysdatabases as query string
May 19, 2009 at 1:09 pm
I'd suggest you use a table instead of a list in your report.
Since you didn't specify I'm assuming you're writing the report in Visual Studio, not report builder. Also I'm assuming you're using SSRS 05 not 08 although I'm not sure for this small example there would be many differences...
First make sure you're creating a dataset that contains all of the records you want to display.
Second click on the layout tab.
From the Toolbox, drag and drop a Table Report Item to your report body.
Click on the Datasets tab and drag the columns from your report to the table object.
Click the preview tab to see if it worked...
For a more descriptive example check the following link. http://msdn.microsoft.com/en-us/library/ms167305.aspx
-Luke.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply