Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tricks to formatting a report?

Status
Not open for further replies.

VhbuiA

MIS
Oct 6, 2005
22
0
0
US
Hi, I have a main report which contains 2 subreports. I'd like to lay both subreports next to eachother so that it appears as though it's on one line.

Ex:
sub1 sub2
Awards Given
Awards Allowed Q1 Q2 Q3 Q4
Award1 100 0 0 0 0
Award2 100 0 0 0 0
Award3 200 0 0 0 0

Even though they both appear to be next to eachother, the subreport 2 doesn't start appearing until after the subreport 1 ends.

I've compared the formatting for both reports at the report level and at the subreport level...any tricks/ideas/suggestions?

Thanks!
 
You need to make sure that the Top property for both subreports is the same value.
 
Hi VhbuiA,
Maybe you can make a (new) query where all the information of subform1 and subform2 comes together, and just this query for one subform?

Pampers -

forgive my errors, just back from a holiday
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top