how to execute sub-reports for a SSRS report.

Question

i have created this report but i dont know how to execute it when i tried to run this it shows as entered the URL . i tried to get a url in sql server configuration manager services it does not open .anyone suggest me how to solve this? how to get URL ? any other way to run this report.

Durga Velusamy · Answer

Hi amit,thanks for your support. I solved the issue by changing sql server configuration and created url. I used this url to report it's working well.

Amit Gupta · Answer

Haven't you used config file to store connection string?

Durga Velusamy · Answer

hi , already every has ProcessingMode = Local . tell me how to give common db configuration to report server project instead of giving db connection to each report.

Amit Gupta · Answer

Make sure you had put ProcessingMode = Local instead of server and then try. I would also suggest you to look at the videos link that I had posted in my earlier post for better understanding.

Durga Velusamy · Answer

hi Amit, Its not even fired that subreportproceessing method. two method i tried one is web application with ssrs this is only came the above problem. second method is report server project here ssrs report only no webforms and webconfig page. now i had done the reports in report server project its working fine but each report asking db connection .its comfortable for only developing system but when try to run in another system means i wont work for this issue to avoid have common db configuration how to give the option. you suggest is it i'm correct

Amit Gupta · Answer

Hey Durga Please clarify what's not working, as from the snapshot it cannot be determined, whats the issue. Explain the problem that you are getting after implementing it. Any exception/error?

Durga Velusamy · Answer

hi , i tried as u said but not working is anything i missed here. i have attached screen shot SqlCommand cmd = new SqlCommand("SP_Get_IRD_GateEntry_Rpt", con); cmd.Parameters.Add(new SqlParameter("@Status_ID", Convert.ToInt32(Request.QueryString["Status_ID"]))); cmd.CommandType = CommandType.StoredProcedure; sda.SelectCommand = cmd; sda.Fill(dt); sda.Fill(IndentRecipt_Details, "IRD_GateEntry"); cmd = new SqlCommand("SP_Get_IRD_GRN_Rpt", con); cmd.Parameters.Add(new SqlParameter("@Indentid", Convert.ToInt32(Request.QueryString["Indent_id"]))); cmd.CommandType = CommandType.StoredProcedure; sda.SelectCommand = cmd; sda.Fill(dt); sda.Fill(IndentRecipt_Details, "IRD_GRN"); con.Close(); //Providing DataSource for the Report ReportDataSource rds_GE = new ReportDataSource("IRD_GateEntry", IndentRecipt_Details.Tables[0]); ReportViewer1.LocalReport.DataSources.Clear(); //Add ReportDataSource ReportViewer1.LocalReport.DataSources.Add(rds_GE); ReportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(SubreportProcessingEventHandler); this.ReportViewer1.LocalReport.Refresh(); } catch (Exception ex) { } } } //subreport processing event void SubreportProcessingEventHandler(object sender, SubreportProcessingEventArgs e) { e.DataSources.Add(new ReportDataSource("IRD_GRNDS", IndentRecipt_Details.Tables[1])); }

Amit Gupta · Answer

Before refreshing your report, just add the eventhandler, your code will looks like below sda.Fill(IndentOpenOrder, "IndentOpenOrder" ); con.Close(); //Providing DataSource for the Report ReportDataSource rds = new ReportDataSource( "IndentOpenOrder" , IndentOpenOrder.Tables[0]); ReportViewer1.LocalReport.DataSources.Clear(); //Add ReportDataSource ReportViewer1.LocalReport.DataSources.Add(rds); // add subreport eventhandler this .reportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(SubreportProcessingEventHandler); // finally refresh the report this .reportViewer1.RefreshReport(); //subreport processing event void SubreportProcessingEventHandler( object sender, SubreportProcessingEventArgs e) { e.DataSources.Add( new ReportDataSource( "DataTableName" , DataTableValue )); } Here is the video's link that will be useful to you https://www.youtube.com/watch?v=2-YkNo1Os3Y https://www.youtube.com/watch?v=7AvCaq7a1fc Good Luck

Durga Velusamy · Answer

hi amit, thanks for your help. i have given my code below of main report its working well but when try open subreport its does not work. tell me where i have add event subreport processing after this code ? i did but its not call that method. but when try to open empty subreport with just text msg its showing the subreport , when try to get dataset values its getting error as location of the report not exist or report not published. my mail id is durgauranic@gmail.com can you send mail to me sda.Fill(IndentOpenOrder, "IndentOpenOrder"); con.Close(); //Providing DataSource for the Report ReportDataSource rds = new ReportDataSource("IndentOpenOrder", IndentOpenOrder.Tables[0]); ReportViewer1.LocalReport.DataSources.Clear(); //Add ReportDataSource ReportViewer1.LocalReport.DataSources.Add(rds);

Amit Gupta · Answer

The link provided in the previous post will help you to do the processing. Can you share your code, so that we can examine the issue

Durga Velusamy · Answer

i already tried this not working i think i missed something can u explain in detail.

Amit Gupta · Answer

The design of sub reports will not be visible in main report. There is an event called subreport processing in tge report's object. https://support.microsoft.com/en-in/help/919157/how-to-display-a-report-that-contains-a-subreport-by-using-the-reportv

how to execute sub-reports for a SSRS report.

Answers (12)