Report Headers/Design
in [Reports]
|
From: Steve Stad on 6 Apr 2010 13:48 1. I have a report with 23 columns. The columns contains 3 or 4 digit numbers. The Column Headers (in Page Header Sec) are wider than the numeric data in the columns. How can I display the column headers in a way to be long enough to be descriptive yet not waste space on the report - so ideally it may fit on One page. 2. I have footer sums in the Report Footer. Can I display the footer sums with out displaying the Column Headers in the Page Header Section.
From: Steve on 6 Apr 2010 14:08 1. A possibility would be to label the columns A to W and put a legend in the report footer. 2. Yes. You could put a "Total" label at the beginning of the footer sums row. Steve santus(a)penn.com "Steve Stad" <SteveStad(a)discussions.microsoft.com> wrote in message news:66A1B832-5864-4075-A775-A69EA3A0686E(a)microsoft.com... > 1. I have a report with 23 columns. The columns contains 3 or 4 digit > numbers. The Column Headers (in Page Header Sec) are wider than the > numeric > data in the columns. How can I display the column headers in a way to be > long enough to be descriptive yet not waste space on the report - so > ideally > it may fit on One page. > 2. I have footer sums in the Report Footer. Can I display the footer > sums > with out displaying the Column Headers in the Page Header Section.
From: KARL DEWEY on 6 Apr 2010 14:15 Have you considered vertical labels? D A S e r t p e o t a p ---------------- 4 35 16 -- Build a little, test a little. "Steve Stad" wrote: > 1. I have a report with 23 columns. The columns contains 3 or 4 digit > numbers. The Column Headers (in Page Header Sec) are wider than the numeric > data in the columns. How can I display the column headers in a way to be > long enough to be descriptive yet not waste space on the report - so ideally > it may fit on One page. > 2. I have footer sums in the Report Footer. Can I display the footer sums > with out displaying the Column Headers in the Page Header Section.
From: Steve Stad on 6 Apr 2010 22:05 Steve - Can you provide a little more detail re the 'total' label at beginning of footer sums row. I am summing the fields from the detail section in the footer in a vertcal list vs horozontal (as in the detail section) but the headers from the page header section show up above the footer section. "Steve" wrote: > 1. A possibility would be to label the columns A to W and put a legend in > the report footer. > 2. Yes. You could put a "Total" label at the beginning of the footer sums > row. > > Steve > santus(a)penn.com > > > "Steve Stad" <SteveStad(a)discussions.microsoft.com> wrote in message > news:66A1B832-5864-4075-A775-A69EA3A0686E(a)microsoft.com... > > 1. I have a report with 23 columns. The columns contains 3 or 4 digit > > numbers. The Column Headers (in Page Header Sec) are wider than the > > numeric > > data in the columns. How can I display the column headers in a way to be > > long enough to be descriptive yet not waste space on the report - so > > ideally > > it may fit on One page. > > 2. I have footer sums in the Report Footer. Can I display the footer > > sums > > with out displaying the Column Headers in the Page Header Section. > > > . >
From: Steve on 7 Apr 2010 11:39 I envision your report looking like this..... is this correct? Page Header A B C D ........... Detail 2 5 3 1 6 3 5 7 4 9 0 1 Report Footer Total 12 17 8 9 Steve santus(a)penn.com "Steve Stad" <SteveStad(a)discussions.microsoft.com> wrote in message news:92628BA8-1900-4F0F-9D30-858FE158C44F(a)microsoft.com... > Steve - Can you provide a little more detail re the 'total' label at > beginning of footer sums row. I am summing the fields from the detail > section in the footer in a vertcal list vs horozontal (as in the detail > section) but the headers from the page header section show up above the > footer section. > > "Steve" wrote: > >> 1. A possibility would be to label the columns A to W and put a legend >> in >> the report footer. >> 2. Yes. You could put a "Total" label at the beginning of the footer >> sums >> row. >> >> Steve >> santus(a)penn.com >> >> >> "Steve Stad" <SteveStad(a)discussions.microsoft.com> wrote in message >> news:66A1B832-5864-4075-A775-A69EA3A0686E(a)microsoft.com... >> > 1. I have a report with 23 columns. The columns contains 3 or 4 digit >> > numbers. The Column Headers (in Page Header Sec) are wider than the >> > numeric >> > data in the columns. How can I display the column headers in a way to >> > be >> > long enough to be descriptive yet not waste space on the report - so >> > ideally >> > it may fit on One page. >> > 2. I have footer sums in the Report Footer. Can I display the footer >> > sums >> > with out displaying the Column Headers in the Page Header Section. >> >> >> . >>
|
Pages: 1 Prev: Problem with printing multiple copies of a report Next: Date Range in Header |