Running a stored procedure before viewing the report

Question

Hi,

 

I have a report with sub reports. One of the sub report has a query which is dependent on the temp table in which data is inserted only when a stored procedure is executed. So, I have created another data set for this stored procedure in the main report.

When previewing the report on Visual Studio, this stored procedure is executed and I can see the data of the sub report. But after I deploy the same report on the sharepoint server, I cannot view the data of sub report. How could I solve this? please advice. 

Thanks,

Sandy

 

Answer 1

HI,

This needs to be troubleshooted.

You can do this in following two way:

1. Switch on verbose mode of logging and then try accessing the reports on sharepoint. Then capture the logs in uls log files to check foe error or exception messages.

2. In your visual studio apply breakpoints and then attach your project to the w3wp process serving your sharepoint site and then try accessing it will then come to your visual studio breakpoints while execution.

 

I hope this will help you out.

Thanks,

Rahul Rashu

 

Answer 2

Thank you  for the reply Rahul.

I am not getting any error messages to capture the event. Just the report runs without showing that particular subreport.. i can see the data related to other subreports.. (there are 4 sub reports in total including this report)..

 

 

Answer 3

HI,

Have you tried the second way of breakpoints ?

What is the result there?

 

Thanks,

Rahul Rashu

Answer 4

Rahul,

I have used Reporting Services (SSRS) in Visual Studio to develop the report. How can I put breakpoint for a report in SSRS? As per my knowledge, I can put breakpoints when there is any code(.Net or C..) in Visual Studio... Please correct me if I am wrong..