Print Page | Close Window

checkbox paramter???

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17029
Printed Date: 01 May 2024 at 6:10pm


Topic: checkbox paramter???
Posted By: jbalbo
Subject: checkbox paramter???
Date Posted: 13 Jul 2012 at 9:43am
Hi,
 
I wanted to setupa parameter as a checkbox .
 
if I can do that i wanted to filter a {date field} to see if it contained a date
 
example:
 
parameter NotesDate(is checked)
then the formula would be {tablefield_fornotesdate} is notnull
 
parameter NotesDate(is not checked)
then the formula would be {tablefield_fornotesdate} is null
 
hope is a little clear
 


Replies:
Posted By: hilfy
Date Posted: 23 Jul 2012 at 5:37am
You can't do a checkbox, but you can do a drop-down list where the values are Yes and No.  The formula would then look like this:
 
If {?NotesDate}='Yes' then not IsNull(tablefield_fornotesdate)
else IsNull(tableField_fornotesdate)
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: jkwrpc
Date Posted: 24 Jul 2012 at 8:48am
You should be able to use the checkbox in .Net. However, you will want to treat the checkbox as boolean, and not 'notnull  or isnull' Rather checked = true, unchecked = false. Then use that boolean logic result  in your selection statement.
 
 


Print Page | Close Window