2-layer report?

  • Thread starter Thread starter Oscar
  • Start date Start date
O

Oscar

I am in the process of migrating my company from typing in dozens of
numbers every day from one excel sheet to another to a database so the
numbers only have to be inputted once. However, I am trying to keep
the reports Access generates as identical as possible to the excel
reports my superiors are used to viewing.
For one of the reports, there is too much data to fit onto one page if
it's all in one row, so in their excel sheet the data goes into two
sets of rows. For example, instead of:

A B C D E F
1 Center Name*Week Ending*Data 1*Data 2*Data 3*Data 4
2 Center 1 5/12/06 12354 1235 2345 2435
3 Center 2 5/12/06 12345 54658 445 5454

It goes:

A B C D
1 Center Name*Week Ending*Data 1*Data 2
2 Center 1 5/12/06 12354 1235
3 Center 2 5/12/06 12345 54658
4
5 Center Name*Week Ending*Data 3*Data 4
6 Center 1 5/12/06 2345 2435
7 Center 2 5/12/06 445 54541

with the Center Name and Week Ending Date on both sets of rows. I hope
this makes sense how I explained it.
Anyway, I am trying to generate a report to do this also. I am not
sure exactly how to do that, if I need to add more groups, etc. Any
help would be greatly appreciated!
Thanks,
Oscar
 
Ok, I think what they did there was create a subreport... which I
figured out. However, in my subreport, the page header doesn't show up
(which is where the titles for my columns are). I know they probably
aren't suppossed to go into page header but do you know how to create
another section in a report or should I just put them in report header?
 
Also, I put the subreport in the "Page footer" section of the main
report. Is that the correct place to put it or should I place it
somewhere else?
 
Sorry, one more thing...
We have 9 centers. When this report is opened I have it ask me which
center I would like the information for (because the query it is linked
to asks which center in the criteria). However, with the subreport, it
asks me twice. Is there a way for it to only ask me once... like the
subreport gets the center number from the main report?
Thanks,
Oscar
 
Don't ever use parameter prompt queries since it creates a horrible and
inflexible user interface. Use references to controls on forms for all of
your criteria.

The sample crosstab report I created in Crosstab.mdb uses a subreport for a
"column heading" display. I'm not sure why you placed anything in a page
header or footer.
 
I'm not sure what a parameter prompt query, or how to use references to
controls on forms.
I am still confused, I think, on how your crosstab.mdb report was
built. You have Report Header, Page Header, LastFirstName Header,
Level Header, Detail, Leevel Footer, LastFirstName Footer, Page Footer,
and Report Footer sections. The subreport is in the Level Header
section.
In my report, I can only get Report Header, Page Header, Detail, Page
Footer, and Report Footer to appear. I'm not sure how to get another
section to appear up there where I can put my subreport instead of in
Page Footer.
 
A parameter prompt is "I have it ask me". You should be setting a criteria
to something like:
Forms!frmYourForm!cboCenter
If you press F11 in the application, you can find an explanation in the
table ztblExplanation. There is some code that creates the columns and
levels.
 
Back
Top