Totaling a field from a report and sub report

[Talasan]

Hi all,

I have a report with a subreport
each has a feild with a total and i`m needing to add the totals feild from the report with the totals feild of the sub report.

I've look thru all the topics of this forum and havent found the answer on how to do this yet however i`m sure its very simple and i`m just overlooking something.

any and all help is appreciated

thanks in advance,

Tim

 

[pdx_man]

use the Build button to map to your fields. It is on the Report Design toolbar, 4th from the right. It has a little wand on it. Make sure you have named your controls on your sub-report well as it will be easier to map to them.

Check it out, but let me know if you need some more info.

 

[Talasan]

pdx_man,

Thanks very much for your reply,

I've actually been trying to do this with the build funtion all along however being very new to this i`m obviously doing something wrong.

I`ve tried several different ways and I always get a syntax error. So i`m not getting the ([ and so on in the right spots i think. Probably because i`m not using the build function corectly or something.

I`m slowly but surely learning though =)

 

[dkirk02]

Talasan,
Hate to tell you this, but....I faced the same problem. I was trying to create calculated fields in the main report footer referencing field values in the sub report. Let me tell you, I banged my head against that problem for three weeks, always with the same results you're getting. I posted the problem on three different forums, and no one could help.
Eventually, to save time,I had to go back and start over, creating one report from a query that queried both tables. It was the only way I could get my totals to work. By manipulating the headers and footers and using some lines, you can make it appear to be two main groups of info. My report turned out beautifully and I got to use some pretty complicated calculations. Hope this helps.
If you have any questions on how to do this, just e-mail me!
dkirk02@sprintspectrum.com

 

[pdx_man]

Sent the both of you an example database. Let me know if you have any questions.