Passing Parameter Values via URL

Apr 13, 2013 at 3:17 PM
Great application you have here!

Do you plan to support the ability to accept parameter values via URL? I have a lot of reports that drill through to a new browser window using the javascript:void(window.open()) URL technique. It would be great if I could support this functionality using CrissCross.

Thanks!
Coordinator
Apr 13, 2013 at 3:39 PM
Thanks!

SSRS has an official way of implementing DrillThrough reports - see http://technet.microsoft.com/en-us/library/dd207031%28v=sql.105%29.aspx

If you do it that way, then it will work with CrissCross because the ReportViewer component deals with it (it will just reload the ReportViewer without changing the rest of the CrissCross page)

You can also pass parameters via the URL in CrissCross, but it takes a bit more work than standard SSRS. The basic URL structure is:

crisscross/Report.aspx?path=<path>&parameters=<params>

Where <path> is the path to the report, e.g. /MyFolder/Another Folder/MyReport

and <params> is a string in the traditional SSRS parameter format of:

<paramname>=<value>&<paramname>=<value> ...
e.g.
someparam=1&someotherparam=2

BUT you have to URL Encode both of those - e.g. convert the & to %26, the = to %3d and the / to %2f and so on - so the final URL will look something like this:

crisscross/Report.aspx?path=%2fMyFolder%2fAnother+Folder%2fMyReport&parameters=someparam%3d1%26someotherparam%3d2

If you turn on crisscross.UseReportHistory in the web.config (see https://crisscross.codeplex.com/wikipage?title=web.config setting ) then you will see this sort of URL in action on the 'Recently Run' page in CrissCross

Hope that helps
Apr 13, 2013 at 3:52 PM
The URL structure is exactly what I was looking for. You might consider adding that to the documentation.

Thanks!