Report Layout Problem
I am using Delphi 6 with ReportBuilder Enterprise Edition Version 7.0
My problem is that I need to create a report and I know what I need it to
look like but I am unable to make one that will look like it. Here is
basically what I need it to look like.
Summary Report
Employee1
Employee2 Totals
Earnings
Salary 1000.00
0.00 1000.00
OverTime 0.00
50.00 50.00
Vacation 100.00
20.00 120.00
Earnings Total 1100.00
70.00 1170.00
Deductions
401K 30.00
20.00 50.00
Health Insurance 10.00
0.00 10.00
Deductions Total 40.00
20.00 60.00
Net Pay 1020.00
50.00 1110.00
Company Contributions
Federal Unemployment 10.00
10.00 20.00
Medicare 5.00
6.00 11.00
Social Security 5.00
5.00 10.00
Company Totals 20.00
21.00 41.00
The Employees are stored in the Master Table, then all of the items along
the left side of the report are stored in 3 separate Detail Table, except
for Net Pay. The Net Pay is calculated from the totals of the Earnings -
Deductions.
I need to have the report print out just like above and I have tried using
the cross tabs, but if I put three different cross tabs on there is doesn't
line up like I need it to.
If you have an example of a report that produces these results then I would
greatly appreciate any help that you could give me.
Thanks in advance for all of your help.
Brian Tackett
SofTek Software International, Inc.
btackett@softeksoftware.com
My problem is that I need to create a report and I know what I need it to
look like but I am unable to make one that will look like it. Here is
basically what I need it to look like.
Summary Report
Employee1
Employee2 Totals
Earnings
Salary 1000.00
0.00 1000.00
OverTime 0.00
50.00 50.00
Vacation 100.00
20.00 120.00
Earnings Total 1100.00
70.00 1170.00
Deductions
401K 30.00
20.00 50.00
Health Insurance 10.00
0.00 10.00
Deductions Total 40.00
20.00 60.00
Net Pay 1020.00
50.00 1110.00
Company Contributions
Federal Unemployment 10.00
10.00 20.00
Medicare 5.00
6.00 11.00
Social Security 5.00
5.00 10.00
Company Totals 20.00
21.00 41.00
The Employees are stored in the Master Table, then all of the items along
the left side of the report are stored in 3 separate Detail Table, except
for Net Pay. The Net Pay is calculated from the totals of the Earnings -
Deductions.
I need to have the report print out just like above and I have tried using
the cross tabs, but if I put three different cross tabs on there is doesn't
line up like I need it to.
If you have an example of a report that produces these results then I would
greatly appreciate any help that you could give me.
Thanks in advance for all of your help.
Brian Tackett
SofTek Software International, Inc.
btackett@softeksoftware.com
This discussion has been closed.
Comments
across the top. The first column should be the titles and then the next 2
columns are the employee totals and then the last cloumn is the grand
totals.
--
Brian Tackett
SofTek Software International, Inc.
btackett@softeksoftware.com
R&D: 330-743-1229
It looks like you can solve your problem by creating three subreports and
stacking them vertically using ShiftRelativeTo. This way each individual
column can gather information from a separate dataset if needed. If this
does not help, please send a Word document of what you are trying to
accomplish to support@digital-metaphors.com and I'll take a closer look.
Nico Cizik
Digital Metaphors
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com