RB - Excluded Band Lines Also Excluded From Aggregates?

Yahoo Archive
1
That has been my experience that excluded lines are not added to the
aggregate. We use it to show/not show open closed po and sales order lines
and to total the results.



Shirley



-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Monday, December 08, 2003 3:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RB - Excluded Band Lines Also Excluded From Aggregates?



I'm seeing some pleasantly surprising results in Report Builder and I would
like to confirm (if anyone knows) if this is really a feature in RB.

I have a report where I am inhibiting printing of certain band lines (a
sales report where I don't want to see parts first made before this year)
but I can't filter them out because in order to determine if they were "old"
I need all prior invoices & jobs). So I inhibit printing them on the Part
sort group footer based on the oldest job date. I have another aggregate
that totals the Part Total at a higher level to then get a total for all of
the estimator's parts.

What I am seeing is that although I have not otherwise excluded prior year
invoices it seems to be skipping adding to the aggregate any part that is
not printed and not adding them to the estimator's total. All this time
I've been doing RB I've manually excluded amounts on inhibited lines from
the field I aggregate on. If inhibited lines don't get aggregated this
would open up a lot of nice possabilities as well as make such reaports a
lot easier.

Does RB really work this way? Is it smart enough to exclude print inhibited
totals from further totaling? My preliminary testing says 'yes' but before
I do a lot of testing I wanted to see if someone knows already.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://rd.yahoo.com/SIG=12cj04tgd/M=267637.4116732.5333197.1261774/D=egroup
web/S=1705007183:HM/EXP=1071000985/A=1853619/R=0/*http:/www.netflix.com/Defa
ult?mqso=60178356&partid=4116732> click here



<http://us.adserver.yahoo.com/l?M=267637.4116732.5333197.1261774/D=egroupmai
l/S=:HM/A=1853619/rand=545749637>


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.


Tracking #: FCD64EA1950C4047A39BD16156CE7BACF91E894A


[Non-text portions of this message have been removed]
2
I'm seeing some pleasantly surprising results in Report Builder and I would like to confirm (if anyone knows) if this is really a feature in RB.

I have a report where I am inhibiting printing of certain band lines (a sales report where I don't want to see parts first made before this year) but I can't filter them out because in order to determine if they were "old" I need all prior invoices & jobs). So I inhibit printing them on the Part sort group footer based on the oldest job date. I have another aggregate that totals the Part Total at a higher level to then get a total for all of the estimator's parts.

What I am seeing is that although I have not otherwise excluded prior year invoices it seems to be skipping adding to the aggregate any part that is not printed and not adding them to the estimator's total. All this time I've been doing RB I've manually excluded amounts on inhibited lines from the field I aggregate on. If inhibited lines don't get aggregated this would open up a lot of nice possabilities as well as make such reaports a lot easier.

Does RB really work this way? Is it smart enough to exclude print inhibited totals from further totaling? My preliminary testing says 'yes' but before I do a lot of testing I wanted to see if someone knows already.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]