web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) SSRS report Tablix Fil...

Microsoft Dynamics AX (Archived)

SSRS report Tablix Filter generates error in AX

(0) Share

Report

Report

Posted on by Community Member

I am using a filter in SSRS

I have added a tablix filter using the Top N function which should display the top N records in the data table.

But when I deploy the report to the Report server and AX I get the following error when I run it.

"Failed to evaluate the filter value"

Any ideas?

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Community Member on at

Like (0)

Report

RE: SSRS report Tablix Filter generates error in AX

I don't think this is the answer, as I have entered a second value for the N parameter. It works fine in SSRS but not in report server or AX.

Was this reply helpful? Yes No
Suggested answer

Denis Macchinetti 16,444 on at

Like (0)

Report

RE: SSRS report Tablix Filter generates error in AX

Hi Craing

I think you have to check the filter condition.

Take a look to this post stackoverflow.com/.../ssrs-iif-filtering-on-tablix

Here you can find an similar issue.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Our Community Code of Conduct has been updated!

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Community Member 4

#2

Guy Terry 2 Moderator

#2

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans