Dynamics Community Forum Thread Details

Navigation List - URL problem on action - long question!

All. I built a simple navigation list that displays SOP Header data [just the SOP10100 table]. I then added an action to this list to open an SSRS report.

This SSRS report has two parameters on it for Sop Number [@SOPNO] and SOP Type [@SOPTYPE].

So...I therefore added two parameters to the Navigation List Action for these.

All good so far. Saved the navigation list and went to test. Navigation list runs and displays the header data....I select the Actions button and the link to the SSRS action is there. I click the action and a web browser opens. All good so far. But then there is an error.

Now, the issue is...the URL that is rendered by the navigation List Action includes a '?' after the report name which causes the report rendering to fail. If I just replace this '?' with an '&' in the web browser...the report runs fine. Parameters are automatically entered and the correct filled report returned.

Bad URL sent by Navigation List Builder:

http://SERVERNAME/ReportServer/Pages/ReportViewer.aspx?/FOLDER/Sales/SOPReport?SOPNO=12345&SOPTYPE=3.

[see the '?' after 'SOPReport'?]

When this opens in a web page, it errors out, but if I replace the '?' with an '&'...in the browser, all works fine. The URL entered in the Navigation List action is everything up and including SOPReport and that's it [i.e. there is no' ?']

Anyone come across this before? How would I get the Navigation List Action to stop including the '?'

Ian.

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)