Vantage 6.1 Crystal Question - Some Vendors or All Vendors

Thanks, for all the responses.



Dan that link was the solution.



Thanks again.



Robert MacDonald

Information Technology Manager

Ground Effects Ltd.



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Dan Shallbetter
Sent: Tuesday, October 18, 2005 1:33 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 6.1 Crystal Question - Some Vendors or All
Vendors



Take a look at ths perhaps it will help

http://support.businessobjects.com/library/kbase/articles/c2005464.asp

Dan Shallbetter
States Electric Mfg.


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Tuesday, October 18, 2005 10:45 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 6.1 Crystal Question - Some Vendors or
All Vendors


> I need a crystal report to allow the user to select some or all
vendors.
>
> I have it working so that they can select several vendors, but how do
I
> get
> the report to return all vendors if the user enters nothing into the
> parameter?

I Don't know the database names but in your selection criteria, do
something
like:

(selVendor = 'ALL') or (selVendor = vendor.code)

Where selVendor is your prompting variable.

Mark W.






[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
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing
+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=P
da+database+software&w5=Database+management+software&w6=Database+marketing+s
oftware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software

Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software

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


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

Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software

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



_____

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!
<http://docs.yahoo.com/info/terms/> Terms of Service.



_____



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



I need a crystal report to allow the user to select some or all vendors.

I have it working so that they can select several vendors, but how do I get
the report to return all vendors if the user enters nothing into the
parameter?



Thanks,



Robert MacDonald

Information Technology Manager

Ground Effects Ltd.





[Non-text portions of this message have been removed]
Have you tried entering a star "*" wild card.

Shirley Graver
Rubber Associates Inc

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Robert MacDonald
Sent: Tuesday, October 18, 2005 11:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 6.1 Crystal Question - Some Vendors or All
Vendors

Hi All,



I need a crystal report to allow the user to select some or all vendors.

I have it working so that they can select several vendors, but how do I get
the report to return all vendors if the user enters nothing into the
parameter?



Thanks,



Robert MacDonald

Information Technology Manager

Ground Effects Ltd.





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

_____


Tracking #: FA780F5D6C2AE84A8F50775427DF426BBD72A146


[Non-text portions of this message have been removed]
> I need a crystal report to allow the user to select some or all vendors.
>
> I have it working so that they can select several vendors, but how do I
> get
> the report to return all vendors if the user enters nothing into the
> parameter?

I Don't know the database names but in your selection criteria, do something
like:

(selVendor = 'ALL') or (selVendor = vendor.code)

Where selVendor is your prompting variable.

Mark W.
Take a look at ths perhaps it will help

http://support.businessobjects.com/library/kbase/articles/c2005464.asp

Dan Shallbetter
States Electric Mfg.


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Tuesday, October 18, 2005 10:45 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 6.1 Crystal Question - Some Vendors or
All Vendors


> I need a crystal report to allow the user to select some or all
vendors.
>
> I have it working so that they can select several vendors, but how do
I
> get
> the report to return all vendors if the user enters nothing into the
> parameter?

I Don't know the database names but in your selection criteria, do
something
like:

(selVendor = 'ALL') or (selVendor = vendor.code)

Where selVendor is your prompting variable.

Mark W.






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