Displaying Custom Reports in Blazor using Syncfusion

In our last video, we created a custom report using the Bold Reports Designer. We could use the provided Bold Reports Viewer to display the reports, but that does not always fit with what you want to accomplish. That is why today we will implement a report viewer in a Blazor Server application. That way, we can show our custom report to our clients directly inside of our site instead of sending them to a separate application.
Syncfusion Components: bit.ly/387BBoP
Bold Reports: bit.ly/3Nly2uz
Blazor Components: bit.ly/3Oi7M5P
Full Training Courses: IAmTimCorey.com
Source Code: leadmagnets.ap...
Mailing List: signup.iamtimc...

[@yasinnabi]

So good to watch nice and beautiful videos like this thanks for sharing..,..,

[@IAmTimCorey]

You are welcome.

[@subashbarik]

Great Video, I always learn a lot from your videos.

[@IAmTimCorey]

Glad to hear it!

[@marceloleoncaceres6826]

Thank you Syncfusion, your components are great!

[@IAmTimCorey]

Thanks for watching.

[@siswaabadi3585]

Thank u for this videos. This really helps.

[@IAmTimCorey]

You are welcome.

[@g11a]

OMG this is a lot of work just to display a report: So many places where the code could break... What I ended up doing with Syncfusion is creating my report manually as an in-memory DOCX file on the server, converting it to PDF (in-memory as well), and then streaming that to the browser for display and local save. I'm not sure what the rationale is for making BoldReports so complicated. In the Old days, when CrystalReports was bundled with VS, it was also much simpler: Design the report, create the RPT file, and run that against your data source to generate the report. Do you have any insight as to what could possibly require this product to be so complex? With so many references and dependencies that could break everything really quickly (eg, update referenced libraries and forget to update the CDN references to the matching version), it feels like these projects you'd not want to touch or update referenced library versions because you do not know what will break. Thoughts/comments?

[@IAmTimCorey]

This isn't really any less complex than Crystal Reports was back in the day. I know having lots of references and NuGet packages looks scary, but it is actually a good thing. By having all of these references, we can upgrade just what we need. So maybe the CSS has an update we want, but we don't want to touch the JavaScript part. No problem, just upgrade the CSS reference. With Crystal Reports, the philosophy was "jam everything into one reference and bake half of it into the .NET Framework". That was messy, since then you were tied to either upgrading your entire application, including your Crystal Reports, or not upgrading your application at all. That wasn't ideal. By the way, two little things that might help put your mind at ease: First, the code that I wrote basically doesn't change. Once you get that code in place (or make a template out of it), the only thing that changes is the file name for the report. Second, the versions won't change without you telling them to. That's the beauty of this system. Yes, that means you are responsible for updating all of them when you decide to do an update, but it also means updating one doesn't require you to update everything.

[@g11a]

@@IAmTimCorey It just feels like Syncfusion could do another pass at simplifying all of this for us. But you are right, Crystal Reports brought another level of complexity all on its own (ie, could not upgrade VS versions until Crystal Reports came out with a new version that supported it, etc)

[@sopheakuk]

hi Tim, May I know we can print directly without view report?

[@alexandervillegas5683]

You are excelent teacher, I have aproblem, now is that the parameters of my report are of different data types, integers, strings, datetime, float, etc. How could I send parameters of different data types?

[@IAmTimCorey]

Just like any other parameter.

[@Victornyore]

Good. But if you want to dynamicaly load multiple reports. where do you tweak in the api.

[@nelsonrivers8546]

Your style of training is great Tim. I'm a big fan. Keep up the great work. This is another great video.

[@IAmTimCorey]

Thank you!

[@keithprice3369]

Two questions: 1: Everything we need will be in our project? We don't need to install anything (Like Report Server) on the server? 2: Is this covered by the Community license?

[@IAmTimCorey]

Yes and yes.

[@pgnutz]

Hi Tim, very good!

[@IAmTimCorey]

Thank you.

[@mazharpatel784]

Please can you make a video on how Blazor server app can be deployed and hosted on any website.

[@reville2004]

Hi Tim , is it possible to pass user selected parameter values to the report parameter?

[@ruiflorencio5880]

Is bolod reports free for purchasers of syncfusion blazor components? is royalty free?

[@IAmTimCorey]

The Bold Reports designer is free for everyone. You can build a report viewer like we did here as part of the Essentials tools, which does not require a Bold Reports license.

[@ruiflorencio5880]

@@IAmTimCorey thanks

[@diel2813]

Great video 😀 I have been using Fast Report because it's quick and simple to use.

[@IAmTimCorey]

Thanks for sharing.

[@saitoreeper]

Can it read from SSRS? instead of specifying an rdl in the project

[@dajma00]

How do you actually create the report itself?

[@IAmTimCorey]

I covered that in the previous video: kzbin.info/www/bejne/mWGwiGybi5mVd6c

[@teklitag]

how can a user should input data to make the reports or to update it

[@FufaTujuba]

Great tutorial as always. I have question how to pass user credentials to .rdl parameter from the server/controller so that report will be filtered by user Id or user name.

[@haneenalfakhry2487]

I want the source code please , I could not get it from the link above

[@IAmTimCorey]

Email [e-mail] to get help.

[@michael.a.strauss]

Great video but the source code link doesn't seem to work. I've attempted to use it with both a personal and business email address and neither received any link or download of source code. Checked in spam/junk as well.

[@IAmTimCorey]

Email [e-mail] and Tom will help you out.

[@michael.a.strauss]

@@IAmTimCorey Thanks for the info. I was, in the end, able to see where I went awry. I was looking to simply compare my own code to download but I just watched (and re-watched) to figure out my mistake 🙂Thanks again!

[@mazharpatel784]

Any reason why Microsoft has not provided Report viewer when they have designed Blazor. Why do we have to depend on third party nuget packages.

[@IAmTimCorey]

Microsoft's goal is not to provide you with every tool you will need to build an application. Their goal is to provide you with the language capabilities for you to build your own tools to build your applications just how you want them. They create the LEGOs, you build the buildings with them. Creating a reporting tool that will satisfy everyone is impossible, so while Microsoft has provided us with a lot of libraries and systems, reporting is not one of them. That is up to you to build or to buy from a third-party vendor (I would recommend the latter - there are some great options out there).

[@ronaldbmaghilum]

For telerik report, how to use it in blazor wasm

[@IAmTimCorey]

Thanks for the suggestion. Please add it to the list on the suggestion site so others can vote on it as well: suggestions.iamtimcorey.com/

[@selahattinkaradogan2744]

where can i find sourcecode of this project

[@IAmTimCorey]

There is a link in the description.

[@wisamidris]

You Can Collect All FIles In Single File

[@IAmTimCorey]

I’m not sure what this means.

[@wisamidris]

@@IAmTimCorey Mean You Hack

[@coolwaterdvr]

I'm getting a blank report. I went back and checked the code to the letter. Still my report viewer is not loading data. 😞

[@IAmTimCorey]

Check your connection string. It has to be correct for your computer.

[@coolwaterdvr]

@@IAmTimCorey I deleted my code and redid everything. Its working now. Thanks for the lesson it helped me a lot. My next goal is how to make a report with a dataset (mine is from a storedproc) that has a parameter so that when the report consumes the data it is already filtered. I'm still looking for a solution in the bold reports documentation. 😁

[@keithprice3369]

@@coolwaterdvr Did you ever come up with a good solution?

[@azeemarshad3309]

Hi Tim, I followed your tutorials its really helpful and your way of teaching is awesome want to do this with Rest APi and have to show data in any of Report Viewers can you please tell me how can we use Rest APi.

[@unskeptable]

Is this free to use ? I see huge watermarks there

[@IAmTimCorey]

Yep. I just didn’t add the license key. I explain that in the Intro to Syncfusion video.

[@talkathiriify]

Thank you very much for this nice tutorial Tim. Could you please show how to send the "id?" to the report controller as in this template [Route("api/{controller}/{action}/{id?}")] from a blazor page. Your help will be highly appreciated.

[@marjukerazi1089]

bold report is paid...if there any way ?

[@IAmTimCorey]

The community license is free, provided you qualify: www.syncfusion.com/downloads/communitylicense

[@rahulsbhatt]

Hey amazing video, I had a question, can this sync fusion be used to generate pdf from rdlc using process report helper function? Since I wanted to use this in a web api where I'll just return base 64 string of the pdf

[@IAmTimCorey]

I believe so, yes.

[@philibertande3097]

Somebody is using this email

[@IAmTimCorey]

I'm not sure what that means.

[@philibertande3097]

The getting code does not work. Nothing is sent, which is kind of annoying A github link would be more appropriate to say the least.

[@IAmTimCorey]

Check your spam folder. Some email providers automatically filter out source code because they think it is dangerous. If you don't find it in your spam folder, email [e-mail] and we will get it to you a different way.

[@marcdurtal6005]

Where is the C# code of this program?!! You don't expect people typing all that I guess especially all the cdn!

[@IAmTimCorey]

As I stated in the video, the source code link is in the description. However, I do think that people would benefit from retyping what I typed. Just getting the end result often means people don't do it on their own as well. Typing things out actually does make a difference when it comes to learning.

[@arpitpoddar5849]

Hello

[@IAmTimCorey]

👋

[@psladek]

First

[@vyacheslavgrinko9993]

XD

[@IAmTimCorey]

👋

[@eth6706]

Don't do this. Use Power BI.

[@IAmTimCorey]

That's bad advice. Deciding that any one solution is the "only right solution" is folly. For instance, I just showed you how to build and display reports for free for companies that make less than $1 million annually. For those over that, it would cost them $2,500/developer. Power BI costs between $10 and $20 per user per year. Not per developer, per user. Imagine if you had a company with 100 users. That's between $1,000 and $2,000 per year. The developer's license will cost $2,500 for the first year and $900 per year after that. With just 100 users, it will be cheaper to go the Syncfusion route (and probably easier to host and maintain). If you have 1,000 users, your costs would be between $10,000 and $20,000 per year with Power BI. Do you see how making a blanket statement like that doesn't work? You may be counseling them on a good course of action or a horrible one. You don't know. Power BI is definitely an option, and it can be a good one, but it doesn't solve every problem, nor is it the right solution for everyone.