Finance | Project Operations, Human Resources, ...

SSRS No object specified on menu item

(0) Share

Report

Posted on by AAK

I am new Dynamics 365 FO and SSRS Reports. I am trying to create drill through report in Visual Studio 2015. I have created 2 SSRS Report and 2 output menu item. I am using the following code to call the drill through from the first report (Precision design, field 'Action' property of the textbox)

=Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GenerateDrillThroughLink(Parameters!AX_ReportContext.Value, Parameters!AX_UserContext.Value, "[MenuItemName]", "[MenuItemType]", "[TableName]", "{Arguments}")

However upon clicking the drill through I am getting the below error

No object specified on menu item <MenuItemName>

I have already specified the second report that I would like to call on the Output Menu Item but still the errror. Not sure why

Any help will be greatly appreciated

Thanks

I have the same question (0)

All responses (8)

Answers (0)

Blue Wang on at

Like (0)

Report

Hi AAK,

Can you share your screenshot? MenuItem settings and drill through expression.

Was this reply helpful? Yes No
AAK 10 on at

Like (0)

Report

Please find attached screnshots

Screenshot # 2

Screenshot # 3

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (1)

Report

Hi AAK,

Have you tried the option "Go to report" instead of "Go to URL"? I'm not sure if "Go to URL" supports reports, at least in the documentation there is only note about forms.

docs.microsoft.com/.../how-to-add-a-report-drill-through-action-on-a-report

Was this reply helpful? Yes No
AAK 10 on at

Like (0)

Report

Hi Sergei,

Thank you for your response. The "Go to report" is working for me. I was trying to use the "Go to URL" option and landed up with the above error. I am new to AX, hence trying to explore features available.

Thank you all for your help. Much appreciated.

Was this reply helpful? Yes No
VermaMC 471 on at

Like (0)

Report

Hi AAK,

I have tried something similar to "Go to Report" to call a report from another report. But, it is not working, It is not giving me any hyperlink on the customer site column. Here is how I gave the expressions.

The xxx_CustBaseData report has a precision design called Report and has parameters. Once among those parameters is CustBaseData_AccountNum.

Can anyone please help me on this? there is no much information about the Drill through for reports but mostly forms.

Regards,

Verma MC

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Hi Verma,

After adding Go to report expression - Try restarting the SQL server reporting service and check.

Also try enabling the "Report drill through" from feature management.

Thanks,

Girish S.

Was this reply helpful? Yes No
VermaMC 471 on at

Like (0)

Report

Thank you for your response, Girish.

The restart did not help.

Anything I am missing on?

Was this reply helpful? Yes No
VermaMC 471 on at

Like (0)

Report

Is there any article that I could refer to which explains how to drill through from one report to another report or Is there any out of the box report that is available in D365FO?

Was this reply helpful? Yes No