Sorting/Calculating

  • Thread starter Thread starter Beth B.
  • Start date Start date
B

Beth B.

Hello all. Is there a way to perform a function on a field
that is contained in the detail section of a report and
have the result print as a footer for each of those
records, when that is not the primarily sorted record for
the detail field? Example: My report detail sorts by
product leader, and contains data reflecting the date an
item was received, the item description, and what customer
the item is from.
The report needs to remain separated by product leader,
but I need to perform a calculation on the date received
field to give me how many days it's been in-house for each
date. I know how to do this, but since product leader is
my main sort, it is only doing the function overall, not
for each date.
In addition, I need to page break for each product
leader (which is why I set that as the primary sort). Is
there a way to page break at each product leader without
it being my primary sort that would be simpler than trying
to calculate each date?
Any advice would be much appreciated.
 
Hi Beth,
Not sure I totally followed your scenario, but it
sounds like you can probably get what you want by creating
a subreport. You can create a query that does all your
date manipulations. Create a report based on this query,
and then you could add this report as a subreport into
your main report.
 
Les -
Thank you for your reply. What I ended up doing was
making the product leader a header with page breaks before
each, and doing the calculation for the date difference in
the detail section instead of as a footer.
 
Back
Top