Report Output

Normally, the report always display like the follow:
Department Employee No. Average Salary
---
HR 15 11250
IT 25 15510
Sales 5 10000
But I want to display the record as the follow: (the record is shown
horizontally, instead of vertical)
Department HR IT Sales
Employee No. 15 25 5
Average Salary 11250 15510 10000
How can I do that ?May Liu,
Use a matrix instead of a table, your scenario is exactly what they are for.
If your query finds a new department it will add another column automatically.
Regards
Chris
"May Liu" wrote:
> Normally, the report always display like the follow:
> Department Employee No. Average Salary
> ---
> HR 15 11250
> IT 25 15510
> Sales 5 10000
> But I want to display the record as the follow: (the record is shown
> horizontally, instead of vertical)
> Department HR IT Sales
> Employee No. 15 25 5
> Average Salary 11250 15510 10000
> How can I do that ?
>

Report header only on first page

Hi
I wish to have a report with a header only on the first page. Normally the
header is repeated on every page. Is there a way to get it only on the first
page?
Thanks for any help!It sounds like you have used a page header rather than a report header in
your report. A report header automatically does what you are wanting to do.
To create a report header, just place a textbox above your data region and
type in the text for your header. It will automatically appear only on the
first page.
Page headers naturally print on every page. However these have a property
called PrintOnFirstPage/PrintOnLastPage which controls printing on first/last
page.
HTH
Charles Kangai, MCT, MCDBA
"M. Peyer" wrote:
> Hi
> I wish to have a report with a header only on the first page. Normally the
> header is repeated on every page. Is there a way to get it only on the first
> page?
> Thanks for any help!|||Thanks Charles for your valuable reply.
but more specific to the same problem, I need Report Header (only once) to
appear before the Page Header. But as per the solution provided by you, it
will appear at the top of the "Body" section.
Can I make Report header to appear at the top of the Page Header.
Thanks & Regards
Rohit
"Charles Kangai" wrote:
> It sounds like you have used a page header rather than a report header in
> your report. A report header automatically does what you are wanting to do.
> To create a report header, just place a textbox above your data region and
> type in the text for your header. It will automatically appear only on the
> first page.
> Page headers naturally print on every page. However these have a property
> called PrintOnFirstPage/PrintOnLastPage which controls printing on first/last
> page.
> HTH
> Charles Kangai, MCT, MCDBA
> "M. Peyer" wrote:
> > Hi
> > I wish to have a report with a header only on the first page. Normally the
> > header is repeated on every page. Is there a way to get it only on the first
> > page?
> > Thanks for any help!