How to use report's CSV data source in Table or Crosstab component - How-To - Jaspersoft Community

Jump to content

We've recently updated our Privacy Statement, available here ×

How to use report's CSV data source in Table or Crosstab component
- table component
- subdatasets
By Friendly User

February 25, 2020
Features: Custom Data Sources Product: Jaspersoft® Studio
Share

Followers 1
Scenario:
You are creating a report that uses a CSV file as a data source. You want to use a table or a crosstab in a report and have created a subdataset element in the report for that. When the report is previewed, nothing is displayed in the table. How to proceed here?
Solution:
Assuming you will be using the same data source in the subdataset, you will need to do the following:
In the table/crosstab element properties go to Data set tab
do "Use a JRDataSource expression" and then pass $P{REPORT_DATA_SOURCE} in there
Click on Parameters Map button and put $P{REPORT_PARAMETERS_MAP}
Preview
Table of contents
Share
Followers 1
Go to entries

User Feedback
- 1 Comment
Recommended Comments

katarzyna.wawer 0

Posted December 27, 2023

Share this comment

What if I would like to have postgresql or mssql in main report and csv in table that is, using two different data sources?

Link to comment

Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!
Register a new account

Sign in

Already have an account? Sign in here.
Sign In Now

×

×

Create New...