Hi,
I may need to put several sub reports in the detail section in the master
report. So the sub reports will get loaded many times. Will this cause
significant performance issues? Does jasper cache data source for report in
this case?
My case:
User's data are scattered in 5 tables and I need to
Hi Chris,
Thanks for your reply.
Grouping can not solve my issue because it works on one data source only. In
my case, data for a user scattered in 5 tables. UNION might be a way to
combine all tables to a data source, but I can not use it either (explained
in the first post). any thoughts?
--
We have an audit system which uses separate tables with similar structure to
store different kinds of activities for a user. We want to report the number
of activities per activity type per user.
David Bolen-2 wrote:
Peter Jin jinyup...@gmail.com writes:
Grouping can not solve my issue
than activity2, some of the records of activity2 will be joined multiple
times. This is incorrect. Does it make sense?
David Bolen-2 wrote:
Peter Jin jinyup...@gmail.com writes:
We have an audit system which uses separate tables with similar structure
to
store different kinds of activities
Hi, It works!
All your posts are of great help. Thanks a ton!
David Bolen-2 wrote:
Peter Jin jinyup...@gmail.com writes:
Let's take a look at activity1 and activity2. If activity1 has more
records
than activity2, some of the records of activity2 will be joined multiple
times
Hi,
I may need to put several sub reports in the detail section in the master
report. So the sub reports will get loaded many times. Will this cause
significant performance issues? Does jasper cache data source for report in
this case?
My case:
User's data are scattered in 5 tables and I need to