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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics