none
Incremental Counter in SSRS each time report is run

    Question

  • Hi

    I need to have a header row in my SSRS report which is an incremental number e.g. each time the report is run the number increments by 1.  Something similar to a hit counter on a website.

    Is it possible to have an internal variable within SSRS which will increment by 1 each time the report is run?

    It seems straight forward, but from reading other articles online, it appears not to be.

    Can anyone advise?

    Tuesday, January 14, 2014 1:40 PM

Answers

  • The most i think you could do is query the ExecutionLog3 view and count the number of times the report has executed successfully.  The problem is this log is only kept for 60 days default.  I am sure if you wanted to you could adjust the period of time in which the log is kept (keep in mind it is system wide) or you could pull the data out that you need incrementally and store it.  Here is some information on the view.

    http://technet.microsoft.com/en-us/library/ms159110.aspx

    I think the biggest challenge you will face on this one is political should you go down this path.  Good Luck!

    Tuesday, January 14, 2014 3:24 PM