View Complete Post
MSDN Magazine March 2001
I have an SSRS report. I created it using BIDS and it uses a Sql Server Analysis Service data source. The data source query is an MDX query with one parameter: @region, a default value has been set for this parameter. The value which @region takes looks like [USA].[Northeast].[New Hampshire].[Coos County].
The MDX query goes like this:
This report runs properly inside BIDS or through web browser after deployment. In my report manager at http://localhost/Reports, I am able to view this report by selecting the value for the @region parameter from a dropdownlist, which contains such values as
Coos CountyCheshire CountySullivan CountyStrafford County... ...
I know that we can pass query parameters to SSRS through the URL. I have successfully done so with relational database which uses regular SQL. But, I have not succeeded in passing this @region parameter of my MDX query through the URL.
I tried the following:
I have a complex customized list and I need to pass parameters of two fields so that when the 'Questionnaire' is completed and subsequentially opened after initial submission, it will retrieve the Number and GUID automatically in respective
ANY HELP is APPRECIATED!!
getQuerystring('CustodianGUID', 'ctl00_m_g_d08916d8_7224_4665_be72_2de381f45985_ff46_1'); ///replace
customerGUID and form field name
'ctl00_m_g_d08916d8_7224_4665_be72_2de381f45985_FormField11_ctl00_ctl00_TextField'); ///replace customerGUID
and form field name
function getQuerystring(key, field)
key = key.replace(/[\/,"\\\[").replace(/[\]]/,"\\\]");
var regex = new RegExp("[\\?&]"+key+"=([^&#]*)");
var qs = regex.exec(window.location.href);
document.getElementById(field).value = qs;