Post reply

Report Parameters in ReportServer

  • August 22, 2016 at 7:53 am

    #329241

    I have a report which has a box that shows report parameters that have been chosen. In the event that a report runs slowly, I need to see what parameters have been chosen. Unfortunately, it displays as per the attached screen grab.

    Does anyone know of a way to display these chosen parameters in a list like way?

  • August 22, 2016 at 10:07 am

    #1896698

    How are you wanting to store this data. Are you simply wanting it to be displayed as part of the report, or when the report is run?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • August 23, 2016 at 2:10 am

    #1896821

    Hi Thom,

    The screen grab is the output in the SSRS report, the source is from reportserver / executionlog / parameters. The output is delivered as one long thread but we need something more list like.

    Regards

    Stuart

  • August 23, 2016 at 2:37 am

    #1896825

    Hi Stuart,

    As I asked above, how are you trying to store this? Are you trying to read the Report Server DB, Save in a table in SQL, just display them on the report?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • August 23, 2016 at 2:46 am

    #1896828

    Hi Thom,

    Just to display them on the report in a format that's readable. I'll have to join on branch, department names etc to the GUIDs as well.

    Regards

    Stuart

  • August 23, 2016 at 3:39 am

    #1896831

    Why not use textboxes with them in? You can reference the value of a parameter using expressions. So, for example, if you had a parameter called branch, you could reference it by using:

    =Parameters!branch.Value

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 6 posts - 1 through 5 (of 5 total)

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