Did you add the parameters to the select statement for crystal?

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: Susan Iverson [mailto:siverson@...]
Sent: Tuesday, July 19, 2005 10:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Parameters

I just created a report for Shipping Totals. I setup parameters for
"plant" and for "ship date" ranges. Although it prompts me nicely for
the parameters, it returns "ALL" records no matter what I enter. Since
I'm a beginner Crystal Report writer, would anyone be kind enough to
tell me what I might be doing wrong? Where do I look first for the
problem?

[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/.
<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 LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* 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]

Sophie;

Under insert create a new parameter field. Give it a name that is
meaningful to you, in the prompting text tell the user what you want
entered, in value type select string, in prompting value you can enter an
example of what you want.

Then in record selection formula select the part number field from the table
to be selected against followed by [ ] brackets for the number of char's to
be compared against. Example:

{Part.partnum)[1 to 3] = ?selpart

Don't put any space between the } bracket and the [ bracket. You don't have
to use spaces around the word to or the equal sign, I do for better
readability.

If you have questions feel free to contact me.

Also if you are using Crystal Reports heavily and really want to know what
Seagate says about building reports, they offer a learning CD tutorial
program for about 100 - 125 dollars that is good.

Warren R. Eddy
Information Services Manager
National Tube Form, LLC
An Excaliber Company
e-mail - Warren.Eddy@...
<mailto:Warren.Eddy@...>
phone - 219 478-2363 ext 217
fax - 219 478-1043

????????????????>???????????????????????????????????????????????>???????????
????>????????????????? I'd like to create a parameter field asking the
user to enter
the first 3 digits of the part number.
Any ideas on the best way to achieve this?
Thanks in advance
Sophie

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]

I just created a report for Shipping Totals. I setup parameters for
"plant" and for "ship date" ranges. Although it prompts me nicely for
the parameters, it returns "ALL" records no matter what I enter. Since
I'm a beginner Crystal Report writer, would anyone be kind enough to
tell me what I might be doing wrong? Where do I look first for the
problem?

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