I have a URL action on a report item that opens a new window to a different
report (using a piece of javascript). I need to pass the selected multivalue
parameter from the first report to this other report. But I cant figure out
how to pass the multivalue paramaters in the url, I have tried just
Parameters!Region.Value and also split(Parameters!Region.Value,", ") and
join(Parameters!Region.Value,", ") but none of them work.
the url actions is...
="javascript:void(window.open('http://server/Reportserver2005?/Report1®ion="
& Parameters!Region.Value &
rs:Command=Render&rs:ClearSession=true&rc:Parameters=false','_blank','location=no,resizable,toolbar=yes,left=200,top=60,height=590,width=760'))"
Any ideas?I haven't done this and don't have a sample, but just for S&G (S and
giggles), try using the encoded equivalent of the "," to join the values...
Call it a SWAG.
"NH" <NH@.discussions.microsoft.com> wrote in message
news:D3528E3E-CF89-4EEB-BA9E-DA8C88A3066B@.microsoft.com...
>I have a URL action on a report item that opens a new window to a different
> report (using a piece of javascript). I need to pass the selected
> multivalue
> parameter from the first report to this other report. But I cant figure
> out
> how to pass the multivalue paramaters in the url, I have tried just
> Parameters!Region.Value and also split(Parameters!Region.Value,", ") and
> join(Parameters!Region.Value,", ") but none of them work.
> the url actions is...
> ="javascript:void(window.open('http://server/Reportserver2005?/Report1®ion="
> & Parameters!Region.Value &
> rs:Command=Render&rs:ClearSession=true&rc:Parameters=false','_blank','location=no,resizable,toolbar=yes,left=200,top=60,height=590,width=760'))"
> Any ideas?sql
Showing posts with label item. Show all posts
Showing posts with label item. Show all posts
Friday, March 30, 2012
Friday, March 9, 2012
Monitor the daily performance report of SQL 2000.
What are the most necessary item to be checked to monitor
the daily performance report of SQL 2000.
Any list of system Stored procedure? Any list of tables.
If so please specify.
Thanks in advane.
AnandThanks for your reply.
>--Original Message--
>Anand,
>the first (and best) place to start looking is
>http://www.sql-server-performance.com
>--
>I hope this helps
>regards
>Greg O MCSD
>SQL Scribe Documentation Builder
>Document any SQL server database in minutes
>Programmers love it, DBA dream of it
>AGS SQL Scribe download a 30 day trial today
>http://www.ag-software.com/ags_scribe_index.asp
>
>"gurus" <gurusanand@.yahoo.com> wrote in message
>news:065201c35199$1ca11230$a501280a@.phx.gbl...
>> What are the most necessary item to be checked to
monitor
>> the daily performance report of SQL 2000.
>> Any list of system Stored procedure? Any list of tables.
>> If so please specify.
>> Thanks in advane.
>> Anand
>
>.
>
the daily performance report of SQL 2000.
Any list of system Stored procedure? Any list of tables.
If so please specify.
Thanks in advane.
AnandThanks for your reply.
>--Original Message--
>Anand,
>the first (and best) place to start looking is
>http://www.sql-server-performance.com
>--
>I hope this helps
>regards
>Greg O MCSD
>SQL Scribe Documentation Builder
>Document any SQL server database in minutes
>Programmers love it, DBA dream of it
>AGS SQL Scribe download a 30 day trial today
>http://www.ag-software.com/ags_scribe_index.asp
>
>"gurus" <gurusanand@.yahoo.com> wrote in message
>news:065201c35199$1ca11230$a501280a@.phx.gbl...
>> What are the most necessary item to be checked to
monitor
>> the daily performance report of SQL 2000.
>> Any list of system Stored procedure? Any list of tables.
>> If so please specify.
>> Thanks in advane.
>> Anand
>
>.
>
Subscribe to:
Posts (Atom)