Boolean Parameter Feild

[KL_Hutchmfg]

Hello All,

I work in a program that only registers certain parameter fields when running the report through that program.
I am trying to create a true of false dropdown parameter that will read true of false based on if a box is checked. Can anyone help me?

Here is the prompt text I have entered so far:

Production Complete?;True|jmpProductionComplete=<1;False|jmpProductionComplete=0

 

[lbass]

Are you trying to code this within Crystal Reports?

How is the checkbox created?

You can try the following. First create a Boolean parameter {?ProductionComplete} with options true and false.
Then use a selection formula like this if your report contains a field {table.ProductionComplete} that either displays ASCII character 254 (checked box) or 168 (unchecked box):

(
(
{?ProductionComplete}=true and
{table.ProductionComplete}=chr(254)
) or
(
{?ProductionComplete}=false and
{table.ProductionComplete}=chr(168)
)
)

Whether this works really depends upon how the ProductionComplete field was created. If it makes use of ASCII characters, there also different versions of this, e.g., using an "x" for example.

If you are unsure what character was used, you can create a separate report with a formula like this:

chr(recordnumber)

Limit the report to something less than 1000 records, format the formula field to the Wingding font, and then run it an observe the characters that appear. Add recordnumber to the report so you can see which number to plug into chr().

-LB

 

[KL_Hutchmfg]

Hello,

I realized that the field doesn't hold any data to check to but rather goes through 6 other places to determine if the box should be checked.

The above that I posted is a parameter needed for the program that we use to run the report and I have the options to select None, True, or False by using.

Production Complete?;None;True|jmpProductionComplete=1;False|jmpProductionComplete=0


What I am struggling with is how to create a check box that will cross reference these other 6 areas to generate a checkbox so the parameter will know if the box is not filled that it will not pull in the report. I've attached the other areas that it references to in the analysis in the system.

I hope that makes sense. I am very new to both crystal reporting and to ECI M1 that is used for their reporting functions.

 

[lbass]

Sorry—I don’t think I can help, as I’m not familiar with the way you are programming this. Maybe someone else will jump in. I do think you will need to explain the underlying fields involved rather than just showing a display of the check-off fields though.

-LB

 

[KL_Hutchmfg]

That's okay! Thanks for your help. What I sent is a snapshot of the underlying fields that it is reading from in order to fill the check box in the production complete field that shows on the report.
If I was to try and create a "And, If" formula to register those 6 fields as true or false, would you know how to formulate that?

 

[lbass]

What are the fields that correspond to “Description”, “Sequence”, and “Custom?”?
Are the descriptions all instances of one field? Are these all from the same table?
Can users check just one or multiple boxes? What is the code used to generate a checked box vs an unchecked box?

I actually already did this in the formula above...

-LB