Report Builder - printng calculated field value used as filter

Yahoo Archive
1
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]
2
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