Create Link to Report and setting parameters

(0) Share

Report

Posted on by Community Member

Hi,

I have no problems making links that will open views in Dynamics and setting filters. However, I have no luck doing the same with reports.

Is there a way to open the report window below and set the End Date and the Customer No. through a link?

Opening the window is easy enough using the link <omitted part>/runreport?report=50064

But I have not yet succeded in setting values for the filters etc.

Any help will be much appreciated!

7384.report.jpg

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Hannes Holst 5,767 on at

Like (0)

Report

Hi,

I don't think that's possible. When adding the filter-parameters from a Page-Link, NAV shows the error "RunReport action has extra unknown parameters."

To sail around the problem, I would give it try by creating a new Page which would call the report with the filters of the page. And then just call the new Page with the desired filters.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks, but adding anything to Dynamics is out of the question. Was hoping to be able to do this on the report mentioned as well as other reports.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (1)

Report

Check this link for setting filters https://docs.microsoft.com/en-us/dynamics-nav/how-to--run-reports if that parameter is not of the dataItem then you cannot set the value can set the value for the dataItem and then use that value to set the filter on your variables during OnInit report trigger.

Was this reply helpful? Yes No
Hannes Holst 5,767 on at

Like (0)

Report

[quote user="Suresh Kulla"]

Check this link for setting filters https://docs.microsoft.com/en-us/dynamics-nav/how-to--run-reports if that parameter is not of the dataItem then you cannot set the value can set the value for the dataItem and then use that value to set the filter on your variables during OnInit report trigger.

[/quote]

Hehe, it is possible. :-)

Was this reply helpful? Yes No