How do I get all fields on one page of a report?
I have a report that has a column for each day of the week and 6 records for
each day. I need each weekday's records returned on only one detail page.
Instead I am getting a new table layout for each day of the week. I have tried
grouping on every record and combination I can, manipulating the Group
Properties but can't get it right. I have the entire report in the Detail
Section, with the Week Starting date (Monday), VehicleID, and BattID values
listed in the report once at the top. The queries WHERE clause is based on the
Monday - Sunday date range, the VehicleID and the BattID.
The STDATE from the query is obviously causing each day to be set on another
detail page. How do I get it all on one page?
I know it has to do with the Grouping of records and Group Properties but
everything I try doesn't work.
My entire report should look like this:
STDATE = 10/27/03 VehicleID = 1 BattID = 1
Monday Tues. Weds. Thurs. etc...
Charge Rtn 5 10 3 8
# of Charges 2 3 1 7
MinSOC 12.3 31.1 65.5 34.4
MaxTemp 80 79 74 45
FullCharge YES NO YES NO
EQCharge NO NO NO YES
But I get something like this:
FIRST PAGE:
STDATE = 10/27/03 VehicleID = 1 BattID = 1
Monday Tues. Weds. Thurs. etc...
Charge Rtn 5
# of Charges 2
MinSOC 12.3
MaxTemp 80
FullCharge YES NO
EQCharge NO NO
STDATE = 10/28/03 VehicleID = 1 BattID = 1
Monday Tues. Weds. Thurs. etc...
Charge Rtn 10
# of Charges 2 3
MinSOC 31.1
MaxTemp 80 79
FullCharge NO NO NO
EQCharge NO NO NO
SECOND PAGE:
STDATE = 10/29/03 VehicleID = 1 BattID = 1
Monday Tues. Weds. Thurs. etc...
Charge Rtn 3
# of Charges 2 2 1
MinSOC 65.5
MaxTemp 80 79 74
FullCharge NO NO YES
EQCharge NO NO NO
The records returned are based on expressions from a query.
For example:
Monday Tues.
Charge Rtn: =IIf([WkDay]=2,[ChgRtn]) =IIf([WkDay]=3,[ChgRtn])
# of Chgs: =Sum(IIf([WkDay]=2,[SumVid])) =Sum(IIf([WkDay]=3,[SumVid]))
MinSOC: =Min(IIf([WkDay]=2,[MinSTSOC])) =Min(IIf([WkDay]=3,[MinSTSOC]))