Sorry, I should have said "aggregate" instead of "summary". Too used to
calling it summary from the summation symbol used on the tool bar. Until I
looked just now I did not realize there was a Minimum function in the
calculated field creator. Yes, the aggregate is what spoofs RB into
allowing the reference.
I am now working on a report that uses "dummy" filters to pass user
parameters to reports and drive conditional band printing. Such as various
drill down levels to allow printing job or cost details in a part
profitability report. Another request has been to secure $ figures
depending on a password parsed out of the filter (as opposed to username
which would require on-going maintenance).
As long as we are on report builder tricks - I am also trying to write the
profitability report to selectively bold fields (such as negative). I was
thinking of converting number to a string in two fields - one for + and one
for - and the opposite getting loaded with spaces. Then laying them on top
of each other on the report and formatting one bold (or color). Bold spaces
are still just spaces so only the desired value should show. Haven't tried
it yet but if anyone know of an easier way to selectively bold I love to
learn it.
-Todd C.
-----Original Message-----
From: Aaron Hoyt [mailto:aaron@...]
Sent: Thursday, January 18, 2001 10:27 AM
To: vantage@egroups.com
Subject: RE: [Vantage] Printing filters for RB
The only thing I might add to this whole thing for the RB novice like
myself...
I found that the info below if perfect but you must create ParseFilter as an
aggregate field. I tried the calculated field first and got the familiar
indirect use error. Figured out to create it as aggregate with a little
deduction.
Again, I thank you Todd (and everyone else that responded), this is a great
improvement for my reports!
Aaron Hoyt
System Administrator
Design Standards Corp.
PO Box 1620
Charlestown, NH 03603
Tel 603-826-7744
<mailto:Aaron@...>
Here is more on filtering out the date range. I keep the following text and
open in with note pad to cut&paste into new report. ! = comments not
pasted. The starting point to search for the from date may need to be
changed if you have a lot of other filter cirteria before it. This has
been working really well for me. It could have been combined into one big
formula but that is harder to debug.
----------------- saved text starts here ----------
PrtFilter: Report-Filter() ! ( the system function)
ParseFilter: Minimum(PrtFilter) ! must pass thru summary due to indirect
use of function
! In the following adjust the starting point (60) as needed depending on the
filters
! and the position of the first date test. Use FromDate & ToDate in report
heading
Start-From: INDEX(ParseFilter,'equal to',60) + 9
Start-To: INDEX(ParseFilter,'equal to',Start-From) + 9
FromDate: SUBSTRING(ParseFilter,Start-From,10)
ToDate: SUBSTRING(ParseFilter,Start-to,10)
--------------- end save ---------------------
-Todd C.
eGroups Sponsor
<http://rd.yahoo.com/M=168002.1291681.2888959.2/D=egroupmail/S=1700007183:N/
A=564920/*http://www.columbiahouse.com/gateway?token=7407> Get 3 CDs for
ONLY $9.99!
Get 3 CDs for ONLY $9.99!
<http://us.adserver.yahoo.com/l?M=168002.1291681.2888959.2/D=egroupmail/S=17
00007183:N/A=564920/rand=330234415>
To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com
[Non-text portions of this message have been removed]
calling it summary from the summation symbol used on the tool bar. Until I
looked just now I did not realize there was a Minimum function in the
calculated field creator. Yes, the aggregate is what spoofs RB into
allowing the reference.
I am now working on a report that uses "dummy" filters to pass user
parameters to reports and drive conditional band printing. Such as various
drill down levels to allow printing job or cost details in a part
profitability report. Another request has been to secure $ figures
depending on a password parsed out of the filter (as opposed to username
which would require on-going maintenance).
As long as we are on report builder tricks - I am also trying to write the
profitability report to selectively bold fields (such as negative). I was
thinking of converting number to a string in two fields - one for + and one
for - and the opposite getting loaded with spaces. Then laying them on top
of each other on the report and formatting one bold (or color). Bold spaces
are still just spaces so only the desired value should show. Haven't tried
it yet but if anyone know of an easier way to selectively bold I love to
learn it.
-Todd C.
-----Original Message-----
From: Aaron Hoyt [mailto:aaron@...]
Sent: Thursday, January 18, 2001 10:27 AM
To: vantage@egroups.com
Subject: RE: [Vantage] Printing filters for RB
The only thing I might add to this whole thing for the RB novice like
myself...
I found that the info below if perfect but you must create ParseFilter as an
aggregate field. I tried the calculated field first and got the familiar
indirect use error. Figured out to create it as aggregate with a little
deduction.
Again, I thank you Todd (and everyone else that responded), this is a great
improvement for my reports!
Aaron Hoyt
System Administrator
Design Standards Corp.
PO Box 1620
Charlestown, NH 03603
Tel 603-826-7744
<mailto:Aaron@...>
Here is more on filtering out the date range. I keep the following text and
open in with note pad to cut&paste into new report. ! = comments not
pasted. The starting point to search for the from date may need to be
changed if you have a lot of other filter cirteria before it. This has
been working really well for me. It could have been combined into one big
formula but that is harder to debug.
----------------- saved text starts here ----------
PrtFilter: Report-Filter() ! ( the system function)
ParseFilter: Minimum(PrtFilter) ! must pass thru summary due to indirect
use of function
! In the following adjust the starting point (60) as needed depending on the
filters
! and the position of the first date test. Use FromDate & ToDate in report
heading
Start-From: INDEX(ParseFilter,'equal to',60) + 9
Start-To: INDEX(ParseFilter,'equal to',Start-From) + 9
FromDate: SUBSTRING(ParseFilter,Start-From,10)
ToDate: SUBSTRING(ParseFilter,Start-to,10)
--------------- end save ---------------------
-Todd C.
eGroups Sponsor
<http://rd.yahoo.com/M=168002.1291681.2888959.2/D=egroupmail/S=1700007183:N/
A=564920/*http://www.columbiahouse.com/gateway?token=7407> Get 3 CDs for
ONLY $9.99!
Get 3 CDs for ONLY $9.99!
<http://us.adserver.yahoo.com/l?M=168002.1291681.2888959.2/D=egroupmail/S=17
00007183:N/A=564920/rand=330234415>
To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com
[Non-text portions of this message have been removed]