Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Report Layout Problem

edited March 2003 in General
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

Comments

  • edited March 2003
    the formatting below is some how got messed up it should be four columns
    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
  • edited March 2003
    Brian,

    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


    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.