format subreports vs. dlookups

[stormin_norm]

I have a report with two subreports which were a bitch to format in order to align with the main report. Should I have done this with dlookup instead? or VBA?? What's the consensus out there??


Looks something like:

Report Subtotal: 88 3 3 6 7 3 12 22 44 45

Sub-report: 88 6 6 6 10 3 5 10 50 50

The sub-report is base on a different query & tables. basically a select sum(ENG hours), sum(HIS hours),..... where classID = main report classID

Works okay with the parent/child link on the classID, but the formating is a pain in the neck due to the margins on the subreport. ALSO- There are boxes around each sum.

Instead---
Should I have made simple text boxes on the main report and do a dlookup? or create seperate queries and kick them off for each sumation box?

I have to create two or three more reports and I don't want to struggle with moving the mouse 1/8 inch to ensure my boxes line up between report&subreport.

THANKS!
Time for lunch. Looking forward to your suggestions! I was surprised the O'Reilly book does not get into this at all.

 

[stormin_norm]

Thanks! Thought so.
Two related questions->

Is there any way to push zero inch borders in a subreport?
I set pagelayout to 0, but access pushes .16 into the right/left borders.
and then when I drag the subreport to the right it increases my main report and creates an extra blank page.
Yes, I could mess with all borders, tweak the text boxes tighter, but there's got to be another way.


Q2 Instead of subreports or dlookup:
create two or three recordsets in VBA and populate the fields in the report summary during the onFormat event. Do you think this will work?
Any gotcha's with running multiple recordsets at once? I could serialize them..ie. run 1 sql to get requirements, populate text boxes, close collection, run 2 sql to get total for student, populate text boxes, close collection.

Thanks again PAT!! Keep dry in CT.
-Norm.
(Uha grad '87)