How to to add a default date time parameter for my SSRS parameter?

Question

Post reply

How to to add a default date time parameter for my SSRS parameter?

batchu.naresh

Old Hand

Points: 377
More actions
November 14, 2013 at 4:46 pm

#286247

I am trying to add a default date time parameter to my SSRS parameter. 1. The condition is to date parameter should be defaulted to 01/01/YYYY 12:00:00 AM (YYYY is current year). 2. The condition is from date parameter should be defaulted to 12/31/YYYY 11:59:00 PM (YYYY is current year).
I have tried cdate,dateformat,FormatDateTime nothing worked(apparently I am making some sort of mistake).
This for AX
Some of the things I tried =CDate(Format("01/01/year(today())") & " 12:00 AM")
=Format(Parameters!MyParameter.Value, "01/01/2013 12:00") (I know it works for only one year but for now atleast)
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 1

You haven't said what is happening when you try those things...???

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

batchu.naresh Old Hand Points: 377 More actions · Answer 2

sorry!

First expression did pass the build -I am unable to find syntax error,

Second one simply returns date and time is set to some thing (06:00 pm)

mister.magoo SSC-Forever Points: 47174 More actions · Answer 3

Try this for 1st of Jan this year:

=DateSerial(Year(Today),1,1)

and for the end of the year, take the start of next year and subtract one second

=DateAdd(DateInterval.Second,-1, DateSerial(Year(Today)+1,1,1))

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

batchu.naresh Old Hand Points: 377 More actions · Answer 4

Thanks for your reply

for the end date I am seeing an error "Unbound Invalid expression for Property value.Second is Invalid".As per my understanding SSRS is not recognising "Dateinterval.second".I have same problem with an expression I previously tried (=DateSerial(DatePart(DateInterval.Year, Today()), 12, 31)).Is there an aleternative for dateinterval.second? I tried second(now()) which is giving the same error.

mister.magoo SSC-Forever Points: 47174 More actions · Answer 5

The alternative for DateInterval.Second is simply the string "s"

=DateAdd("s",-1, DateSerial(Year(Today)+1,1,1))

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);