Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lineage Not Counting On First Record

Status
Not open for further replies.

brxmas

Programmer
Feb 9, 2004
69
US
ODBC 2000
Crystal 11.0

LB

I really appreciate the information you sent above.

The only issue I'm having is if I add the following for
my lineage in the 'Running Total' that it doesn't count my
Group
Class Desc
class_int

My report gives me the correct # of Ads and Revenue $$, but NO Lineage for the first Class Desc.

Running Total formula:
(
{mc_ad_detail_view.ad_num} <> Previous({mc_ad_detail_view.ad_num})
)
Employment
Class Int # Ads Revenue Lineage
510 Career College 1 $679.35 0 should be 3

Income Properties
Class Int # Ads Revenue Lineage
300 Apts Modesto 1 $ 214.18 3
315 Homes North Area 1 $ 205.91 3
320 Homes South Area 5 $1,154.23 31
300 Homes For Rent 1 $ 356.15 7

Thanks in advance for your help.

BC
 
If you're checking for the previous, this is likely to be null on the first record, and nulls kill everything unless tested for with isnull.

In this case, onfirstrecord might be a better test. Try
Code:
if onfirstrecord
or {mc_ad_detail_view.ad_num} <> Previous({mc_ad_detail_view.ad_num}

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
When I try the formula below, I get 0's.

if onfirstrecord
or {mc_ad_detail_view.ad_num} <> Previous({mc_ad_detail_view.ad_num}
 
Please clarify. Where are you putting your running total? Is the data in groups, or what?

A running total gets accumulated as the records are printed.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top