Blank reports on empty Subform

[Trodelphin]

have Forms setup with two Subforms
if for some reason the 2nd one has no data in it i will get a blank report
if i put anything in the 2nd subform at all it works fine
any ideas ?

 

[HiTechCoach]

have Forms setup with two Subforms
if for some reason the 2nd one has no data in it i will get a blank report
if i put anything in the 2nd subform at all it works fine
any ideas ?

Sounds like you must have the table for the sub form that is blank in the main Report's record source.

If the data in a sub form is not require, I would also use a sub report for printing the data when it is there.

 

[vbaInet]

By the way you were mentioning forms and reports and I couldn't see the relation?!?

 

[Trodelphin]

yeah i was a little confused
made a few major changes got my head around Queries so basing forms and Reports on queries now so all the math is done properly and figured out how to pull subform totals out to main form and so for reports as well
got a crazy one atm tho my reports totals are throwing out wierd numbers like quadrupaling

=Sum(Nz([MaterialsTotal],0)) is the total Formula im using
MaterialsTotal is just a Query Result Field

 

[vbaInet]

In what section of your report are you performing the summation?

 

[Trodelphin]

in the Report Footer

 

[HiTechCoach]

yeah i was a little confused
made a few major changes got my head around Queries so basing forms and Reports on queries now so all the math is done properly and figured out how to pull subform totals out to main form and so for reports as well
got a crazy one atm tho my reports totals are throwing out wierd numbers like quadrupaling

=Sum(Nz([MaterialsTotal],0)) is the total Formula im using
MaterialsTotal is just a Query Result Field

This usually is a result of the relationshsips between the tables causing records to repeat in the query.

Will you post the SQL for the query that is causing the issue?

 

[Trodelphin]

yah i just deleted it and restarted and sems fine now :/
must have been something underneath

 

[HiTechCoach]

Thank you for the update. Glad to hear you have it solved.