Report Builder - printing calculated field value used as filter

Yahoo Archive
1
I knew I was making this harder than it needed to be. Just what I needed.

Thanks Aaron

Kim



-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Thursday, September 02, 2004 9:14 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder - printing calculated field value used as filter


Kim,
Sorry for the misunderstanding.
Wouldn't this be easier to do with just a filter that has
Part.Description MATCHES '*A1*'. instead of the filter and formula.
Or is the position of the searched text important? Are the search
values static?
Another untested thought would be to look at making the text value
searched for a formula (static text value) and using that formula field
as part of the index formula. Then you could place the value of the
text searched formula at will.
I admit I don't fully understand your goal in the report, but these seem
potential workarounds for you.
If I am still off track, please fill in some more details about what the
goal of the report is.
Aaron

-----Original Message-----
From: Kim Trapp [mailto:ktrapp@...]
Sent: Thursday, September 02, 2004 9:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder - printing calculated
field value used as filter


Aaron,

Thanks for the tips. But won't the report filter show the
starting position returned from the index function? What I really want
in the report filter is the string that the index function is searching
for.

Kim





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



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/.
(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



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129vlp96m/M=298184.5285298.6392945.3001176/D=groups/S=1705007183:HM/EXP=1094220855/A=2319498/R=0/SIG=11thfntfp/*http://www.netflix.com/Default?mqso=60185352&partid=5285298> click here
<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=:HM/A=2319498/rand=835902389>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


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




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

Thanks for the tips. But won't the report filter show the starting position returned from the index function? What I really want in the report filter is the string that the index function is searching for.

Kim

-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Thursday, September 02, 2004 8:01 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder - printng calculated field value used as filter


Kim,
I will point you in a direction. It might be just what you are looking
for.
Create a calculated field. In the field insert the built in function
REPORT-FILTER(). You should be able to place this calculated field on
the report at will.
While you are there, check out the other REPORT- ...functions for other
useful information to put in calculated fields.
Good luck,
Aaron Hoyt
Hittite Microwave

-----Original Message-----
From: hawkkt [mailto:ktrapp@...]
Sent: Wednesday, September 01, 2004 5:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder - printng calculated field
value used as filter


I have several calculated fields in a report that search for
substrings in the part number or part description field. One
such
caluculated field is called searchCriteria1. Formula is INDEX
(Part.PartNum,'A2')

Then in the report filter I am filtering on searchCriteria <> 0.

Is there a way to show the values (A2 for example) that reside
in the
index formulas on the report? I want to put something in the
header
like this: Search Results For Partial Descriptions of XXX and
XXX
and XXX.

Perhaps there is a better way to do this; I'm relatively new at
Report Builder

Thanks,

Kim Trapp
Hawk Technology Ltd

ver 5.0.131



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/.
(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



Yahoo! Groups Sponsor

< http://us.ard.yahoo.com/SIG=129e5ib67/M=296572.5305651.6444487.3001176/
D=groups/S=1705007183:HM/EXP=1094159111/A=2195326/R=2/SIG=12ip9tdt8/*htt
p://clk.atdmt.com/VON/go/yhxxxvon00700677von/direct/01/&time=10940727115
38259>

< http://us.adserver.yahoo.com/l?M=296572.5305651.6444487.3001176/D=group
s/S=:HM/A=2195326/rand=269731760>


________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

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




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



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/.
(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



Yahoo! Groups Sponsor

<http://us.ard.yahoo.com/SIG=129g9sb84/M=296572.5305651.6444487.3001176/D=groups/S=1705007183:HM/EXP=1094216477/A=2195326/R=2/SIG=12is0jeuh/*http://clk.atdmt.com/VON/go/yhxxxvon00700677von/direct/01/&time=1094130077787880>
<http://us.adserver.yahoo.com/l?M=296572.5305651.6444487.3001176/D=groups/S=:HM/A=2195326/rand=319157986>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


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




[Non-text portions of this message have been removed]
3
Kim,
Sorry for the misunderstanding.
Wouldn't this be easier to do with just a filter that has
Part.Description MATCHES '*A1*'. instead of the filter and formula.
Or is the position of the searched text important? Are the search
values static?
Another untested thought would be to look at making the text value
searched for a formula (static text value) and using that formula field
as part of the index formula. Then you could place the value of the
text searched formula at will.
I admit I don't fully understand your goal in the report, but these seem
potential workarounds for you.
If I am still off track, please fill in some more details about what the
goal of the report is.
Aaron

-----Original Message-----
From: Kim Trapp [mailto:ktrapp@...]
Sent: Thursday, September 02, 2004 9:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder - printing calculated
field value used as filter


Aaron,

Thanks for the tips. But won't the report filter show the
starting position returned from the index function? What I really want
in the report filter is the string that the index function is searching
for.

Kim





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