subreports and RDLC

[Walter Martin]

Is it possible to use the subreports with the RDLC files ?

I'm trying to add one in report designer tool but I get the error message in attachment when I click in the property - basic settings - three dots to select the report associated

My goal is to create the report in my second attachment, and for this reason I suppose I need to use the subreports.

As you can see I have two levels group and some lines of details but using a simple table and using the grouping functions showed in your blog and support pages, I'm not able to show the informations one above the others like in my attachment. 

Is there a way to achieve this result ?

Thanks

Regards

Walter

Attachment: files_56ba5ede.zip

[Manoranjan Rajendran]

Hi Walter, 

 

Yes, it’s a possible to use subreport in RDLC report. In standalone report designer application we don’t have option to connect the server so that a reported issue is occurs. Provide report path as text in as like a in input box. 

 

 

 

Now using subreport you can create your report. Alternatively  we can create a report with  using List Report item and Tablix Report item for your requirement.  

Sample : https://www.syncfusion.com/downloads/support/directtrac/general/ze/TestREPORT_(1)-593881502.zip 

  

Regards, 

Manoranjan R 

[Walter Martin]

Thanks Manoranjan

I didn't test yet your suggestion about subreports because I think your solution using list report and tablix would be perfect for my goal but I tried using them in my project and compiling the code with Visual Studio 2019 I received the following three errors:

I added in attachment my RDLC. what is it wrong comparing with yours ?

Attachment: Padre_Riepilogo_addetto_per_commesse_e7cf770f.zip

[Walter Martin]

I'm sorry, I found the solution by myself

I probably have an VisualStudio extension to manage the RDLC reports (used for ASP.Net projects) so if I don't include the RDLC files in the project everything works.

The result unfortunately is not what I aspected because the final layout now is correct but not the content because I need to group my data in tablix2 and tablix3 while tablix5 has the results.

Do I have to group the data in my query or can I use the grouping options inside the BoldReport designer ?

[Manoranjan Rajendran]

Hi Walter, 

 

Thanks for the update, 

 

Yes, you can use grouping option for Bold Reports Designer please refer the below documentation for grouping the data, 

https://help.boldreports.com/enterprise-reporting/designer-guide/report-designer/compose-report/group-data/ 

  

 Regards,  

Manoranjan R  

[Walter Martin]

Coming back to this request, I'm using now Blazor Server 19.3 and I need this time to use RDLC with a subreport inside a report

Using this piece of code I found in your documentation:

// Method will be called to initialize the report information to load the report with ReportHelper for processing.

        public void OnInitReportOptions(ReportViewerOptions reportOption)

        {

            string basePath = _hostingEnvironment.WebRootPath;

            if(reportOption.ReportModel.ReportPath.Substring(reportOption.ReportModel.ReportPath.IndexOf(".")+1) == "rdlc")

                reportOption.ReportModel.ProcessingMode = ProcessingMode.Local;

            if (reportOption.SubReportModel != null)

            {

                string path = basePath + @"\resources\FatCliDetSub.rdlc";

                FileStream SubStream = new FileStream(path, FileMode.Open, FileAccess.Read);

                reportOption.SubReportModel.Stream = SubStream;

            }

            else

            {

                FileStream reportStream = new FileStream(basePath + @"\resources\" + reportOption.ReportModel.ReportPath, System.IO.FileMode.Open, System.IO.FileAccess.Read);

                reportOption.ReportModel.Stream = reportStream;

            }

        }

        // Method will be called when reported is loaded with internally to start to layout process with ReportHelper.

        public void OnReportLoaded(ReportViewerOptions reportOption)

        {

            if (reportOption.SubReportModel != null)

            {

            }

       }

In the underlined step, the  reportOption.SubReportModel is correctly loaded but then, inside  "OnReportLoaded" event, the  reportOption.SubReportModel is null

why this happens ?

Thanks

Best Regards

[Arumugasami Murugesan]

Hi Walter, 

 

Thanks for the update. 

 

We will check and share the details for this on 25^th November 2021. 

 

Regards, 

Arumugasami M 

[Arumugasami Murugesan]

Hi Walter, 

 

Thanks for the update. 

 

We will check and share the details for this on 25^th November 2021. 

 

Regards, 

Arumugasami M 

[Arumugasami Murugesan]

Hi Walter, 

 

Thanks for the update. 

 

We will check and share the details for this on 25^th November 2021. 

 

Regards, 

Arumugasami M 

[Manoranjan Rajendran]

Hi Walter, 

 

We validated the reported issue and sub report model called with value in onReportLoaded method. In our initialization we invoke the OnInitReportOptions for getting report details and is report contain with sub report model we again invoke the OnInitReportOptions method for getting sub report details. Likewise in report processing we invoke the onReportLoaded model for sub report. 

 

Could you please check the attached sample. If still you are getting any issues. Please share the issue sample with us. Its helpful for our further validation. 

 

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/blazor-RDLC-1560365683 

 

Regards, 

Manoranjan R 

[Walter Martin]

Thank you  Manoranjan, my mistake, I didn't follow exactly what was suggested in the documentation.

Your sample gave me the right way to proceed

Best Regards

[Manoranjan Rajendran]

Hi Walter, 

Thanks for the update. 

If you have any other queries. Please create a new ticket from below site. We were always happy to assist you. 

https://support.boldreports.com/ 

Regards, 

Manoranjan R