BAQ Report Designer - And setting boolean option fields

system · January 25, 2011, 3:06pm

You can customise the Screen and place a combobox for the character01 field
instead of a edit field and set the options that the user can select from.

On Fri, Jan 21, 2011 at 1:56 PM, Adele <arbjorklund@...> wrote:

>
>
> I have this figured out and will post it here so others can use it, if
> needed. It works great, with the exception of letting the users know what is
> ok for the field...
>
> I set up a record selection formula in Select Expert in Crystal Reports as:
>
> if {BAQReportParameter.Character01} = 'ALL' Then
> {BAQReportResult.HDCase.WFComplete} in [True, False] else
> if {BAQReportParameter.Character01} = 'True' Then
> {BAQReportResult.HDCase.WFComplete} = True else
> if {BAQReportParameter.Character01} = 'False' then
> {BAQReportResult.HDCase.WFComplete} = False
>
>
> --- In vantage@yahoogroups.com <vantage%40yahoogroups.com>, "Adele"
> <arbjorklund@...> wrote:
> >
> > Is There a way to let Boolean option fields allow True, False or ALL as
> choices? The fields to not appear on the list to setup as filters. I'm
> trying to use hdcase.wfcompelete.
> >
> > Thanks
> >
>
>
>

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

system · January 21, 2011, 10:19am

Is There a way to let Boolean option fields allow True, False or ALL as choices? The fields to not appear on the list to setup as filters. I'm trying to use hdcase.wfcompelete.

Thanks

system · January 21, 2011, 11:22am

Boolean has two values only.... True or False, if you want more use a
Character field.

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*

On Fri, Jan 21, 2011 at 10:17 AM, Adele <arbjorklund@...> wrote:

>
>
> Is There a way to let Boolean option fields allow True, False or ALL as
> choices? The fields to not appear on the list to setup as filters. I'm
> trying to use hdcase.wfcompelete.
>
> Thanks
>
>
>

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

system · January 21, 2011, 11:45am

So, are you saying I would need to use the reportparameter field character01.. but than how do I use that to filter the data, so it only pulls based on what they enter or choose, (tie it back to the hdcase.complete field)?

It's funny because when I don't click the box, I get all. If I do click it than I get those that are true.. No way to get the false ones only.

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Boolean has two values only.... True or False, if you want more use a
> Character field.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Fri, Jan 21, 2011 at 10:17 AM, Adele <arbjorklund@...> wrote:
>
> >
> >
> > Is There a way to let Boolean option fields allow True, False or ALL as
> > choices? The fields to not appear on the list to setup as filters. I'm
> > trying to use hdcase.wfcompelete.
> >
> > Thanks
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>

system · January 21, 2011, 11:53am

You'll probably have to filter it in Crystal based on the character01 field. I've had this battle in the past and didn't think of this solution, I like it. Basically you'll dump the entire data set, but based on how your character01 is set you'll tell Crystal to suppress different data.

Ken

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Adele
Sent: Friday, January 21, 2011 9:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ Report Designer - And setting boolean option fields - Email found in subject

So, are you saying I would need to use the reportparameter field character01.. but than how do I use that to filter the data, so it only pulls based on what they enter or choose, (tie it back to the hdcase.complete field)?

It's funny because when I don't click the box, I get all. If I do click it than I get those that are true.. No way to get the false ones only.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Jose Gomez <jose@...> wrote:
>
> Boolean has two values only.... True or False, if you want more use a
> Character field.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Fri, Jan 21, 2011 at 10:17 AM, Adele <arbjorklund@...> wrote:
>
> >
> >
> > Is There a way to let Boolean option fields allow True, False or ALL as
> > choices? The fields to not appear on the list to setup as filters. I'm
> > trying to use hdcase.wfcompelete.
> >
> > Thanks
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>

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

system · January 21, 2011, 11:59am

Do you know how to use the list option when setting up the character01. I would like for them to choose not have to key in the choice? I can surely do the setup in crystal to decide what to do based on what is sent over.

Thanks

--- In vantage@yahoogroups.com, Ken Williams <kwilliams@...> wrote:
>
> You'll probably have to filter it in Crystal based on the character01 field. I've had this battle in the past and didn't think of this solution, I like it. Basically you'll dump the entire data set, but based on how your character01 is set you'll tell Crystal to suppress different data.
>
> Ken
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Adele
> Sent: Friday, January 21, 2011 9:45 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAQ Report Designer - And setting boolean option fields - Email found in subject
>
>
>
> So, are you saying I would need to use the reportparameter field character01.. but than how do I use that to filter the data, so it only pulls based on what they enter or choose, (tie it back to the hdcase.complete field)?
>
> It's funny because when I don't click the box, I get all. If I do click it than I get those that are true.. No way to get the false ones only.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Jose Gomez <jose@> wrote:
> >
> > Boolean has two values only.... True or False, if you want more use a
> > Character field.
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *T: 904.469.1524 mobile
> > E: jose@
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> >
> > On Fri, Jan 21, 2011 at 10:17 AM, Adele <arbjorklund@> wrote:
> >
> > >
> > >
> > > Is There a way to let Boolean option fields allow True, False or ALL as
> > > choices? The fields to not appear on the list to setup as filters. I'm
> > > trying to use hdcase.wfcompelete.
> > >
> > > Thanks
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>

system · January 21, 2011, 12:56pm

I got the true and false to work by filtering in Crystal but cannot get the ALL to work. Any ideas? And to make it harder, I have subreports on the report. So the main report works but the subreports do not.

I'm new to using vantage.. so it's a bit different than original crystal would be. I can not compare my data to the field I'm passing across directly.

--- In vantage@yahoogroups.com, Ken Williams <kwilliams@...> wrote:
>
> You'll probably have to filter it in Crystal based on the character01 field. I've had this battle in the past and didn't think of this solution, I like it. Basically you'll dump the entire data set, but based on how your character01 is set you'll tell Crystal to suppress different data.
>
> Ken
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Adele
> Sent: Friday, January 21, 2011 9:45 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAQ Report Designer - And setting boolean option fields - Email found in subject
>
>
>
> So, are you saying I would need to use the reportparameter field character01.. but than how do I use that to filter the data, so it only pulls based on what they enter or choose, (tie it back to the hdcase.complete field)?
>
> It's funny because when I don't click the box, I get all. If I do click it than I get those that are true.. No way to get the false ones only.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Jose Gomez <jose@> wrote:
> >
> > Boolean has two values only.... True or False, if you want more use a
> > Character field.
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *T: 904.469.1524 mobile
> > E: jose@
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> >
> > On Fri, Jan 21, 2011 at 10:17 AM, Adele <arbjorklund@> wrote:
> >
> > >
> > >
> > > Is There a way to let Boolean option fields allow True, False or ALL as
> > > choices? The fields to not appear on the list to setup as filters. I'm
> > > trying to use hdcase.wfcompelete.
> > >
> > > Thanks
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>

system · January 21, 2011, 1:56pm

I have this figured out and will post it here so others can use it, if needed. It works great, with the exception of letting the users know what is ok for the field...

I set up a record selection formula in Select Expert in Crystal Reports as:

if {BAQReportParameter.Character01} = 'ALL' Then {BAQReportResult.HDCase.WFComplete} in [True, False] else
if {BAQReportParameter.Character01} = 'True' Then {BAQReportResult.HDCase.WFComplete} = True else
if {BAQReportParameter.Character01} = 'False' then {BAQReportResult.HDCase.WFComplete} = False

--- In vantage@yahoogroups.com, "Adele" <arbjorklund@...> wrote:
>
> Is There a way to let Boolean option fields allow True, False or ALL as choices? The fields to not appear on the list to setup as filters. I'm trying to use hdcase.wfcompelete.
>
> Thanks
>