Creating Reports

[Luis Roberto]

Hi, I am an asp.net web form developer migrating my project to Blazor and I just discovered Syncfusion blazor components, and they are great.

What I haven't still figured out is how to create reports. 

I see that the Essential Studio Enterprise Edition Community License includes the Report Viewer SDK to visualize reports. But How do I create them?, Web forms developer used to use Crystal Reports to design reports getting data from the database using datasets.

Can we create reports from code and then visualize them on the report viewer? 

Is there a product symilar to Crystal Reports on Syncfusion? 

It is included on the communty license or it has to be bought?

Thank you very much

[Manoranjan Rajendran]

  

Hi Luis, 

 

Please find details from below table, 

 

Queries	Details
What I haven't still figured out is how to create reports.     I see that the Essential Studio Enterprise Edition Community License includes the Report Viewer SDK to visualize reports. But How do I create them?, Web forms developer used to use Crystal Reports to design reports getting data from the database using datasets.	Using our Bold Report designer component you can create the report and getting data from database using dataset. https://www.boldreports.com/embedded-reporting     Getting started for Blazor Report designer.  https://help.boldreports.com/embedded-reporting/blazor-reporting/report-designer/add-report-designer-to-a-blazor-application/
Can we create reports from code and then visualize them on the report viewer?	Yes, you can create the report from code and visualize them in Report viewer and Writer. Please refer the below documentation for create Report programmatically ,  https://help.boldreports.com/report-viewer-sdk/aspnet-core-reporting/report-viewer/how-to/generate-rdl-rdlc-report-programmatically/     https://help.boldreports.com/report-viewer-sdk/aspnet-core-reporting/report-writer/how-to/generate-and-export-rdl-rdlc-report-programmatically/
Is there a product similar to Crystal Reports on Syncfusion?	We don’t have support for Crystal reports. Need to convert the crystal report to RDL for using with Bold Reports.   https://help.boldreports.com/report-viewer-sdk/faq/how-to-convert-crystal-reports-to-rdl-for-bold-reports/
It is included on the community license or it has to be bought?	No, its not include with community licence for Report designer. You have to purchase our Bold Reports Embedding SDK for Report Design.     Please refer below getting started for Report designer in blazor application,  https://help.boldreports.com/embedded-reporting/blazor-reporting/report-designer/add-report-designer-to-a-blazor-application/     Note: If you are having any problem to get the access of Embedding SDK with Bold Reports then you must contact sales team to provide more details about your license and direct you to get the Embedding SDK in Bold Reports.    Please refer the below document for different between Embedded Reporting tools and Report Viewer SDK in Bold Reports  https://help.boldreports.com/embedded-reporting/faq/what-are-the-differences-in-embedded-reporting-and-report-viewer-sdk/     Please refer the below document for our license model,  https://help.boldreports.com/embedded-reporting/licensing/faq/what-are-the-difference-in-bold-reports-licensing-models/       We also have standalone Report designer for creating RDL and RDLC reports.  https://www.boldreports.com/account/downloads/standalone-report-designer

 

 

Regards, 

Manoranjan R 

[Jimmy De La Garza]

Is it possible to integrate the report designer into a Blazor WASM project, or does it have to be a Blazor Server project?

[Padmanaban Nanthagopal]

Jimmy,

 

We cannot integrate our component with the Blazor WASM. Our component have service dependencies with Asp.net core, so you have to use Bold Reports designer with Blazor WebAssembly App with the combination of ASP.NET Core Hosted only. 

We already logged a feature task for this, and it will be available in any of our upcoming releases. You can track this feature using the below feedback link,

https://www.boldreports.com/feedback/27640/using-bold-reports-with-blazor-webassembly-wasm-client-app

[Charles]

I want to use embeded Boldreport Viewer in my WASM page.

So, I checked https://github.com/boldreports/blazor-webassembly-reporting-components/blob/master/Pages/ReportViewer.razor

and

1. I made Blazor Web API project for ReportViewer service

[Route("api/[controller]/[action]")]

[ApiController]


public class ReportViewerController : ControllerBase, IReportController

{

    private IMemoryCache _cache;


    private IWebHostEnvironment _hostingEnvironment;





    public ReportViewerController(IMemoryCache memoryCache, IWebHostEnvironment hostingEnvironment)

    {

        _cache = memoryCache;

        _hostingEnvironment = hostingEnvironment;

    }




    [ActionName("GetResource")]


    [AcceptVerbs("GET")]

    public object GetResource(ReportResource resource)


    {

        return ReportHelper.GetResource(resource, this, _cache);

    }




    [NonAction]


    public void OnInitReportOptions(ReportViewerOptions reportOption)

    {

        string basePath = _hostingEnvironment.WebRootPath;

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


        MemoryStream reportStream = new MemoryStream();


        inputStream.CopyTo(reportStream);

        reportStream.Position = 0;

        inputStream.Close();

        reportOption.ReportModel.Stream = reportStream;

    }




    [NonAction]


    public void OnReportLoaded(ReportViewerOptions reportOption)

    {

    }




    [HttpPost]

    public object PostFormReportAction()

    {

        return ReportHelper.ProcessReport(null, this, _cache);

    }




    [HttpPost]


    public object PostReportAction([FromBody] Dictionary<string, object> jsonArray)

    {

        return ReportHelper.ProcessReport(jsonArray, this, this._cache);

    }

}




2. I made Blazor WASM project
   I used follow function in the WASM page to use Boldreport Viewer

        // Used to render the Bold Report Viewer component in Blazor page.

        public async void RenderReportViewer()

        {

            viewerOptions.ReportName = "sales-order-detail.rdl";

            viewerOptions.ServiceURL = "https://localhost:5001/api/ReportViewer";

            await JSRuntime.InvokeVoidAsync("BoldReports.RenderViewer", "report-viewer", viewerOptions);

        }

*. when i run it, I got follow error.

{"messages":[],"source":"Sea.Api.Infrastructure.Auth.Jwt.ConfigureJwtBearerOptions+<>c","exception":"Authentication Failed.","errorId":"73301da9-30b9-4a48-8cc5-55705780b119","supportMessage":"Provide the ErrorId 73301da9-30b9-4a48-8cc5-55705780b119 to the support team for further analysis.","statusCode":401}

-> I added Cors related code in the Program.cs of Web API project

    builder.Services.AddCors(options =>

    {

        options.AddPolicy("AllowAllOrigins", builder =>

        {

            builder.AllowAnyOrigin().AllowAnyMethod().AllowAnyHeader();

        });

    });

-> Bust, still have error.

[Arumugasami Murugesan]

Hi Charles,

Thanks for contacting Bold Report support.

We have already created a ticket for your query. Please check the ticket from the below site and follow further.

https://support.boldreports.com/support/tickets

Regards,

Arumugasami M