Creating a Report with Mulitple Headers

  • Thread starter Thread starter memouse
  • Start date Start date
M

memouse

I am trying to create a report that takes my data for the day and organizes
it in to groups. While I have gotten it where it sorts and groups it by
stages (i.e. Stage 1, Stage 2) I don’t want the headers for those stages to
say Stage 1, etc. I would like it so it sorts it under different categories
like:

(Originally stage 1) would now say "Projects that Came in today"
data data data.....

(Originally stage 2) would now say “Projects started still in progress"
data data data......


With the form that I have right now, it just has one field that auto sorts
so my report looks kinda like:

Report Header:
TITLE

Page Header: (Blank)

STAGE Header:
[lblSTAGE] [Field: STAGE]

Detail:
[Project code] [Project name]

Page Footer: [ Now]
Report Footer: (Blank)

Can anyone help me with this? Thank you.
 
Do you have a table of unique stages? If not, create one. Add a field for the
alternative text. Add this new field to your report's record source so you
can display it.
 
Do you want the data actually organized differently? Or do you just
want different header names to substitute for the Stages?


If its the latter, you could use an iif statement i suppose. put a
text box in the stage header that is setup like:
=iif([STAGE] = "Stage 1", "Projects that Came in today, iif([STAGE] =
"Stage 2", "...." etc))
 
Back
Top