More Mulitvalue parameter issues...

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

Monitoring Database hits

In any asp.net application, whats the simplest way to monitor how many times a page hits the database (opens and closes a connection)?

JontyMC:

In any asp.net application, whats the simplest way to monitor how many times a page hits the database (opens and closes a connection)?

If you are using a data access layer, you can write some code to log when the data is connection/executed. You can log this to a text file, or a database, or any other external data source.