Crystal Parameter Help

Yahoo Archive
1
I typically do use separate fields. {?BeginDate}, {?EndDate}.



Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kelly Wendorff
Sent: Tuesday, May 02, 2006 10:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Parameter Help



I'm building a labor edit report in Crystal (8.5) that I plan on
compiling and distributing to our shop supervisors.



I'd like to use a parameter field to let them choose the date range, but
I can't get it to work (I know I could use a discrete parameter and have
the supervisor choose every date they would like to see but that would
get annoying if they wanted a month's worth of data).



This is what I'm starting with - I know it is incorrect (that's why I'm
here).



{JobOper.StartDate} in Date {?Start Date} to Date {?Start Date}



Do I need to use two distinct parameter fields?



Any suggestions are greatly appreciated!



Thanks,



Kelly Wendorff
Cost Accounting Manager
SteelCraft Corporation
www.scc-wi.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/.
<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




SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>



_____

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]
2
I'm building a labor edit report in Crystal (8.5) that I plan on
compiling and distributing to our shop supervisors.



I'd like to use a parameter field to let them choose the date range, but
I can't get it to work (I know I could use a discrete parameter and have
the supervisor choose every date they would like to see but that would
get annoying if they wanted a month's worth of data).



This is what I'm starting with - I know it is incorrect (that's why I'm
here).



{JobOper.StartDate} in Date {?Start Date} to Date {?Start Date}



Do I need to use two distinct parameter fields?



Any suggestions are greatly appreciated!



Thanks,



Kelly Wendorff
Cost Accounting Manager
SteelCraft Corporation
www.scc-wi.com







[Non-text portions of this message have been removed]
3
Do u want to parameters like (?start date) and (?end date)?
Or one called date that is a range in which case {JobOper.StartDate} =
(?Start Date}

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kelly Wendorff
Sent: Tuesday, May 02, 2006 10:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Parameter Help


I'm building a labor edit report in Crystal (8.5) that I plan on
compiling and distributing to our shop supervisors.



I'd like to use a parameter field to let them choose the date range, but
I can't get it to work (I know I could use a discrete parameter and have
the supervisor choose every date they would like to see but that would
get annoying if they wanted a month's worth of data).



This is what I'm starting with - I know it is incorrect (that's why I'm
here).



{JobOper.StartDate} in Date {?Start Date} to Date {?Start Date}



Do I need to use two distinct parameter fields?



Any suggestions are greatly appreciated!



Thanks,



Kelly Wendorff
Cost Accounting Manager
SteelCraft Corporation
www.scc-wi.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
Yahoo! Groups Links
4
I really could use either method, but i was hoping to use a single
range parameter. Part of the reason is that it would be a little
easier for the end user. The other part of the reason is that I want
to figure it out because its bothering me.


--- In vantage@yahoogroups.com, "Frank Zeigafuse" <frankz@...> wrote:
>
> Do u want to parameters like (?start date) and (?end date)?
> Or one called date that is a range in which case {JobOper.StartDate} =
> (?Start Date}
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Kelly Wendorff
> Sent: Tuesday, May 02, 2006 10:17 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Parameter Help
>
>
> I'm building a labor edit report in Crystal (8.5) that I plan on
> compiling and distributing to our shop supervisors.
>
>
>
> I'd like to use a parameter field to let them choose the date range, but
> I can't get it to work (I know I could use a discrete parameter and have
> the supervisor choose every date they would like to see but that would
> get annoying if they wanted a month's worth of data).
>
>
>
> This is what I'm starting with - I know it is incorrect (that's why I'm
> here).
>
>
>
> {JobOper.StartDate} in Date {?Start Date} to Date {?Start Date}
>
>
>
> Do I need to use two distinct parameter fields?
>
>
>
> Any suggestions are greatly appreciated!
>
>
>
> Thanks,
>
>
>
> Kelly Wendorff
> Cost Accounting Manager
> SteelCraft Corporation
> www.scc-wi.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
> Yahoo! Groups Links
>
5
1st set up the parameter as a range.
2nd try this as selection criteria {JobOper.StartDate} = (?Start Date}


Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of wendorff1
Sent: Tuesday, May 02, 2006 10:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Parameter Help


I really could use either method, but i was hoping to use a single range
parameter. Part of the reason is that it would be a little easier for
the end user. The other part of the reason is that I want to figure it
out because its bothering me.


--- In vantage@yahoogroups.com, "Frank Zeigafuse" <frankz@...> wrote:
>
> Do u want to parameters like (?start date) and (?end date)? Or one
> called date that is a range in which case {JobOper.StartDate} =
> (?Start Date}
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Kelly Wendorff
> Sent: Tuesday, May 02, 2006 10:17 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Parameter Help
>
>
> I'm building a labor edit report in Crystal (8.5) that I plan on
> compiling and distributing to our shop supervisors.
>
>
>
> I'd like to use a parameter field to let them choose the date range,
> but I can't get it to work (I know I could use a discrete parameter
> and have the supervisor choose every date they would like to see but
> that would get annoying if they wanted a month's worth of data).
>
>
>
> This is what I'm starting with - I know it is incorrect (that's why
> I'm here).
>
>
>
> {JobOper.StartDate} in Date {?Start Date} to Date {?Start Date}
>
>
>
> Do I need to use two distinct parameter fields?
>
>
>
> Any suggestions are greatly appreciated!
>
>
>
> Thanks,
>
>
>
> Kelly Wendorff
> Cost Accounting Manager
> SteelCraft Corporation
> www.scc-wi.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
> Yahoo! Groups Links
>






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 Links
6
Worked! thanks, that seemed way to easy.

--- In vantage@yahoogroups.com, "Frank Zeigafuse" <frankz@...> wrote:
>
> 1st set up the parameter as a range.
> 2nd try this as selection criteria {JobOper.StartDate} = (?Start Date}
>
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of wendorff1
> Sent: Tuesday, May 02, 2006 10:39 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Parameter Help
>
>
> I really could use either method, but i was hoping to use a single range
> parameter. Part of the reason is that it would be a little easier for
> the end user. The other part of the reason is that I want to figure it
> out because its bothering me.
>
>
> --- In vantage@yahoogroups.com, "Frank Zeigafuse" <frankz@> wrote:
> >
> > Do u want to parameters like (?start date) and (?end date)? Or one
> > called date that is a range in which case {JobOper.StartDate} =
> > (?Start Date}
> >
> > Innovative Office Products, Inc.
> > Frank Zeigafuse
> > General Manager
> > 610-559-6369
> > fzeigafuse@
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of Kelly Wendorff
> > Sent: Tuesday, May 02, 2006 10:17 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Crystal Parameter Help
> >
> >
> > I'm building a labor edit report in Crystal (8.5) that I plan on
> > compiling and distributing to our shop supervisors.
> >
> >
> >
> > I'd like to use a parameter field to let them choose the date range,
> > but I can't get it to work (I know I could use a discrete parameter
> > and have the supervisor choose every date they would like to see but
> > that would get annoying if they wanted a month's worth of data).
> >
> >
> >
> > This is what I'm starting with - I know it is incorrect (that's why
> > I'm here).
> >
> >
> >
> > {JobOper.StartDate} in Date {?Start Date} to Date {?Start Date}
> >
> >
> >
> > Do I need to use two distinct parameter fields?
> >
> >
> >
> > Any suggestions are greatly appreciated!
> >
> >
> >
> > Thanks,
> >
> >
> >
> > Kelly Wendorff
> > Cost Accounting Manager
> > SteelCraft Corporation
> > www.scc-wi.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
> > Yahoo! Groups Links
> >
>
>
>
>
>
>
> 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 Links
>
7
Great.

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of wendorff1
Sent: Tuesday, May 02, 2006 10:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Parameter Help


Worked! thanks, that seemed way to easy.

--- In vantage@yahoogroups.com, "Frank Zeigafuse" <frankz@...> wrote:
>
> 1st set up the parameter as a range.
> 2nd try this as selection criteria {JobOper.StartDate} = (?Start Date}
>
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of wendorff1
> Sent: Tuesday, May 02, 2006 10:39 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Parameter Help
>
>
> I really could use either method, but i was hoping to use a single
> range parameter. Part of the reason is that it would be a little
> easier for the end user. The other part of the reason is that I want
> to figure it out because its bothering me.
>
>
> --- In vantage@yahoogroups.com, "Frank Zeigafuse" <frankz@> wrote:
> >
> > Do u want to parameters like (?start date) and (?end date)? Or one
> > called date that is a range in which case {JobOper.StartDate} =
> > (?Start Date}
> >
> > Innovative Office Products, Inc.
> > Frank Zeigafuse
> > General Manager
> > 610-559-6369
> > fzeigafuse@
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf Of Kelly Wendorff
> > Sent: Tuesday, May 02, 2006 10:17 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Crystal Parameter Help
> >
> >
> > I'm building a labor edit report in Crystal (8.5) that I plan on
> > compiling and distributing to our shop supervisors.
> >
> >
> >
> > I'd like to use a parameter field to let them choose the date range,
> > but I can't get it to work (I know I could use a discrete parameter
> > and have the supervisor choose every date they would like to see but

> > that would get annoying if they wanted a month's worth of data).
> >
> >
> >
> > This is what I'm starting with - I know it is incorrect (that's why
> > I'm here).
> >
> >
> >
> > {JobOper.StartDate} in Date {?Start Date} to Date {?Start Date}
> >
> >
> >
> > Do I need to use two distinct parameter fields?
> >
> >
> >
> > Any suggestions are greatly appreciated!
> >
> >
> >
> > Thanks,
> >
> >
> >
> > Kelly Wendorff
> > Cost Accounting Manager
> > SteelCraft Corporation
> > www.scc-wi.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
> > Yahoo! Groups Links
> >
>
>
>
>
>
>
> 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 Links
>






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 Links
8
Ok, final question.

My other parameter field is PartNum. I have it set as "Discrete" and
to allow multiple selections.

I'd like to display which PartNums are on the report in the Header.
If I put the ?PartNum field in the header it will only show the first
PartNum choosen. How do I display PartNum's 1,2,3,4...n?

Thanks!
9
I have to think about that one. :)

Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of wendorff1
Sent: Tuesday, May 02, 2006 12:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Parameter Help - one more question


Ok, final question.

My other parameter field is PartNum. I have it set as "Discrete" and to
allow multiple selections.

I'd like to display which PartNums are on the report in the Header.
If I put the ?PartNum field in the header it will only show the first
PartNum choosen. How do I display PartNum's 1,2,3,4...n?

Thanks!





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 Links