DSUM(#ERROR) IN A REPORT'S SUBREPORT

[Shafique]

HI EVERYONE
I am creating a REPORT (Untitled.jpeg) named [DISCOLOR] with date range criteria. i use this report (Untitled2) in an another report as subreport.
but in main report the dsum of subreport is returen with an error.

Any solution

 

[Micron]

AFAIK, domain functions (e.g. DSum) can only go in report header, detail section or footer section and not page header so where did you put the sub report?
Also, post the expression you're using in the main report control that holds the sum.
Can also be caused by having control names the same as field names, which is what you get when you use form and report wizards. Why the wizards do this has always baffled me. Aggregate functions work with fields, not controls. If the names are the same it can cause this. If I use a wizard, I never leave the control names as they are unless I am just playing around and don't intend to keep the form/report.

 

[Shafique]

AFAIK, domain functions (e.g. DSum) can only go in report header, detail section or footer section and not page header so where did you put the sub report?
Also, post the expression you're using in the main report control that holds the sum.
Can also be caused by having control names the same as field names, which is what you get when you use form and report wizards. Why the wizards do this has always baffled me. Aggregate functions work with fields, not controls. If the names are the same it can cause this. If I use a wizard, I never leave the control names as they are unless I am just playing around and don't intend to keep the form/report.

When this report [DISCOLOR] is opened individually, everything is fine. But when opening it in main report [GENERAL] which has it as sub report it gives error. I have not linked this report (DISCOLOR) to any control main report (GENERAL).
I tried several ways to make it but couldn't find a solution. However, it is definitely my fault. But can't find it

 

[Micron]

I have to go out for a while so right now, can only suggest you review these

Microsoft Access tips: Bring the total from a subreport back onto the main report

How to bring a total back from a subreport to the main report in a Microsoft Access database.

allenbrowne.com

Display a total from a subreport on the main report

Create and use subreports - Microsoft Support

Subreports let you view records from the "many" side of a one-to-many relationship on an Access report.

support.microsoft.com

or google
"ms access get subreport total in main report"