Crystal Reports Selection Expert

RESOLVED:

I removed the link of Customer.Company -> QuoteDtl.Company and replaced with Customer.CustNum -> QuoteDtl.CustNum.

My formula that works is below:

if {?CustID} = "*"
then
{QuoteHed.DateQuoted} = {?My Parameter}
else
{QuoteHed.DateQuoted} = {?My Parameter} and
{Customer.CustID} = {?CustID}

Thanks.

--sf

--- In vantage@yahoogroups.com, "Linda Lowney" <llowney@...> wrote:
>
> What is your selection formula?
>
>
>
> Linda
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of sanfranc415
> Sent: Tuesday, May 18, 2010 11:52 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Reports Selection Expert.
>
>
>
>
>
> OK. For some reason when I use the above formula, my selection doesn't include the date selection, it simply selects all the records from the quote table.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Linda Lowney" <llowney@> wrote:
> >
> > I have one where the parameter is “SelectCustId.” If the user leaves it blank then it prints all customers. I created a formula called “bSelectedCustId” as follows:
> >
> >
> >
> > if {?SelectCustId} = "" or {?SelectCustId} = {Customer.CustID} then
> >
> > true
> >
> > else
> >
> > false
> >
> > ;
> >
> >
> >
> > Then in the selection formula I have:
> >
> >
> >
> > {OrderRel.Company} = “xxxx” and {@bSelectedCustId} = true
> >
> >
> >
> > Hth,
> >
> > Linda
> >
> >
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of sanfranc415
> > Sent: Monday, May 17, 2010 5:29 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Crystal Reports Selection Expert.
> >
> >
> >
> >
> >
> > I'm trying to suppress/hide a Selection Expert Parameter.
> >
> > Currently, I have a parameter that prompts the user for the CustID. The user would like to have the option to either enter the CustID or leave it blank, which leaving it blank would generate the report with all CustID.
> >
> > Thanks,
> >
> > --sf
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I'm trying to suppress/hide a Selection Expert Parameter.

Currently, I have a parameter that prompts the user for the CustID. The user would like to have the option to either enter the CustID or leave it blank, which leaving it blank would generate the report with all CustID.

Thanks,

--sf
I have one where the parameter is “SelectCustId.” If the user leaves it blank then it prints all customers. I created a formula called “bSelectedCustId” as follows:



if {?SelectCustId} = "" or {?SelectCustId} = {Customer.CustID} then

true

else

false

;



Then in the selection formula I have:



{OrderRel.Company} = “xxxx” and {@bSelectedCustId} = true



Hth,

Linda





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of sanfranc415
Sent: Monday, May 17, 2010 5:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Selection Expert.





I'm trying to suppress/hide a Selection Expert Parameter.

Currently, I have a parameter that prompts the user for the CustID. The user would like to have the option to either enter the CustID or leave it blank, which leaving it blank would generate the report with all CustID.

Thanks,

--sf





[Non-text portions of this message have been removed]
OK. For some reason when I use the above formula, my selection doesn't include the date selection, it simply selects all the records from the quote table.

--- In vantage@yahoogroups.com, "Linda Lowney" <llowney@...> wrote:
>
> I have one where the parameter is “SelectCustId.” If the user leaves it blank then it prints all customers. I created a formula called “bSelectedCustId” as follows:
>
>
>
> if {?SelectCustId} = "" or {?SelectCustId} = {Customer.CustID} then
>
> true
>
> else
>
> false
>
> ;
>
>
>
> Then in the selection formula I have:
>
>
>
> {OrderRel.Company} = “xxxx” and {@bSelectedCustId} = true
>
>
>
> Hth,
>
> Linda
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of sanfranc415
> Sent: Monday, May 17, 2010 5:29 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Reports Selection Expert.
>
>
>
>
>
> I'm trying to suppress/hide a Selection Expert Parameter.
>
> Currently, I have a parameter that prompts the user for the CustID. The user would like to have the option to either enter the CustID or leave it blank, which leaving it blank would generate the report with all CustID.
>
> Thanks,
>
> --sf
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
What is your selection formula?



Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of sanfranc415
Sent: Tuesday, May 18, 2010 11:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Reports Selection Expert.





OK. For some reason when I use the above formula, my selection doesn't include the date selection, it simply selects all the records from the quote table.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Linda Lowney" <llowney@...> wrote:
>
> I have one where the parameter is “SelectCustId.” If the user leaves it blank then it prints all customers. I created a formula called “bSelectedCustId” as follows:
>
>
>
> if {?SelectCustId} = "" or {?SelectCustId} = {Customer.CustID} then
>
> true
>
> else
>
> false
>
> ;
>
>
>
> Then in the selection formula I have:
>
>
>
> {OrderRel.Company} = “xxxx” and {@bSelectedCustId} = true
>
>
>
> Hth,
>
> Linda
>
>
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of sanfranc415
> Sent: Monday, May 17, 2010 5:29 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Crystal Reports Selection Expert.
>
>
>
>
>
> I'm trying to suppress/hide a Selection Expert Parameter.
>
> Currently, I have a parameter that prompts the user for the CustID. The user would like to have the option to either enter the CustID or leave it blank, which leaving it blank would generate the report with all CustID.
>
> Thanks,
>
> --sf
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





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