ReportServer Forum

dkwfung

Member

Registered: 2024-04-25

How to export CSV format for Japerreport in ReportServer

Hi all,

I am using ReportSever Enterprise Edition v4.6.3 with Jasper Reports in it.
 
I would like to know if I could export the Jasper Reports in CSV format and how to do that.

Thank you

Regards,

David

Last edited by dkwfung (2024-06-27 04:32:37)

IF_Adrian

Moderator

Registered: 2021-10-29

Re: How to export CSV format for Japerreport in ReportServer

Hi David,

At the moment there is not out of the box way to export Jasper to CSV.
You can try to export the Jasper to plain-excel and do a manual conversion from there.

Kind regards,
Adrian

JL_Cosir

Member

Registered: 2025-12-04

Re: How to export CSV format for Japerreport in ReportServer

Hi,

I'm using ReportServer Community Edition v4.7.7 with Jasper Reports.

Is it possible to enable csv format while scheduling a report? I see that csv configuration file is available in fileserver files, but I can't see the option in the UI.

Thanks in advice.

Regards.

IF_Jasmin

Moderator

Registered: 2024-11-14

Re: How to export CSV format for Japerreport in ReportServer

Hello JL_Cosir,

Please try to access the report directly via URL.

Here is the documentation for it: https://reportserver.net/de/guides/admi … he-URL.php

Best regards
Jasmin

JL_Cosir

Member

Registered: 2025-12-04

Re: How to export CSV format for Japerreport in ReportServer

Hi IF_Jasmin, thanks for replying.

I tried to access the report directly via URL and works fine, but is there a way to "enable" csv format using the Scheduler?

Thanks!

IF_Jasmin

Moderator

Registered: 2024-11-14

Re: How to export CSV format for Japerreport in ReportServer

Hello JL_Cosir,

Unfortunately, this isn't a built-in feature in RS.

However, you could create a (plain) Excel spreadsheet and then export it as a CSV file with Excel.
Alternatively, you could create a script.

Best regards
Jasmin

JL_Cosir

Member

Registered: 2025-12-04

Re: How to export CSV format for Japerreport in ReportServer

Hi IF_Jasmin,

Thanks for your reply.

As you mentioned in your previous messages, I can call the API to generate the CSV file. However, is there a way to leverage the SMTP configuration within ReportServer to send the email with that file as an attachment?

I am considering writing a Python script on the same machine as RS to handle this.

Regards, JL.

IF_Susanne

Moderator

Registered: 2025-11-26

Re: How to export CSV format for Japerreport in ReportServer

Hello JL_Cosir,

I've received the following two documents from the developers for you:

ReportServer - ReportServer Admin Guide …  Datasinks (starting with "5.1 Email – SMTP")
ReportServer - ReportServer Admin Guide … of Reports

Please let us know if the documentation doesn't help you at this point.

Best regards
Susanne