2 report issues

[Caddie]

Hi -

I have two problems with my report:

1 - My report has a subreport, which has a subreport. On the "grandchild" I have subtotals, how do I add a total amount on the report footer (footer of main report)?

2 - My report is a little too wide to be printed on letter sized paper. I can't make the fields any narrower, is there a "shrink to fit" option in access similar to excel?

Thanks!

 

[SOS]

Hi -

I have two problems with my report:

1 - My report has a subreport, which has a subreport. On the "grandchild" I have subtotals, how do I add a total amount on the report footer (footer of main report)?

Put a control on the main form which then has this as the control source (replacing the applicable parts with your real names, remembering to use the subform control name and not the subform name):
=[SubformCtlName1]![Form].[SubformCtlName2]![Form].[TextBoxName]

Or, if you have the main form open in design view you can use the expression builder to get the accurate syntax (see here for how).

2 - My report is a little too wide to be printed on letter sized paper. I can't make the fields any narrower, is there a "shrink to fit" option in access similar to excel?

Nope, you have to work it around.

 

[Caddie]

Hey -

Thanks for the reply, but I'm working with a report based on a query, it doesn't have anything to do with any forms.

 

[SOS]

Hey -

Thanks for the reply, but I'm working with a report based on a query, it doesn't have anything to do with any forms.

Same concept with reports too.

 

[Caddie]

Ok, almost there I think. I put in the this code:

=[subrptCustomerContractReview].[Report]![subrpt2CustomerContractReview].[Report]![subtotalMRR])

but this subform is grouped by a "CRM #" and so this code is only pulling the subtotal for the first CRM # but I need the total of all of the CRM # subtotals.

 

[SOS]

Then I believe you have it one level down too far. The sum should then come from the subform above it.

 

[Caddie]

Makes sense, it needs to go in the "Contract #" footer as it is grouped by this field, however for some reason I can't see this footer. I only see the page footer and report footer. Any idea why?

 

[SOS]

Makes sense, it needs to go in the "Contract #" footer as it is grouped by this field, however for some reason I can't see this footer. I only see the page footer and report footer. Any idea why?

Do you mean you can't see it when in Report view or in design view. It doesn't need to be visible in report view for it to work. But if there is no footer in design view then you'll have to go add one.

 

[Caddie]

Hey SOS, I put a botton in the report footer of my report and so a user can click it to print the report, but the wizard doesn't pop up, what VBA code would I enter to make it work?

Thanks.

 

[Caddie]

Sorry, DoCmd.Printout! LOL.

THanks.

 

[SOS]

So you got all you needed for this one? If so, good thing.