Complex report

Getting your data onto paper - or the web - Discussing the reports features of Base

Complex report

Postby giugio » Wed Apr 02, 2008 6:14 pm

Hy.
I would create a master detail report whith sun report writer.
I have 2 table:Employee(id,name,lastname) and works(id,idEmployee and prestation), in a mater detail relation(parent-child)
The problem is that i would to create a table with 3 columns.
IN columns 1 and 2 i insert a standard field from master record(name and lastname), but in column 3 i would to insert a list of the child relation of master record whith child table 2 (list of prestation field in table 2 where works.idEmployee=Employee.id).
How I do this?
THanks.
giugio
 
Posts: 11
Joined: Wed Apr 02, 2008 9:55 am

Re: complex report

Postby giugio » Fri Apr 04, 2008 4:44 pm

the solution can be the subreports , but i cant find them in the toolbars!
giugio
 
Posts: 11
Joined: Wed Apr 02, 2008 9:55 am

Re: complex report

Postby giugio » Tue Apr 08, 2008 9:18 am

But is possible that subreport not exist in base?
Haw replace it ?
There is a report tool with subreports?I try sun report builder but i can't find it
giugio
 
Posts: 11
Joined: Wed Apr 02, 2008 9:55 am

Re: complex report

Postby macuserfr » Fri Apr 25, 2008 11:50 am

Try to do a view of your tables.
1) Go into Tables
2) Select make a new view
3) add your 2 tables
4) link them together (Insert -> new relation then put the 2 fields that represent the same id and idemployee)
5) In the bottom, select all fields do you need to see in your report (name, report, etc)
6) save the view and try to do your report based on it.
macuserfr
 
Posts: 6
Joined: Fri Apr 25, 2008 11:43 am

Re: complex report

Postby r4zoli » Fri Apr 25, 2008 1:25 pm

Subreports not supported now, it is in Planned features list of SRB.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
User avatar
r4zoli
Volunteer
 
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

SunReportBuilder subreport timing

Postby PY Delens » Sat Jan 17, 2009 12:45 pm

Bonjour,
do you know when the subreport feature is hoped to come out?

Thanks on forward
OOo 3.0.X on Ms Windows XP + Vista
PY Delens
 
Posts: 61
Joined: Wed Nov 12, 2008 10:39 am

Re: Complex report

Postby r4zoli » Sat Jan 17, 2009 2:40 pm

I don't know, OOo3.1 will not contain this feature, I hope it will be in 3.2 version.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
User avatar
r4zoli
Volunteer
 
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Complex report

Postby PY Delens » Tue Jan 20, 2009 12:54 pm

Thank you all
OOo 3.0.X on Ms Windows XP + Vista
PY Delens
 
Posts: 61
Joined: Wed Nov 12, 2008 10:39 am


Return to Reporting

Who is online

Users browsing this forum: No registered users and 1 guest