Post reply

Including execution count in all the reports

  • December 13, 2013 at 12:22 am

    #287363

    Hi,

    I'm Aarthi.I'm a fresher as far as SSRS is concerned.

    I have a requirement that execution count should be included in all the reports.

    Like,if I run the report ,a tablix must be there below showing execution count, processing time, data retrieval time of that particular report.

    Usually we have all these in a separate database with a table execution log. But I want that functionality to be available in every report.

    Is that possible..Please help me

    Regards,

    Aarthi.R

  • December 13, 2013 at 12:56 am

    #1673173

    In 'ReportServer' db you can find the following view

    1. ExecutionLog

    2. ExecutionLog2

    3. ExecutionLog3

    Find the relative Data from them i hope it will serve the purpose for u.

  • December 13, 2013 at 1:04 am

    #1673175

    Hi,

    Thanks for ur reply..

    Its there in separate database dwreportserver..

    But I want that to be in a report.

    for eg: report named "shipments received"

    If I execute that report, at the end of the report I should get a tablix containing execution count , processing time, data retrieval time of that particular "Shipment received " reports.

    Anyone pls help me.

    Regards,

    Aarthi.R

  • December 13, 2013 at 3:42 am

    #1673197

    it means you need to fetch these field data

    you can do following:

    create a subreport, place that in the "YOURREPORT", and show these field.

    OR

    create parameters in the report. get these values on the front end and assign those values to the parameter.

    i would go with the sub report, its easier to manage. 🙂

  • December 13, 2013 at 3:54 am

    #1673201

    Yeah let me try..

    anyways ... thanks a lot...

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

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