Export Button in Reporting Server
I want to log mechanicms when Some click export to excel vs... button in report server how can I access and handle this event in reporting service 2008
Thanks for help
July 20th, 2011 6:25am
Hi,
This events are logged by default, try running run below query and you will find values
select * from ExecutionLog2
where FORMAT = 'excel'
order by TimeStart desc
Note:- By default log history is preserved for 60 days.
- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2011 8:08am
Hi Chintak,
My first question for my reportserver there is a executiontable but there is no record and it is already used
My second question is my all user are anonymous authenticate and i want to write a code or trigger when click excel button so can custimize it
My third question is where is executionlog2
Thank for your help
July 21st, 2011 6:35am
Hi,
ExecutionLog2 is a view in ReportServer database to track the report execution history. For more details kindly refer
http://blogs.msdn.com/b/robertbruckner/archive/2009/01/05/executionlog2-view.aspx
- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
July 22nd, 2011 8:15am
Hi Chintak
Thanks for your help,but my problem still go on,because execution2 log for rs service account and my all user use same rs account so have to custimize this button and take my user information and log them,for my programmer in report viewer
Please help,thanks a lot
July 23rd, 2011 6:45am
Hi Bilgehan YILDIZ,
According to your description, you would like to log users information when they export report to other formats, right? Please correct me if my understanding is wrong.
If that’s the case, I suggest you con program with ReportViewer in Visual Studio to achieve your target, for more information about how to program, please post the thread to our Visual Studio Report Controls forum:
http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/threads.
If you have any question, please feel free to ask.
Thanks,
Eileen
Free Windows Admin Tool Kit Click here and download it now
July 24th, 2011 6:23am


