Go to URL Assistance Requested
I have a report deployed on a server at
http: // okcrptprd/Reports/Pages/Report.aspx?ItemPath=%2fwv_Drilling%2fwv_DailyReport
The report parameters are WellID ((text) and ReportDate (text)
I would like to launch this report in a new window when a user clicks on a link from another report.
I have tried the following expression on the Action setting of the textbox properties:
=
"javascript:void(window.open('http://okcrptdev/ReportServer/Pages/ReportViewer.aspx?%2fwv_Drilling%2fwv_DailyReport&rs:Command=Render"
& "&WellID="&Fields!WELL_NUMBER.Value &
"&ReportDate="& formatdatetime(Fields!REPORT_DATE.Value,2) &
"','_blank))"
What happens is that the report opens in new window. the WellID parameter is correctly populated, but the ReportDate parameter
is not.
For the report to launch, here are the properties of the ReportDate parameter:
Available values: Get values from a query
Default value: No default value
Can anyone assist with the proper formatting to get this report to launch correctly?
April 15th, 2011 5:21pm
Hello,
I think it depends on your regional settings for the date time format, see
MSDN: Setting the Report Language Parameter in a URL. You eigher have to format the date time string to mm/dd/yyyy or you have to pass the language / format.Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich tglich
Blog
Xing
Free Windows Admin Tool Kit Click here and download it now
April 16th, 2011 10:24am
Why do you have the available values set to values from a query? Is it possible you are passing it a date that doesnt match one from the query that is being used as available values?
April 17th, 2011 6:18pm
Hi MrMNew,
As ClareMoore posted, since you have specified available values for the ReportDate parameter, first please make sure the date value passed through URL matches one available value
from query.
Besides that, I also noticed the type of the ReportDate parameter is Text. So, we also need ensure the format of the ReportDate parameter value matches the date format of available
values. Since you are using the FormatDateTime function to convert the REPORT_DATE field to short date, the output ReportDate value depends on the regional settings as Olaf posted.
Thanks,
Tony Chain
Tony Chain [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
April 18th, 2011 3:10am