Crystal Reports checkbox paramter???

Report Design
Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design

Topic: checkbox paramter???

Author	Message
jbalbo Senior Member Joined: 17 Feb 2011 Online Status: Offline Posts: 219	Topic: checkbox paramter??? 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
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	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 www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

jkwrpc Senior Member Joined: 19 Jun 2007 Location: United States Online Status: Offline Posts: 432	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. Edited by jkwrpc - 24 Jul 2012 at 8:50am
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.016 seconds.