Export Wijmo Grid to PDF report with parameters

Export Wijmo Grid to PDF report with parameters

Posted by: kapil.r.shah on 16 October 2019, 2:16 am EST

• 

  kapil.r.shah

  • Post Options:
  • Link
    Copy

  Posted 16 October 2019, 2:16 am EST

  Hi,
  
  I want to render a Wijmo Grid data into a pdf report.

  I want to mention the filter parameters used to display the data on Wijmo Grid on the pdf report.
  
  The parameters are : StartDate, End Date, User , Application Type
  
  I also need Header ,Footer

  At the end of the report , I want to a section for the managers to sign the report.

  What PDF API should I use for the pdf report for the requirement above.

  A sample application with report will be helpful

  Thanks,

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 16 October 2019, 8:06 pm EST

  Hi Kapil,

  You could simply use the pdf module of Wijmo. The pdf module contains API to create simple PDF documents. Also, you can directly draw the FlexGrid using the FlexGridPdfConverter class. Please find the sample attached for reference. For more information, refer to the links below:

  • "* “pdf module: https://www.grapecity.com/wijmo/api/modules/wijmo_pdf.html”
  • “FlexGridPdfConverter class: https://www.grapecity.com/wijmo/api/classes/wijmo_grid_pdf.flexgridpdfconverter.html”
  • “PDF demo: https://www.grapecity.com/wijmo/demos/PDF/Overview/angular”
  • “PDF docs: https://www.grapecity.com/wijmo/docs/Topics/PDF/Overview”
    
    "

  Let us know if you any issues or have any additional queries.

  Regards,
  
  Ashwin

  wijmo-pdf-angular.zip

• 

  kapil.r.shah

  • Post Options:
  • Link
    Copy

  Posted 20 October 2019, 6:25 am EST

  Hi Ashwin,
  
  I have master detail wijmo grid. I want to generate a pdf report which will show parent child i.e master detail data. Which API will help me generate master child data.

  Will FlexGridPdfConverter class support generation of pdf report with parent child data?

  I also came across
  
  PDFViewer
  
  ReportViewer –
  
  JS Viewer.

  So what would be the best option for me to generate pdf report with parent -child data and mention parameters like startdate, enddate, user use to generate the report.

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 20 October 2019, 9:02 pm EST

  Hi Kapil,

  To also draw the detail rows, you will need to use the drawDetailRows property and then use the formatItem event of IFlexGridDrawSettings to draw the detail rows. Please find the attached sample for reference.

  Regarding PDFViewer, etc:

  The names that you provided are the viewer controls. They are not used to create PDF or Reports. They are just used to show and already generated PDF or reports. If you create a PDF using the Wijmo’s PDF API, you can show the PDF document using the PDFViewer control.

  Let me know if you still have any doubts.

  ~regards

  wijmo-pdf-angular.zip

• 

  kapil.r.shah

  • Post Options:
  • Link
    Copy

  Posted 21 October 2019, 11:58 pm EST

  I ran the sample project. I see that I have to select the icon to expand the detail rows data of each parent and then run the report in order to see the details rows data on the PDF report.

  Is it possible to render the pdf report without expanding detail rows on the grid using IFlexGridDrawSettings?

  What other options I have?
  
  Is it possible to generate the pdf report with parent- child data using Active Reports and then use the PDF Viewer / JS viewer to show the report on the client side.

  Thanks,

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 23 October 2019, 7:51 pm EST

  Hello,

  While PDF is exporting the Detail Rows content should be present in the DOM to render in PDF. Hence, it is required to expand the Detail Rows

  Is it possible to generate the pdf report with parent- child data using Active Reports
  
  Yes, it is possible with AR using the following feature:
  
  https://help.grapecity.com/activereports/webhelp/AR13/webframe.html#NestedDataRegionsBoundtoDifferentData.html
  
  I have created the sample application to implement the same. Please refer to the attachment.
  
  JSViewer_MVC (5).zip

  Thanks,
  
  Mohit