Hello Tim. For me, this video is absolute GOLD! I've been using the report designer inside Visual Studio for many years and was looking for a path forward that wouldn't be a complete overhaul and wouldn't break the bank. I believe this will be a large part of the answer for us. Thanks!! (Rob)
Great video dear Tim I was currently adding reports to my system and searching and planning to create a standard for creating reports on my system. Thanks again dear Tim and keep it up
Tim, well done. I have lost count of how many times I've tackled this subject, with expensive 3rd party tools (The latest being bold reports from SF) and you've just wrapped up a method I will now use forever in little over 30 minutes. Last project I was working on that required doing this, we where converting a bunch of Grape City reports that where all designed using the old windows forms esc designer, in a custom OCX add on for VS, that was an absolute nightmare to get the report definitions into a more sensible format. I've long known that you could plug in your own data like this, but for some reason I was never quite able to make it work, you've now set the blue print. The ONLY thing I now have to figure out how to do, is how to add an image (In my case a thumbnail) to a report list, that can be populated in a report using the image control. Peter "Shawty" Shaw
PS: Figured out how to do images 🙂 Set the field up exactly as you do for the standard text fields, as shown in your demo, only instead of using a text box, use an image, set it's type to "Database" but don't fill anything else in. Then in your C# model, set the field type in your class to byte[] and load the image you want to use into that byte array (I used File.ReadAllBytes) and hey presto, works just as simply. I can now use this to produce "thumbnail brochures" in the image list PDF's my image search app I wrote for the local history charity I help run, when someone requests a list of old images from thier archive.
Yes there is indeed. infact, the 4.8 version is the official microsoft package which was ported to .net core. just search for and install Microsoft Report Viewer once you install report viewer, you can add a reference to it in visual studio and use it basically identically to the .netcore version here is some sample code i found via AOL web crawler search: www.c-sharpcorner.com/article/asp-net-mvc-5-angularjs-create-pdf-file-using-microsoft-report/ disregard that it's listed as angular, the sample has absolutely nothing to do with angular
Thanks Tim for the example with local report. Is there a way of generating report on ssrs report server and passing the byte array back to the asp.net core app as sub reports cannot be run locally?
The purpose of this approach is for those not using SSRS. If you are using SSRS, then you don't really need to create a local rdlc or use POCOs. SSRS provides a webservice where you can execute reports remotely, passing in the params and optionally exporting to PDF (and other formats) That being said, in general subreports are supported by this local RDLC with POCO approach. they work the same as the orginal .NET Framework Report viewer. here is an example of the code to handle subreports; it's in wpf but the C# logic is the same www.c-sharpcorner.com/article/rdlc-subreport-using-c-sharp-and-wpf/
Because the option is using POCOs, it's database agnostic. you could load your class with data from anything you want. In fact, you could load the data from a Json file stored on a 1.44" Floppy disk :) -Create the class models (POCOs) -Load them from any datasource you want -send them in to the report -party
@@dispinser548 according to their documentation it will run on linux. I haven't try containerizing it or running it on linux myself, you might look through the github wiki and questions to see if there is a solid answer github.com/lkosson/reportviewercore
I'm not 100% sure. Quite a while back used GetItemDefinition as part of the ReportServices package. I don't know if that's still the recommended approach. For my specific cases, i'm typically trying to avoid SSRS. As a result i'm not pulling the definitions from SSRS, they are just included as content files in my application deployment
This is one of the most informative videos about windows reporting I've ever watched. Thanks for sharing.
Thank you for your exceptionally positive feedback!!
Hello Tim. For me, this video is absolute GOLD! I've been using the report designer inside Visual Studio for many years and was looking for a path forward that wouldn't be a complete overhaul and wouldn't break the bank. I believe this will be a large part of the answer for us. Thanks!! (Rob)
Rob, I'm very glad to hear the video was useful. thanks for the comment and good luck! :)
Great video dear Tim I was currently adding reports to my system and searching and planning to create a standard for creating reports on my system. Thanks again dear Tim and keep it up
Faisal, I'm happy to hear you found value in the content!
@@TimBurris, It's my pleasure
Brilliant. Thanks Tim, exactly what I was looking for.
Awesome, I'm truly glad this was able to help you out!
Thanks for this example with Microsoft Report Builder
I'm glad you found it useful!
Tim, well done. I have lost count of how many times I've tackled this subject, with expensive 3rd party tools (The latest being bold reports from SF) and you've just wrapped up a method I will now use forever in little over 30 minutes.
Last project I was working on that required doing this, we where converting a bunch of Grape City reports that where all designed using the old windows forms esc designer, in a custom OCX add on for VS, that was an absolute nightmare to get the report definitions into a more sensible format.
I've long known that you could plug in your own data like this, but for some reason I was never quite able to make it work, you've now set the blue print.
The ONLY thing I now have to figure out how to do, is how to add an image (In my case a thumbnail) to a report list, that can be populated in a report using the image control.
Peter "Shawty" Shaw
PS: Figured out how to do images 🙂
Set the field up exactly as you do for the standard text fields, as shown in your demo, only instead of using a text box, use an image, set it's type to "Database" but don't fill anything else in.
Then in your C# model, set the field type in your class to byte[] and load the image you want to use into that byte array (I used File.ReadAllBytes) and hey presto, works just as simply.
I can now use this to produce "thumbnail brochures" in the image list PDF's my image search app I wrote for the local history charity I help run, when someone requests a list of old images from thier archive.
thank you so much for the positive feedback! Very glad you found the content useful and kudos to you getting the image from data working so quickly!
Thanks much for this video.
Please make more videos on .net
Thank you for watching, and for your feedback. More. net to come!!
Excellent tutorial! Is there any equivalent of this for the old 4.8 version?
Yes there is indeed. infact, the 4.8 version is the official microsoft package which was ported to .net core. just search for and install Microsoft Report Viewer
once you install report viewer, you can add a reference to it in visual studio and use it basically identically to the .netcore version
here is some sample code i found via AOL web crawler search:
www.c-sharpcorner.com/article/asp-net-mvc-5-angularjs-create-pdf-file-using-microsoft-report/
disregard that it's listed as angular, the sample has absolutely nothing to do with angular
Thanks Tim for the example with local report. Is there a way of generating report on ssrs report server and passing the byte array back to the asp.net core app as sub reports cannot be run locally?
The purpose of this approach is for those not using SSRS. If you are using SSRS, then you don't really need to create a local rdlc or use POCOs. SSRS provides a webservice where you can execute reports remotely, passing in the params and optionally exporting to PDF (and other formats)
That being said, in general subreports are supported by this local RDLC with POCO approach. they work the same as the orginal .NET Framework Report viewer. here is an example of the code to handle subreports; it's in wpf but the C# logic is the same www.c-sharpcorner.com/article/rdlc-subreport-using-c-sharp-and-wpf/
Hi, this only support for database sql server ? how about another database such as mysql and postgresql still same ?
Because the option is using POCOs, it's database agnostic. you could load your class with data from anything you want. In fact, you could load the data from a Json file stored on a 1.44" Floppy disk :)
-Create the class models (POCOs)
-Load them from any datasource you want
-send them in to the report
-party
@@TimBurris oh ya another question, about report builder we can run it in linux based? Containerize or can deploy it to docker or k8s ?
@@dispinser548 according to their documentation it will run on linux.
I haven't try containerizing it or running it on linux myself, you might look through the github wiki and questions to see if there is a solid answer
github.com/lkosson/reportviewercore
Hello, How to read files from SSRS server
I'm not 100% sure. Quite a while back used GetItemDefinition as part of the ReportServices package. I don't know if that's still the recommended approach. For my specific cases, i'm typically trying to avoid SSRS. As a result i'm not pulling the definitions from SSRS, they are just included as content files in my application deployment