Reports - Expanded the header band but detail lines overlap the header 1

[rleiman]

Hi Everyone,

I created a report with the wizard and wanted to place additional text in the header band. When I expanded the header band, the detail lines started to print over part of the header text. Can you tell me how to stop that from happening? The detail lines start to print at a position as if the header was not expanded at all.

Thanks.

Emad

 

[ShankarJ]

Hi Emad,

When in the Report Design mode, click on View and choose Band Layout view. You will be able to visualize the Page Header, Detail and Page Footer areas. Adjust accordingly.

Regards

 

[rleiman]

Hi ShankarJ,

The Band Layout view is how I originally adjusted the header height. I did it by dragging to make it bigger. The detail lines started to print at the same height on the page as if I never made the height adjustment. When I saw the problem I tried to adjust it throught the page group header properties window. This also produced the same problem. I even looked at the numbers in the ... button but they seemed ok.

Is there something hidden I need to know? Everything prints ok if I return the header height back to it's original size but I need to make it bigger to add more text, etc. in there.

Thanks.

Emad

 

[ShankarJ]

Hi Emad,

Post your Report Structure here. Click on the ... next to the Report button, select all, copy and paste here.

I hope you have NOT used the absolute attribute on any of the detail bands as that will cause that band to print on the same place in the page.

Regards

 

[rleiman]

Hi ShankarJ,

Here's the code. Thanks.

Emad

Report REPORT('DummyReportTable Report'),AT(250,854,9646,7000),PAPER(PAPER:LETTER),PRE(RPT),FONT('MS Sans Serif',8,,FONT:regular), |
         LANDSCAPE,THOUS
       HEADER,AT(250,250,9646,1000),USE(?Header),FONT('MS Sans Serif',8,,FONT:regular)
         STRING('Net Worth Report'),AT(823,52,8000,220),USE(?ReportTitle:2),CENTER,FONT('Arial',14,,FONT:bold)
         STRING('Week Ending:'),AT(83,573),USE(?String9),TRN,FONT('Arial',12,,FONT:regular+FONT:italic,CHARSET:ANSI), |
             #ORIG(?String9)
         STRING(@d8-),AT(1156,604),USE(LOC:Week1),#ORIG(LOC:Week1)
         BOX,AT(10,313,9650,250),USE(?HeaderBox),ROUND,COLOR(COLOR:Black),LINEWIDTH(20)
         STRING('Total Jewlery Sales'),AT(83,354),USE(?String8),TRN,FONT(,,,FONT:bold,CHARSET:ANSI),#ORIG(?String8)
       END
Detail DETAIL,AT(,,9646,250),USE(?Detail)
         STRING(@N$(16.2)),AT(104,52),USE(LOC:TotalJewlerySalesWeek1),RIGHT(2),TALLY(Detail),#ORIG(LOC:TotalJewlerySales)
       END
       FOOTER,AT(250,10500,9646,250),USE(?Footer)
         STRING('Date:'),AT(115,52,344,135),USE(?ReportDatePrompt,,?ReportDatePrompt:2),TRN,FONT('Arial',8,,FONT:regular), |
             #SEQ(1),#ORIG(?ReportDatePrompt)
         STRING('<<-- Date Stamp -->'),AT(490,52,927,135),USE(?ReportDateStamp,,?ReportDateStamp:2),TRN, |
             FONT('Arial',8,,FONT:regular),#SEQ(1),#ORIG(?ReportDateStamp)
         STRING('Time:'),AT(1625,52,271,135),USE(?ReportTimePrompt,,?ReportTimePrompt:2),TRN,FONT('Arial',8,,FONT:regular), |
             #SEQ(2),#ORIG(?ReportTimePrompt)
         STRING('<<-- Time Stamp -->'),AT(1927,52,927,135),USE(?ReportTimeStamp,,?ReportTimeStamp:2), |
             TRN,FONT('Arial',8,,FONT:regular),#SEQ(2),#ORIG(?ReportTimeStamp)
         STRING(@pPage <<#p),AT(8833,52,700,135),PAGENO,USE(?PageCount,,?PageCount:2),FONT('Arial',8,,FONT:regular)
       END
       FORM,AT(250,250,9646,8000),USE(?Form),FONT('MS Sans Serif',8,,FONT:regular)
         IMAGE,AT(0,-21,9646,8000),USE(?FormImage),TILED
       END
     END

 

[ShankarJ]

Hi Emad,

Your Report has a POSITION setting (X, Y, W, H) of 250,854,9646,7000. This denotes the Detail Area.

Your Page Header has a POSITION setting (X, Y, W, H) of 250,250,9646,1000. So, the Header finishes at 1250 i.e. Y of 250 + H of 1000.

So, if you change the detail area from 250,854,9646,7000 to 250,1250,9646,6600 it should be OK.

Where can you change this?

1. In Report Design mode, click on Edit -> Report Properties -> Position Tab
2. In Page Layout View, right click on the detail area anc choose Position
3. Click on the ... next to the Report Button, manually edit the header and save

Also your Page Footer needs to be changed to 250,7850,9646,250 as it is currently out of the page.

Always keep in mind that when you choose LANDSCAPE, the width becomes the height.

Regards

 

[rleiman]

Hi ShankarJ,

Wow. I would never have quessed that height and width are reversed when landscape is used.

Thanks for the help.

Truly,
Emad