Default Date in Date parameter field

Last Post 02 Aug 2006 02:44 PM by rlperez. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
chandreshsoni
New Member
New Member

--
28 Jun 2006 11:32 PM
Hello SQL Reporting Service Expert

Reporting Service 2005 seems to be behaving strange. I have a DateTime parameter, EndDate which is nothing but the current date by default.

i want to set the current date as default in it.

In the Default-values, Non queried i choose =Today but when i run the report in preview i get to see that the field is disable and cannot enter anything or choose from the date icon next to it.

could anybody help.

/Soni
rlperez
New Member
New Member

--
02 Aug 2006 02:44 PM
Report Parameters:
Properties:
Name: Date (your variable)
Prompt: Enter Date
Data Type: DateTime

Default values:
non-queried =Globals!ExecutionTime

the key is in the default values, let me know if this helps...

-- Ralph Perez rlperez@WilburCurtis.com
RKronenwett
New Member
New Member

--
19 Dec 2006 11:52 AM
Hello,
Thanks this Tip was very Good for me Too.

But i have another Question?

I will set the Default Date from the Parameter 3 days in the Past !

Can anyone give me a Tip?

Thanks
nickd_SQL
New Member
New Member

--
26 Jan 2007 01:55 AM
use dateadd
You are not authorized to post a reply.

Acceptable Use Policy