yosewi6945 Posted May 7, 2021 Share Posted May 7, 2021 Hi, I am trying to create a report which contains an undetermined number of tables, all of them with the same structure but different data, taken from different rows of a database.The number of data rows (and hence, tables) can change (the data source keeps changing), so the number of tables is dynamic and is determined at the time of generating the report.Anybody knows what's the best approach to achieve this? Subreports? If so, I can't figure out how by what 'm finding online.Please note that I'm not looking for a single table with many rows, but for multiple tables, all of them with the same number of rows but different data.Thank you Link to comment Share on other sites More sharing options...
mahadiosb Posted May 7, 2021 Share Posted May 7, 2021 Basically, you want to show specific data from a specific database. And you don't have to relate that data with tables. Do you just want to show that data side by side? right? Link to comment Share on other sites More sharing options...
yama818 Posted May 16, 2021 Share Posted May 16, 2021 My ideas are as follows.1. Create the parameter 'P_table_name'.2. Embed the parameter in the From clause of SQL.---.select a,b,cfrom $P!{P_table_name}---.*'!' It is important to addhttps://community.jaspersoft.com/wiki/how-use-p-parameter-implement-dynamic-grouping-ireport-and-jasperreports-server3. Upload the report to the server.4. Change the parameter settings and configure the settings for getting the list values. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now