Getting subreport grand total showing as part of the main report

[eogyamfi]

I have subreport linked to a main report. The subreport has grandtotal on the footer. When I the report is run, all the foot report on the main report shows except the footer total of the subreport. Eventhough the subreport is run a sepreately, the footer is displayed. I need ur advice to solve this problem

 

[eogyamfi]

have subreport linked to a main report. The subreport has grandtotal on the footer. When I the report is run, all the foot report on the main report shows except the footer total of the subreport. Eventhough the subreport is run a sepreately, the footer is displayed. I need ur advice to solve this problem

 

[khawar]

You can use a control on the main report to display the total of sub report

 

[Rich]

There's a sample posted here
http://www.access-programmers.co.uk/forums/showthread.php?t=62296

 

[eogyamfi]

You can use a control on the main report to display the total of sub report

Pls can u explain the steps as how to use the controls. I am under pressure to complete this report for management meeting. Pls show the steps in the report

 

[khawar]

=IIf(YoursubreportName.Report.HasData,YoursubreportName.Report!TotalFieldOnYourSubReport,0)

Use the above code as the control source of a text box on main report and replace you sub report name and name of the total field on your sub report

add same code for each sub report you want

 

[eogyamfi]

Database for subreport problem

You can use a control on the main report to display the total of sub report

below is the link in respect to my database to enable help me solve the subreport total. you can run the report. your advice is needed to help me meet the meeting the deadline
http://www.sendspace.com/file/n5647o

 

[eogyamfi]

below is the link in respect to my database to enable help me solve the subreport total. you can run the report. your advice is needed to help me meet the meeting the deadline
http://www.sendspace.com/file/n5647o

pls help by downloading database and solve the subreport total on main report for me

 

[wiklendt]

you can solve it yourself by following the advice already given in this thread. if you are getting stuck with one of the suggestions, post your exact problem and a solution may become apparent.

people on this forum don't like to "just do it" for other people. as the famous saying goes "catch a fish for a man, he eats for a day; teach a man how to fish, and he eats the rest of his life".