Adding a copy report to the action ribbon

(0) Share

Report

Posted on by Community Member

Hello

I want to make a new report similar to an existing report and make it accessible via a button on the sale order page. I saved the original report with a new name and ID number. I then created a new button on a page to call this report.

My problem is that when NAV tries to load this new report it takes a long time and then eventually fails to display any of the variables. I think this is an issue with how I'm defining the action because I wasn't able to replicate the action that calls the original report.

My question is how do you properly assign a new report to a button in NAV?

Let me know if more information is needed to answer the question.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Community Member on at

Like (0)

Report

I've discovered that the way I've been assigning reports to action buttons causes the system to run out of memory.

What I did was open page actions for the page I wanted to modify and set the RunObject property to the report I wanted to run. I noticed the default report actions left this field undefined but I don't know how they specify which report to open.

Was this reply helpful? Yes No
spyroot 1,647 on at

Like (1)

Report

Hi there,

Are you using any special filters on report?

Try to use the option "RunObject" from the properties of the action.

ex:

Was this reply helpful? Yes No
Verified answer

Amol Salvi 18,698 on at

Like (1)

Report

Check on original Action button whether any filters applied before executing the report.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

If I manually enter a number in the filter the report works as expected. Now I just need to find out how to make the report take the current number automatically. Thanks for the suggestion that put me on the right track!

Was this reply helpful? Yes No
spyroot 1,647 on at

Like (0)

Report

Use the following code on trigger action:

CurrPage.SETSELECTIONFILTER(Variable-type-Record);

REPORT.RUN(Report#,TRUE,FALSE,Variable-type-Record);

Variable-type-Record = table involved on report.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

How do you add code to pages/actions? I can't open the code editor while those are selected. I also don't have permission to create new Codeunit.

Was this reply helpful? Yes No
spyroot 1,647 on at

Like (0)

Report

implement the code on page through developer environment

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

How do I get to a field where I can enter code? When I open up a page in the developer environment I can't open the code editor the way I can with reports.

Was this reply helpful? Yes No
spyroot 1,647 on at

Like (0)

Report

Once you design the page go to view and then select page actions

then create the new entry for the button and last click F9 from keyboard or click on CAL Code button.

Then you can add the code there.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No matter which field I select in the page action designer I can't open the code editor. I've tried making new fields but nothing lets me do it.

Was this reply helpful? Yes No