Report/Sub Report problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sub report with a "count" in the report footer. When I run the sub
report it works fine. When I insert the sub report into my master report the
value on the sub report is always "1". How can I fix it?
 
Yes, I have the records in the detail section and count the records in the
report footer. The count in the footer works fine. When the subreport is in
my main report the count always returns 1.

I have tried adding a separate query to my main report query. When I did
this I now get an error message stating "duplicated fields". This is due to
having the same field in my detailed section of my main report and a total of
the same field from the subreport query in the report footer.

My goal is to have a 2 totals from one field (the fiels contains two
different classes i.e. class A and class B) Im trying to query out the
classes and total them.

Thanks for your help.
 
Let me try again, If you display the border around the subreport, is your
subreport only displaying one record with a count in its subreport footer of
1 OR does your bordered subreport display more than one record but still
display only 1 in its subreport footer?
 
Yes to the first part of your question. The subreport is only displaying 1
record with a count of 1.
 
Then the 1 is accurate. If you expect more than one record you may need to
remove the most detailed of the fields from the Link Master/Child
properties.
 
I have tried taking out the link Master/Child. I have a "Between" date
control on the master report and the date control does not work when I have
no master/child link. It gives me all the records outside of the date range.

Thanks.
 
I'm not sure how you get 'a "Between" date control on the master report'. If
you are using a parameter prompt, consider changing this to use controls on
a form.
 
Back
Top