Post reply

Make SSRS report server specific

  • March 15, 2009 at 1:15 pm

    #219157

    Hi,

    I am new to SSRS...I have to create a report and make it server specific. When I run the report it should return the dataset corresponding to the server . I already have the stored procedure to get performance characteristics like db size and log size etc on all servers in my network. But my problem is when I need to get the results based on particular server.

    Thanks,

    Swetha

  • March 15, 2009 at 10:40 pm

    #960041

    Hello,

    I am just trying to understand your issue properly. Do you want the user to be able to select from a list of Servers and then the report will only display data for the selected Server?

    Does your SP accept and handle a Server-Name as an input parameter? If so, then may be take a look at the topic “Using Parameters in a Report” in Books Online.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • March 16, 2009 at 12:00 am

    #960050

    create a datasource and point the report dataset to created data source. Based on server information set in datasource report will pull the data from specified server.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply