We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

subreport imbedded on a main report improper results

whosoever
whosoever asked
on
Medium Priority
424 Views
Last Modified: 2012-08-13
I have a main report "A" on the trip table.
  sorted and breaks by cust and commodity.

I produced a summary report "B" able to be run on the cust and commodity break that allows selection by cust, commodity but sorts and summarizes by ship.

I have tried to imbed report "B" into the footer section of report "A".  
I want report "B" to total only the number of trips on that page break.

Can I accomplish this with this method?

Comment
Watch Question

jadedataMS Access Systems Creator
CERTIFIED EXPERT

Commented:
Access does not provide this function directly

You would have to actually assign records to pages in the report and use that page number assignment as a group in order to get the second subreport to work as you describe.

-j-

Commented:
try putting your subreport in the group footer and not the page footer.

Steve

Author

Commented:
I appreciate your time.  Thank you.  I will give it a try.

Author

Commented:
Steve,
I have report "B" in the group footer for commodity, since that breaks more than customer and is where I want the subreport to appear.  Any specific settings to adjust?


Jadedata,
I have the page number printing on the report at each detail line.
Can I update  the trip record with that value from the report?  I am not sure what to do next?

Thank you both.

I am trying to not have to perform all the accummulations at the detail and the summary print in the main report?

It seems so straight forward if the two reports work separately that I could embed.

Commented:
I think you will need to build a composite key  of cust and commodity in both the main report's query and the subreport's query to make sure both are displaying results for the same records and use the composite key as the linking field between them.

Steve
jadedataMS Access Systems Creator
CERTIFIED EXPERT

Commented:
Steve:  

I think whosoever is looking for page totals.  The only way I've been able to do these with out report code to runtime total a control on a page is to ASSIGN the page to the report in advance based on one or more conditions (worked pretty well too as I recollect..)  and then group on that assigned page number to get the page totals.

Author

Commented:
jadedata:
I have the page number updated in the table.  How do I specify in the query controlling the data coming into the subreport to only bring in that particular pages records?
MS Access Systems Creator
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I am having to deal with groups that span pages.

I am working on some code.  I will let you know.  

Thanks,

jadedataMS Access Systems Creator
CERTIFIED EXPERT

Commented:
perhaps if you always started a new LOGICAL group on a new page, instead of trying to acquire a page total....

Page totals are generally of little value without some other kind of LOGICAL grouping limited to that page as well.

Author

Commented:
Jadedata,
Thanks again for all your help.  I am going to the top of page at each new cust/comdty break.

The code is currently set to udpate a page number on the records at On detail of the report.  When the subreport runs at comdty break the records are chosen by linking the current page number with the records from the table that are updated with that page number.

A problem exists when, a particular cust, comdty has records that go beyond 10 on a page(two lines of data per record) the subreport goes to the next page and the pagenumbers are off!!


Author

Commented:
Nico, can you help?
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.