Joined: 20 Jun 2012
Location: India
Online Status: Offline
Posts: 9
Topic: Optional Parameter at SQL Command Level Posted: 03 Jul 2012 at 12:44am
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?
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 03 Jul 2012 at 3:35am
No, they cannot be optional. You could, however, set default values, check for those in the SQL of your command, and treat the default values as if nothing was selected for the parameter.
Joined: 20 Jun 2012
Location: India
Online Status: Offline
Posts: 9
Posted: 03 Jul 2012 at 5:50am
I did make a default value out of range (default as 1/1/1899). But in the input parameter screen i am getting "...." as one of the value along with the default date. could you please suggest how shall i get rid of the dots "...."(dots without codes)
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
IP Logged
