Report Builder: Printing Criteria used in Filter

system · November 1, 2000, 8:42am

Sorry, forgot about the middle step with the aggregate due to restriction on
refering to Filter function in another function. I use the "minimum"
aggregate to create PrtFilter and then manipulate that. I should have
looked at an example to get all the steps before replying.
-Todd C.

-----Original Message-----
From: calvin [mailto:calvin@...]
Sent: Tuesday, October 31, 2000 4:39 PM
To: vantage@egroups.com
Subject: Re: [Vantage] Report Builder: Printing Criteria used in Filter

Todd -

Please confirm. I haven't found a way to reference a calc
field of the REPORT-FILTER in a second calc field using
SUBSTRING - without moving the value through an
aggregate. In essence, I haven't found a way to do:
SUBSTRING(REPORT-FILTER(), x, y)

Please advise - the way I just posted is very tedious to set
up for multiple filters. Would love a short cut.

Thx,
Calvin

----- Original Message -----
From: Todd Caughey <caugheyt@...>
To: <vantage@egroups.com>
Sent: Tuesday, October 31, 2000 4:14 PM
Subject: RE: [Vantage] Report Builder: Printing Criteria used in Filter

> I'll expand on the previous reply - use the Index and Substring functions.
> Because the text will be fairly static (unless you are adding filters at
run
> time) you can search for various starting positions of known phrases and
> takes the n-th thru n-th+whatever characters. To keep it all clear you
may
> want to make seperate calculations for various starting and ending
positions
> and use them in the final substring calculation. Once you have the
"clear"
> text values you can string them together as a final phrase such as -
> Report from 10/01/00 to 10/31/00 -
> -Todd C.
>
> -----Original Message-----
> From: Todd Caughey [mailto:caugheyt@...]
> Sent: Tuesday, October 31, 2000 3:59 PM
> To: 'vantage@egroups.com'
> Subject: RE: [Vantage] Report Builder: Printing Criteria used in Filter
>
>
> Yes, I do it all the time. There is a function REPORT-FILTER() which you
> can use in a Calculated field (I call PrtFilter) and include in the
> Page-Header or the report footer. The results are often wordy and use
> database field names but are usually understandable. If you know what to
> string search for you can parse out the bits you want into a friendler
> format.
>
> -Todd C.
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@...]
> Sent: Tuesday, October 31, 2000 3:14 PM
> To: vantage@egroups.com
> Subject: [Vantage] Report Builder: Printing Criteria used in Filter
>
>
> Is it possible to print the values used in the filter. I want to
> show the date range that we are printing this report for.
>
> Thanks,
> Brian Stenglein
>
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
> < http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/> >
> < http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
> < http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/> > >
> (Note: If this link does not work for you the first time you try it, go
to
> www.egroups.com, login and be sure to save your password, choose My
Groups,
> choose Vantage, then choose Files. If you save the password, the link
above
> will work the next time you try it.)
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> eGroups Sponsor
> < http://click.egroups.com/1/9648/13/_/411782/_/973029570/
<http://click.egroups.com/1/9648/13/_/411782/_/973029570/> >
>
>
>
<
http://adimg.egroups.com/img/9648/13/_/411782/_/973029570/TargetSoftware468
<http://adimg.egroups.com/img/9648/13/_/411782/_/973029570/TargetSoftware468
>
> x602F.gif>
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
> < http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/> >
> (Note: If this link does not work for you the first time you try it, go
to
> www.egroups.com, login and be sure to save your password, choose My
Groups,
> choose Vantage, then choose Files. If you save the password, the link
above
> will work the next time you try it.)
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)

eGroups Sponsor
<http://click.egroups.com/1/8657/13/_/411782/_/973032257/>

<http://adimg.egroups.com/img/8657/13/_/411782/_/973032257/468x60_Family.gif
>

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)

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

system · October 31, 2000, 4:13pm

Is it possible to print the values used in the filter. I want to
show the date range that we are printing this report for.

Thanks,
Brian Stenglein

system · October 31, 2000, 4:16pm

Yes.

First you must create a calculated field for the filter, Ex: name it
"Filter" and the Expression should be REPORT-FILTER(). Then add the field
'Filter' to your report.

system · October 31, 2000, 4:52pm

Thanks, I'm I stuck with the entire expression it returns or is there
some way to clean it up?

--- In vantage@egroups.com, sarah.vareschi@n... wrote:
> Yes.
>
> First you must create a calculated field for the filter, Ex: name it
> "Filter" and the Expression should be REPORT-FILTER(). Then add
the field
> 'Filter' to your report.

system · October 31, 2000, 4:59pm

Yes, I do it all the time. There is a function REPORT-FILTER() which you
can use in a Calculated field (I call PrtFilter) and include in the
Page-Header or the report footer. The results are often wordy and use
database field names but are usually understandable. If you know what to
string search for you can parse out the bits you want into a friendler
format.

-Todd C.

-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Tuesday, October 31, 2000 3:14 PM
To: vantage@egroups.com
Subject: [Vantage] Report Builder: Printing Criteria used in Filter

Is it possible to print the values used in the filter. I want to
show the date range that we are printing this report for.

Thanks,
Brian Stenglein

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)

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

system · October 31, 2000, 5:15pm

I'll expand on the previous reply - use the Index and Substring functions.
Because the text will be fairly static (unless you are adding filters at run
time) you can search for various starting positions of known phrases and
takes the n-th thru n-th+whatever characters. To keep it all clear you may
want to make seperate calculations for various starting and ending positions
and use them in the final substring calculation. Once you have the "clear"
text values you can string them together as a final phrase such as -
Report from 10/01/00 to 10/31/00 -
-Todd C.

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, October 31, 2000 3:59 PM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] Report Builder: Printing Criteria used in Filter

Yes, I do it all the time. There is a function REPORT-FILTER() which you
can use in a Calculated field (I call PrtFilter) and include in the
Page-Header or the report footer. The results are often wordy and use
database field names but are usually understandable. If you know what to
string search for you can parse out the bits you want into a friendler
format.

-Todd C.

-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Tuesday, October 31, 2000 3:14 PM
To: vantage@egroups.com
Subject: [Vantage] Report Builder: Printing Criteria used in Filter

Is it possible to print the values used in the filter. I want to
show the date range that we are printing this report for.

Thanks,
Brian Stenglein

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
< http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/> >
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)

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

eGroups Sponsor
<http://click.egroups.com/1/9648/13/_/411782/_/973029570/>

<http://adimg.egroups.com/img/9648/13/_/411782/_/973029570/TargetSoftware468
x602F.gif>

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)

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

system · October 31, 2000, 5:44pm

Brian -

I haven't found a way to directly perform this request with just a
calculated field.
Try the following steps.

First create a calculated field (ie.,
FieldName: reportfilter
Expression: REPORT-FILTER()

Second create an aggregate field (ie.,
Named: filterag: Maximum of field reportfilter, reset per page.

Third create a calculated field to extract the text from the aggregate
filter.
You will need to specify where in the string the text you want is located
with the starting number and how many chars to return (ie.,
FieldName: filter1
Expression: SUBSTRING(filterag, 10, 8)

Add the filter1 to the report.
Repeat for as many filters as are in the report.
The only pain is mapping which char(s) in the filter string are the part you
want. Have patience counting!

Hope this helps,
Calvin

----- Original Message -----
From: Brian Stenglein <bstenglein@...>
To: <vantage@egroups.com>
Sent: Tuesday, October 31, 2000 3:35 PM
Subject: [Vantage] Re: Report Builder: Printing Criteria used in Filter

> Thanks, I'm I stuck with the entire expression it returns or is there
> some way to clean it up?
>
>
> --- In vantage@egroups.com, sarah.vareschi@n... wrote:
> > Yes.
> >
> > First you must create a calculated field for the filter, Ex: name it
> > "Filter" and the Expression should be REPORT-FILTER(). Then add
> the field
> > 'Filter' to your report.
>
>
>
>
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)

system · October 31, 2000, 5:44pm

Todd -

Please confirm. I haven't found a way to reference a calc
field of the REPORT-FILTER in a second calc field using
SUBSTRING - without moving the value through an
aggregate. In essence, I haven't found a way to do:
SUBSTRING(REPORT-FILTER(), x, y)

Please advise - the way I just posted is very tedious to set
up for multiple filters. Would love a short cut.

Thx,
Calvin

----- Original Message -----
From: Todd Caughey <caugheyt@...>
To: <vantage@egroups.com>
Sent: Tuesday, October 31, 2000 4:14 PM
Subject: RE: [Vantage] Report Builder: Printing Criteria used in Filter

> I'll expand on the previous reply - use the Index and Substring functions.
> Because the text will be fairly static (unless you are adding filters at
run
> time) you can search for various starting positions of known phrases and
> takes the n-th thru n-th+whatever characters. To keep it all clear you
may
> want to make seperate calculations for various starting and ending
positions
> and use them in the final substring calculation. Once you have the
"clear"
> text values you can string them together as a final phrase such as -
> Report from 10/01/00 to 10/31/00 -
> -Todd C.
>
> -----Original Message-----
> From: Todd Caughey [mailto:caugheyt@...]
> Sent: Tuesday, October 31, 2000 3:59 PM
> To: 'vantage@egroups.com'
> Subject: RE: [Vantage] Report Builder: Printing Criteria used in Filter
>
>
> Yes, I do it all the time. There is a function REPORT-FILTER() which you
> can use in a Calculated field (I call PrtFilter) and include in the
> Page-Header or the report footer. The results are often wordy and use
> database field names but are usually understandable. If you know what to
> string search for you can parse out the bits you want into a friendler
> format.
>
> -Todd C.
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@...]
> Sent: Tuesday, October 31, 2000 3:14 PM
> To: vantage@egroups.com
> Subject: [Vantage] Report Builder: Printing Criteria used in Filter
>
>
> Is it possible to print the values used in the filter. I want to
> show the date range that we are printing this report for.
>
> Thanks,
> Brian Stenglein
>
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> <http://www.egroups.com/files/vantage/>
> < http://www.egroups.com/files/vantage/
> <http://www.egroups.com/files/vantage/> >
> (Note: If this link does not work for you the first time you try it, go
to
> www.egroups.com, login and be sure to save your password, choose My
Groups,
> choose Vantage, then choose Files. If you save the password, the link
above
> will work the next time you try it.)
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> eGroups Sponsor
> <http://click.egroups.com/1/9648/13/_/411782/_/973029570/>
>
>
>
<http://adimg.egroups.com/img/9648/13/_/411782/_/973029570/TargetSoftware468
> x602F.gif>
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> <http://www.egroups.com/files/vantage/>
> (Note: If this link does not work for you the first time you try it, go
to
> www.egroups.com, login and be sure to save your password, choose My
Groups,
> choose Vantage, then choose Files. If you save the password, the link
above
> will work the next time you try it.)
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)

system · November 1, 2000, 7:33am

Brian,
In report builder, click on add a calculated field, double click Report-Filter[] and give it a field name. Add this to your report header or footer, it will print all filter information criterea used in query for report.

----- Original Message -----
From: Brian Stenglein
To: vantage@egroups.com
Sent: Tuesday, October 31, 2000 3:13 PM
Subject: [Vantage] Report Builder: Printing Criteria used in Filter

Is it possible to print the values used in the filter. I want to
show the date range that we are printing this report for.

Thanks,
Brian Stenglein

We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)

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