Calendar Date parameter in SSRS Jump To URL

Question

Calendar Date parameter in SSRS Jump To URL

var05

Hall of Fame

Points: 3011
More actions
November 15, 2012 at 6:37 am

#284845

Hi All,
Can we pass the Paramater that is set as Calendar date to be passed from one report to another using Jump to URL????
I have 2 reports....and I wanted to pass the selected calendar dates via Jump to Url option to the 2nd report...
Any help Pls!!
Thanks

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Gazareth One Orange Chip Points: 27737 More actions · Answer 1

Is this any help? I assume you're generating the URL through an expression. Not sure on what format the date would be expected in though.

http://msdn.microsoft.com/en-us/library/ms155391(v=sql.105).aspx

(I'm also assuming that Jump to Report isn't an option)

Cheers

gomathilakshmi.kaliaperumal 57004 Newbie Points: 6 More actions · Answer 2

Usually the date value is passed in something like below.

http://server/ReportServer?/dir/Report Name&rs:Command=Render&StartDt=2012-11-01&EndDt=2012-11-10

or

http://server/ReportServer?/dir/Report Name&rs:Command=Render&StartDt=2012/11/01&EndDt=2012/11/10

Since you are using a parameter just pass in the parmetername.

var05 Hall of Fame Points: 3011 More actions · Answer 3

Thank u both!!

I am able to pass the date paramater if the data type of the date parameter is set to Text.

But my start and end date paramaters are Calendar control i.e I set the paramater as Date/Time and user selects the date via the calendar control. If I set it this way, and as I generate the report, the hyperlink which navigates to another report is inactive. I am not able to click on the hyper link at all to drill down to the second report.

="http://servername/ReportServer/Pages/ReportViewer.aspx?/test/test/report2&rs:Command=Render&Date=" & join(Parameters!Date.Value,"&Date=" )

The above link works if the data type of Date parameter is text but not when it is date/time...Any help on this???

Gazareth One Orange Chip Points: 27737 More actions · Answer 4

I suspect the expression's not generating the date in the right format - you might need to play with that a bit to get it working in date datatype.

var05 Hall of Fame Points: 3011 More actions · Answer 5

I suppose date/time data type is not creating any problem...If I use date/time data type and select allow multiple values, the date paramater is being passed ...

But only if I uncheck Allow Multiple Value, the calendar control prompt pops out, and only by that time the label with Jump to url is not active... Not sure why this happens...

Any help?

Gazareth One Orange Chip Points: 27737 More actions · Answer 6

Sorry, not quite sure what you're describing there.

Is the Date parameter a multi-valued parameter in the target report?

var05 Hall of Fame Points: 3011 More actions · Answer 7

Thanks for your reply..

I had some mistakes with the hyper link which I had used... After corrrecting it, things look fine..

Thanks all for your help!

Gazareth One Orange Chip Points: 27737 More actions · Answer 8

Gazareth

One Orange Chip

Points: 27737

November 19, 2012 at 4:30 am

#1560274

No problem, good to hear it's working.