Parameter with RB

Yahoo Archive
1
Have the "Change Report Filter" box checked by default when you set up the
report with Custom Report Links. When the employee selects the print
button, the filter box will be displayed and updated.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Lori Baker [mailto:lbaker@...]
Sent: Wednesday, November 27, 2002 12:35 PM
To: Vantage Onelist (vantage@onelist.com)
Subject: [Vantage] Parameter with RB


I am starting to use RB and am not sure how to create a parameter so that
when a user wants to print the report, they are prompted to enter the data
they want to see. Any help?

Thanks,

Lori

Lori A. Baker
Director of Information Systems
WindStone Medical Inc. (formerly Cardio Pak Inc.)
406.259.6387
lbaker@... <mailto:lbaker@...>
www.windstonemedical.com <http://www.windstonemedical.com/>




[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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
I am starting to use RB and am not sure how to create a parameter so that
when a user wants to print the report, they are prompted to enter the data
they want to see. Any help?

Thanks,

Lori

Lori A. Baker
Director of Information Systems
WindStone Medical Inc. (formerly Cardio Pak Inc.)
406.259.6387
lbaker@... <mailto:lbaker@...>
www.windstonemedical.com <http://www.windstonemedical.com/>




[Non-text portions of this message have been removed]
3
Lori,
RB is not so friendly as Crystal in regards to parameters. Basically you use the FILTER option when designing the report. The filter icon looks like a funnel on the toolbar. After you enter your filters in designer, then you put the report into Vantage in the Custom Report Links Maintenance. When you add a new Report, there is a check box that says "Change Report Filters". By checking this box, a user will be presented with the filter list that was set up in the report. You will have to instruct your users in the proper syntax for report filters. It's rather un-userfriendly to say the least.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Lori Baker
To: Vantage Onelist (vantage@onelist.com)
Sent: Wednesday, November 27, 2002 12:34 PM
Subject: [Vantage] Parameter with RB


I am starting to use RB and am not sure how to create a parameter so that
when a user wants to print the report, they are prompted to enter the data
they want to see. Any help?

Thanks,

Lori

Lori A. Baker
Director of Information Systems
WindStone Medical Inc. (formerly Cardio Pak Inc.)
406.259.6387
lbaker@... <mailto:lbaker@...>
www.windstonemedical.com <http://www.windstonemedical.com/>




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


Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
4
I've never seen a good way to do this from reports run from within Vantage.
I think there is a way from outside Vantage (or VB Forms) via .p routines
and the command line attributes for running RB but that is WAY beyond my
level.

So I usually pass parameters via the filters. Even if it is not a real
filter. For example to prompt whether they want details I will create a
function field called "Details" and set it to be 'XXX' then in the filter
have one that selects for "Details <> True" (never mind that the <> does not
make sense really - I don't really want to filter anything). Then using the
REPORT-FILTER() function (via an aggregate into a String field) I brute
force parse out the value (True or False) as a string and then use this to
make a logical that controls whether a band line gets printed or not.

Not pretty, in fact a real kludge, but it works. I use a similar technique
for date ranges (except actually filter in this case) and print the date
range on the heading.

When you put a RB report on a Vantage menu check mark the 'Change Filters'
box so that it comes up by default. Then the users don't have to do
anything to see the filter selections. Only downside is frisky users that
try to add their own filters ('Why don't I get anything when I filter on
CustNum?") and they don't understand what they are doing. Could lead to
seriously misleading information.

Good luck,
-Todd C.

PS - Any bets whether this will appear today? Yahoo looks to be about 3 hrs
late. I sent out a question at 11:05 that has not shown yet. Arrrgh!

-----Original Message-----
From: Lori Baker [mailto:lbaker@...]
Sent: Wednesday, November 27, 2002 11:35 AM
To: Vantage Onelist (vantage@onelist.com)
Subject: [Vantage] Parameter with RB


I am starting to use RB and am not sure how to create a parameter so that
when a user wants to print the report, they are prompted to enter the data
they want to see. Any help?

Thanks,

Lori

Lori A. Baker
Director of Information Systems
WindStone Medical Inc. (formerly Cardio Pak Inc.)
406.259.6387
lbaker@... <mailto:lbaker@...>
www.windstonemedical.com < http://www.windstonemedical.com/
<http://www.windstonemedical.com/> >




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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=237459.2675695.4055211.2225243/D=egroupweb/S=17050071
83:HM/A=1267611/R=0/*http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
300x250;ord=1038418558538362?>

<http://us.adserver.yahoo.com/l?M=237459.2675695.4055211.2225243/D=egroupmai
l/S=:HM/A=1267611/rand=703156147>

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
<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
<http://groups.yahoo.com/group/vantage/links>

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]