By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,747 Members | 1,672 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,747 IT Pros & Developers. It's quick & easy.

Report Total Line: Summing just two rows?

P: n/a
I have a subreport that will never have more than 2 rows.

It might have one and it might have none, but it will never have more
than two.

For the total line, however, I need something the client calls
"Residual". It's not just the diff between first/second rows. If the
first row is -7 and the second row is +8, the residual is -15.
OTOH, if the first row is -8 and the second row is +7, the residual is
-15.

VIZ:

FirstValue -7
SecondValue +8
--------------
Residual -15
FirstValue +7
SecondValue -8
--------------
Residual +15
I'm tempted to set up a report that's not even based on a recordset and
just plug in the values one-by-one.....but maybe there's a better way.
Anybody been here?

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.