Dynamics Community Forum Thread Details

SRSS drill through report opening in a new window/tab

I have a report that lists open invoices. I have another report which lists the content of an invoice. If I use the Actions>>Go to Report it passes the variable with out any problem, except it opens in the same browser window.

I read my only option was a URL that opens the report and passes the parameter. The report that I am drilling to is very simple and only has one parameter.

Below is what I am using. It opens the report in a new tab, but it does not pass the parameter.

="javascript:void(window.open('http://XXXXXX:XXXX/Reports/Pages/Report.aspx?ItemPath=%2fXXXXX%2fSales%2fInvoice+by+Invoice+Number&rs:Command=Render&DOCNUMB="+rtrim(Fields!DOCNUMBR.Value)+"'))"

If I copy the URL from the report it looks like

javascript:void(window.open('http://XXXXXX:XXXX/Reports/Pages/Report.aspx?ItemPath=%2fXXXXX%2fSales%2fInvoice+by+Invoice+Number&rs:Command=Render&DOCNUMB=442312'))

I also tried:

="javascript:void(window.open('http://XXXXXX:XXXX/Reports/Pages/Report.aspx?ItemPath=%2fXXXXX%2fSales%2fInvoice+by+Invoice+Number&rs:Command=Render&Parameters!DOCNUMB.Value="+rtrim(Fields!DOCNUMBR.Value)+"'))"

which produced:

javascript:void(window.open('http://XXXXXX:XXXX/Reports/Pages/Report.aspx?ItemPath=%2fXXXXX%2fSales%2fInvoice+by+Invoice+Number&rs:Command=Render&Parameters!DOCNUMB.Value=442313'))

Any thoughts on what I might be missing.

I also tried it without the rtrim and the results were the same, except the created URL had %2f for all the ending spaces after the invoice number.

thanks,

Rich