Sub-Report Totals

[Cori]

Good afternoon,

I am working on a Sub-report. I have a column of numbers that I need to total up at the bottom of the sub-report (or report what ever is easier). Anyway, when i try to do this in the Report Footer it shows up after every record and not at the bottom.

Maybe the query info will be helpful. The filde is SumOfProjects. In my report i want to have a text field that totals that column (SumOfProjects) so i have the total of all the projects. Is there a simple way to do this on the sub-report or Main report?

Thanks for helping Cori

 

[Cori]

I have figured out some things and I have gotten the data to show at the bottom of the page however it is only showing the last record in that field. Can someone help me with this?

I am using The HasData Method:
=IIf(srptProjectTotals.Report.HasData,srptProjectTotals.Report!Hours,0)

Please help

 

[Cori]

Can anyone help me out here???

 

[Rich]

You have to Sum the totals in the subReport footer and reference that textbox in your statement

 

[Cori]

I have done that but it doesn't give me a total at the bottom. It gives a total after each record. Do you know why?

 

[Rich]

It needs to be in the Report Footer and nowhere else

 

[Cori]

That is where i have it??

 

[Cori]

This works when i pull it up as a report, but not when i open the main report with it as a subreport??? I am so confused!

 

[Cori]

Does anyone know why this is happeing?

 

[uncle-lai]

If you could post a snapshot of the design view of your report it would probably help to identify your problem.

 

[Cori]

My computer wont allow me to take a snap shot of this in design view. Any other ideas

 

[boblarson]

Simple way to do this:

To take a screen shot (even in design view) press your PrtScn button and then paste into a Word document and then upload the Word document to the forum.

 

[Cori]

Snap Shot 2

Here is what the report looks like when you open it!

 

[Rich]

There is no textbox in your Report Footer!

 

[Cori]

Here it is with a bigger view

 

[boblarson]

Like he said, there is no text box in your REPORT footer, not subreport report footer.

 

[Cori]

Ok I have done that and it is still not working, the total in the sub report is not totaling the subreport correctly. That is what i am maily concerned about right now. it is putting the total after each entry not all at the bottom. Look at the first attachment.

 

[boblarson]

Cori:

I think we're at a point where we might need you to post your database in order to figure it out better. At least it would help me (Rich on the other hand is probably fine without it) as I am way more visual. I can't remember if you were able to post or not. I think we've either done this before or asked and you said you couldn't. I can't remember.

 

[Cori]

got it

Ok I have made it small enough. thank you for your help, it means a lot

 

[boblarson]

Cori:

Can you elaborate a little on what you are trying to show on the report? There's a part on the left and the subreport on the right. What are the differences? What is it that you want to get to?