Crystal Reports Optional Parameter in SQL Level

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Optional Parameter in SQL Level

Post Reply

Post New Topic

Author	Message
KevinKD Newbie Joined: 20 Jun 2012 Location: India Online Status: Offline Posts: 9	Topic: Optional Parameter in SQL Level Posted: 02 Jul 2012 at 9:16pm
	I have three parameters in my report ?StratDate, ?EndDate ?Department. These three parameters are in SQL Command level; Not in Report level. So can i make them optional? if Yes, could you please tell me how to do it?
	IP Logged


itsarun.sunny Newbie Joined: 02 Jul 2012 Location: India Online Status: Offline Posts: 2	Posted: 03 Jul 2012 at 12:05am
	why dont you set parameters as null in sql when declaring
	IP Logged

KevinKD Newbie Joined: 20 Jun 2012 Location: India Online Status: Offline Posts: 9	Posted: 03 Jul 2012 at 12:10am
	I m pretty new to the Crystal. Coiuld you please help me understand. Coudl you please elaborate on your answer to make me understand
	IP Logged

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