JasperReports is a powerful open source Java reporting tool that has the ability to deliver rich content onto the screen, to the printer or into PDF, HTML, XLS, CSV and XML files. ()

Peter Jin | 3 Jun 2009 10:45

Picon

How about loop a sub report?


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 put those data together
under a particular user. I don't want to use UNION because HQL doesn't
support it. In addition, Union 5 tables may result in a huge SQL. I have to
use one sub report for each table and iterate users in master report and for
each user iterate all sub reports to display data relevant to that user.

Is this viable or any other solution?

Any comment is appreciated.
--

-- 
View this message in context: http://www.nabble.com/How-about-loop-a-sub-report--tp23847733p23847733.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.

------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises 
looking to deploy the next generation of Solaris that includes the latest 
innovations from Sun and the OpenSource community. Download a copy and 
enjoy capabilities such as Networking, Storage and Virtualization. 
Go to: http://p.sf.net/sfu/opensolaris-get

chr15athome | 3 Jun 2009 11:15

Picon

Re: How about loop a sub report?

Hi Peter,

If I understand your requirements correctly I think grouping would be better
than having multiple subreports.

Grouping the data on users allows you to create a seperate table for each
user, you can also have a header and footer for each user and you can also
perform calculations and have totals at the bottom of each group.

Hope this helps.

Chris

Peter Jin wrote:
> 
> 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 put those data
> together under a particular user. I don't want to use UNION because HQL
> doesn't support it. In addition, Union 5 tables may result in a huge SQL.
> I have to use one sub report for each table and iterate users in master
> report and for each user iterate all sub reports to display data relevant
> to that user.
>

(Continue reading)

chr15athome | 3 Jun 2009 11:18

Picon

Re: How about loop a sub report?


Sorry I forgot to mention that the info I gave is based on using
iReport/jasperReports, not sure what you are using now but I definately
recommend iReport.

Chris

chr15athome wrote:
> 
> Hi Peter,
> 
> If I understand your requirements correctly I think grouping would be
> better than having multiple subreports.
> 
> Grouping the data on users allows you to create a seperate table for each
> user, you can also have a header and footer for each user and you can also
> perform calculations and have totals at the bottom of each group.
> 
> Hope this helps.
> 
> Chris
> 
> 
> Peter Jin wrote:
>> 
>> 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?

(Continue reading)

Peter Jin | 3 Jun 2009 11:22

Picon

Re: How about loop a sub report?


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?
--

-- 
View this message in context: http://www.nabble.com/How-about-loop-a-sub-report--tp23847733p23848221.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.

------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises 
looking to deploy the next generation of Solaris that includes the latest 
innovations from Sun and the OpenSource community. Download a copy and 
enjoy capabilities such as Networking, Storage and Virtualization. 
Go to: http://p.sf.net/sfu/opensolaris-get

chr15athome | 3 Jun 2009 13:28

Picon

Re: How about loop a sub report?

Its hard to give advice when I have no real idea of your data structure, I am
unsure why you would have seperate tables for differents users unless you
mean graphically.

If you have 5 separate tables 1 for each user then UNION seems to be the
only way to do it, unless you know Java, you could put the data into beans
and use a bean datasource to build your report.

I always find that subreports can normally be replaced with groups, I
personally hate subreports...lol.

Chris

chr15athome wrote:
> 
> Sorry I forgot to mention that the info I gave is based on using
> iReport/jasperReports, not sure what you are using now but I definately
> recommend iReport.
> 
> Chris
> 
> 
> chr15athome wrote:
>> 
>> Hi Peter,
>> 
>> If I understand your requirements correctly I think grouping would be
>> better than having multiple subreports.
>>

(Continue reading)

David Bolen | 3 Jun 2009 20:11

Picon

Re: How about loop a sub report?

Peter Jin <jinyuping@...> writes:

> 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?

It's still somewhat unclear without knowing more about your table
structure, but if you just mean that you have a reasonably normalized
schema where the relevant information is stored in several tables with
appropriate foreign key relationships (this can be true even if normal
access is controlled by an ORM like Hibernate), is there a reason your
report query can't just join the relevant tables together, grouping
the result by user?

If you mean 5 completely distinct data sources (e.g., separate
databases), then another thought (if you have control of the code
rendering the report) might be to implement a custom data source that
itself performs the integration from the multiple data sources, even
if via 5 distinct queries.  From the Jasper engine's perspective it
would still be utilized as a single data source for the report.

-- David

------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises 
looking to deploy the next generation of Solaris that includes the latest 
innovations from Sun and the OpenSource community. Download a copy and 
enjoy capabilities such as Networking, Storage and Virtualization. 
Go to: http://p.sf.net/sfu/opensolaris-get

(Continue reading)

Peter Jin | 4 Jun 2009 09:40

Picon

Re: How about loop a sub report?


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 <jinyuping@...> writes:
> 
>> 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?
> 
> It's still somewhat unclear without knowing more about your table
> structure, but if you just mean that you have a reasonably normalized
> schema where the relevant information is stored in several tables with
> appropriate foreign key relationships (this can be true even if normal
> access is controlled by an ORM like Hibernate), is there a reason your
> report query can't just join the relevant tables together, grouping
> the result by user?
> 
> If you mean 5 completely distinct data sources (e.g., separate
> databases), then another thought (if you have control of the code
> rendering the report) might be to implement a custom data source that
> itself performs the integration from the multiple data sources, even
> if via 5 distinct queries.  From the Jasper engine's perspective it
> would still be utilized as a single data source for the report.

(Continue reading)

Peter Jin | 4 Jun 2009 10:26

Picon

Re: How about loop a sub report?


Thanks a lot for your comments. 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.
I'll consider to create a view first.

chr15athome wrote:
> 
> Its hard to give advice when I have no real idea of your data structure, I
> am unsure why you would have seperate tables for differents users unless
> you mean graphically.
> 
> If you have 5 separate tables 1 for each user then UNION seems to be the
> only way to do it, unless you know Java, you could put the data into beans
> and use a bean datasource to build your report.
> 
> I always find that subreports can normally be replaced with groups, I
> personally hate subreports...lol.
> 
> Chris
> 
> 
> chr15athome wrote:
>> 
>> Sorry I forgot to mention that the info I gave is based on using
>> iReport/jasperReports, not sure what you are using now but I definately
>> recommend iReport.
>> 
>> Chris
>>

(Continue reading)

chr15athome | 4 Jun 2009 10:54

Picon

Re: How about loop a sub report?


Yes I overlooked using JOIN. Used to use JOIN for multiple tables in my old
system.
If you are not up on Joins I have an example I can send.

David Bolen-2 wrote:
> 
> Peter Jin <jinyuping@...> writes:
> 
>> 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?
> 
> It's still somewhat unclear without knowing more about your table
> structure, but if you just mean that you have a reasonably normalized
> schema where the relevant information is stored in several tables with
> appropriate foreign key relationships (this can be true even if normal
> access is controlled by an ORM like Hibernate), is there a reason your
> report query can't just join the relevant tables together, grouping
> the result by user?
> 
> If you mean 5 completely distinct data sources (e.g., separate
> databases), then another thought (if you have control of the code
> rendering the report) might be to implement a custom data source that
> itself performs the integration from the multiple data sources, even
> if via 5 distinct queries.  From the Jasper engine's perspective it
> would still be utilized as a single data source for the report.

(Continue reading)

David Bolen | 5 Jun 2009 02:17

Picon

Re: How about loop a sub report?

Peter Jin <jinyuping@...> writes:

> 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.

Still sounds pretty standard in terms of database schema.  Can I
assume that these separate activity tables have some field or unique
key that correlates back to a user table or table containing per-user
information?  If so, then unless the tables are stored in separate
database servers, it sounds like you just want to join those tables as
part of the primary query without much hassle.

Dumb example - you have a set of users, who can get rows added to one of
three activity tables, related to three activities that have different
metrics.  Each row in an activity table is a single instance of that
user performing that activity:

   users
      id integer primary key
      name text

   activity1
      user_id integer -- foreign key references users(id)
      distance integer

   activity2
      user_id integer -- foreign key references users(id)
      hits integer

(Continue reading)

Group

gmane.comp.java.jasperreports.general.

Advertisement

Project Web Page

JasperReports is a powerful open source Java reporting tool that has the ability to deliver rich content onto the screen, to the printer or into PDF, HTML, XLS, CSV and XML files. ()

Search Archive

Page

1 | 2 | 3

Articles in period: 21

June 2009

Language

Change language

Options

Current view: Threads only / Showing only 20 lines / Not hiding cited text.
Change to All messages, whole messages, or hide cited text.

Post a message
NNTP Newsgroup
Classic Gmane web interface
XML

XML

RSS Feed
List Information

About Gmane

Recent entries

How to get rid of NullPx image in html report (5 Nov 2012)
Date as value expression of Stacked/XY-Bar Chart ... (17 Oct 2012)
How remove extra whitespaces in a Text Field (25 Jul 2012)
Suppress subreport for Excel export (13 Mar 2012)
generating a jasper report (8 Nov 2011)
Extra white space when detail section overflows (14 Sep 2011)
Silent print of PDF report without opening at client/browser (12 Aug 2011)
Silent print of PDF report without opening at client/browser (12 Aug 2011)
How to generate 2 dimensional report in jasper? (21 Jun 2011)
How to generate 2 dimensional report in jasper? (20 Jun 2011)
Webapplication to run jasper reports (27 May 2011)
Two sub reports in one report with different data sources in struts2-j (1 Feb 2011)
java.lang.NoClassDefFoundError: jet/bean/JREngine (13 Jan 2011)
logic in jrxml? (10 Nov 2010)
jasper reports performance issue (3 Dec 2010)
current or past date on scheduled reports (27 Sep 2010)
Slider in JasperReports (31 Jul 2010)
Expanding chart on clicking it. (31 Jul 2010)
Adding lables dynamically. (6 Apr 2010)
simple jasper report in java without a database. (5 Apr 2010)
jasperreports-questions Digest, Vol 41, Issue 2 (26 Mar 2010)

Archives

2	November 2012
1	October 2012
1	July 2012
1	March 2012
1	January 2012
1	November 2011
2	September 2011
2	August 2011
3	June 2011
2	May 2011
1	February 2011
1	January 2011
4	December 2010
1	November 2010
1	September 2010
3	July 2010
2	April 2010
9	March 2010
9	February 2010
3	January 2010
4	December 2009
16	November 2009
14	October 2009
8	September 2009
6	August 2009
7	July 2009
21	June 2009
6	May 2009
16	April 2009
5	March 2009
5	February 2009
8	January 2009
14	December 2008
6	November 2008
8	October 2008
9	September 2008
16	August 2008
9	July 2008
10	June 2008
4	May 2008
6	April 2008
10	March 2008
8	February 2008
15	January 2008
10	December 2007
20	November 2007
11	October 2007
6	September 2007
8	August 2007
3	July 2007
7	June 2007
11	May 2007
13	April 2007
8	March 2007
16	February 2007
10	January 2007
10	December 2006
11	November 2006
28	October 2006
53	September 2006
34	August 2006
45	July 2006
91	June 2006
39	May 2006
102	April 2006
42	March 2006
44	February 2006
78	January 2006
51	December 2005
67	November 2005

Design

Zawodny | Right Menu | Left Menu

Your Own Design

Paste the URL of your CSS below. Download CSS template