Show report with CSV data on web using JSViewer?

Show report with CSV data on web using JSViewer?

Posted by: khun_panya on 9 December 2024, 1:15 am EST

• 

  khun_panya

  • Post Options:
  • Link
    Copy

  Posted 9 December 2024, 1:15 am EST

  I don’t quite understand the design of ActiveReports.NET. I use the latest version of ActiveReports Designer (18.2) to create an RDLX with SQL Server data source. It runs fine at design time, and I also have a successful putting it on a web application using JSViewer with openReport command. However, when I created an RDLX that use a CSV file as data source, it worked during design time but failed to run on the web. I suspect this is because the RDLX file is only pointing to the file location without embedding the data. Since the CSV file path is inaccessible from the web, what is the proper way to display an RDLX created with a CSV data source?

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 9 December 2024, 5:39 am EST

  Hi Panya,

  You can use a relative path to the CSV data source with respect to your report for example: ‘.\YourCSVFile.csv’ if the file exists in the same directory as the report.

  Please find attached a sample implementing the same for your reference.

  Regards,
  
  Anand

  WebDesigner_MVC.zip

• 

  khun_panya

  • Post Options:
  • Link
    Copy

  Posted 9 December 2024, 9:18 pm EST

  Thanks for the code. I should probably spend some time studying it.
  
  One more question. Is it possible to programmatically edit data source at runtime to feed the in-memory generated CSV instead of having to load from physical file storage.