report design 1

[srpatel]

hello

I have had to design a report that looks relatively similar to my form.
At the present the report layout is in the following manor:


Page Header
GroupHeader0
Detail
Page Footer


The data is currently sorted and grouped by the Line Description and
the Location. The Line Description is grouped. I have also placed the
Line Description in the GroupHeader0 so that whenever a new Line
Description starts it is displayed on the first of that record.


There are 13 different types of Line Descriptions, e.g. Blue, Green,
Yellow, Maroon etc. Each Line Description has over 80 records to it.


This is where i need some help on enahancing my report:


1. Can I have a COUNT in the page footer, which shows how many records there are for say the Blue group. e,g, so when I am viewing the Blue,
it should say Page 1 - 60. When I get to the next Line, Green, it says
61 - 100.


2. This may not be possible, but I would like to know if it can be done, On my form i have certain text boxes which go gray depending on certain
selections. On my reports can I display which ones are grayed out?


Thanks
srmp

 

[THWatson]

srmp
Here are a couple of places where there are methods to put totals in the Page Footer.

http://office.microsoft.com/en-us/assistance/HA011224441033.aspx

http://allenbrowne.com/tips.html

Tom

 

[srpatel]

Hi Tom,

Thank you for the valuable links full of information.

I managed to work out the count of each group by placing this in the Group Header:

=Count([Line Desc])

Thanks for your help!

Srmp