Including execution count in all the reports

• aar.mba

  SSC-Addicted

  Points: 438

  More actions

  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

• Umer Akram

  SSC-Insane

  Points: 22209

  More actions

  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.

• aar.mba

  SSC-Addicted

  Points: 438

  More actions

  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

• Umer Akram

  SSC-Insane

  Points: 22209

  More actions

  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.

• aar.mba

  SSC-Addicted

  Points: 438

  More actions

  December 13, 2013 at 3:54 am

  #1673201

  Yeah let me try..

  anyways ... thanks a lot...