Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Checkbox in Crystal 1

Status
Not open for further replies.

sds786

Programmer
Aug 15, 2007
49
US
Hi,
I am using Crystal 11.5 with Oracle 10 G/Universe, I have designed an electronic evaluation form in Crystal, all of the information are filling through database but there are some questions containing checkbox and I need to fill/tick mark by the user on line, is there anyway I can do in crystal that user can do in preview mode?

Thanks.
 
Could you explain a little more clearly please?

If you want to display checkboxes based on any particular value (field values / params etc.) then you can simply by using the relevant fonts.

Wingdings is a good example of a standard font available - symbols 111,253 & 254 in the wingdings fonts show 'Empty checkbox',Checkbox with cross & Checkbox with tick - respectively.

If you want the user to interact with the report to then lead to the checkboxes then simply create suitable parameters and then insert a formula in the report to display based on the input.

If you are meaning something else then please explain using as much detail and examples as possible.

'J
 
Crystal has never been able to write to a database (i.e. your 'check a box') it can only read from an existing database.

DataDog [pc2]
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?
 
Thanks guys for the response, currently I am using the formula logic which you mentioned, and I tried chr(111), chr(253)chr(254) but none of them gave me checkbox, please verify that.
Secondly I tried to solve my problem with creating a parameter (with multiple value selection) having list of values in drop down list (i.e. 1. Renter, 2. Owner, 3. Domestic, etc.) but I when I drag this parameter in my report it gives me only first values '1.Renter', I will appreciate if you tell me how can I get all three (or my selected list) in my report? Thanks
 
O.K. So let's say we can give you a solution to get 3 check boxes with the renter, Owner, and Domestic on the report. What are you going to DO with that data? You are trying to use Crystal as a data entry tool, Correct? Crystal doesn't do that, never has. You can do that type of thing with Access, ASP, etc, but not Crystal.

DataDog [pc2]
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?
 
chr(253) will give you an x in a box, and chr(254) will give you a check mark--if you format the formula to wingdings. Empty box is chr(168).

On the parameter display issue, use a formula:

join({?Parm},", ")

-LB
 
Thanks Guys, I appreciate your response.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top