Generate report on controller with an EF DB as datasource

Generate report on controller with an EF DB as datasource

Posted by: sebastian73 on 9 August 2023, 8:17 am EST

• 

  sebastian73

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 August 2023, 8:17 am EST

  Hi!
  
  I need some help on the way to implement the report generation for my solution, I was unable to solve it using the documentation.
  
  My app is an ASP.NET MVC Core solution, but I have the Studio Enterprise, and I need to generate report without an external or additional api.
  
  My main problem is how to generate the reports definitions using the designer, my database is using Entity Framework, so I want to use “object in external assembly”.
  
  Can you provide some examples on:

  • how to connect the report designer to custom classes that will contain the data.
  • Generate the report on the controller using the C1FlexReport class, using as DataSource the data generated by app logic gathered form EF classes and send a PDF to the PDFViewer on a View.

  Thanks in advance!!

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 9 August 2023, 6:26 pm EST - Updated 9 August 2023, 6:32 pm EST

  Hello,
  
  Please refer to the following screenshot to bind the FlexReport with the Object in the external assembly.
  
  The sample is under ComponentOne Samples\WinForms same as the specified path in the screenshot.
  
  This sample shows how to generate the DLL that can be used as RecordSet in the FlexReportDesigner or the FlexReport in the C# code.

  

  1111×441 32.3 KB

  
  
  Please refer to the following documentation that shows how to bind the FlexReport to DataSource:
  
  https://www.grapecity.com/componentone/docs/win/online-flexreport/DataSourcesinFlexReport.html

  *** Generate the report on the controller using the C1FlexReport class, using as DataSource the data generated by app logic gathered form EF classes and send a PDF to the PDFViewer on a View.

  You would like to generate the PDF and send to the PDFViewer. But setting up the PDFViewer also required the ComponentOne WebAPI PDF service. So in the same way you may also setup the C1 WebAPI report service that can direct show the FlexReport in the FlexViewer.

  If you would like to customize the DataSource dynamically, please refer to the attached sample that shows how to customize the FlexReport data source.

  Hope it helps!

  Regards,
  
  Manish Gupta

  CustomReportViewer_Param.zip

• 

  sebastian73

  • Post Options:
  • Link
    Copy

  Posted 10 August 2023, 4:21 am EST

  Thanks for your help and guidance!!!