Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Matrix report filtering problem.

(0) ShareShare
ReportReport
Posted on by

Hi,

     In my report I have declared a DataItem as 'Item Journal Line'. From which I have taken a field 'Item Type' which is a option field. Within the OptionString property I have declared these options: ,Paper Roll,Ink,Plate,Scrap,Film,Chemical,Others,Electrical,Mechanical,Stationary.

     Then in the RDLC view I have taken a matrix & I only want to show the data stored in 'Description' column against  the 'Scrap' option of 'Item Type' column as column headers in my report.  For that I have declared the following in 'DataItemTableView' property of 'Item Journal Line' DataItem:

WHERE(Item Type=FILTER(<>Ink))

But I couldn't declare the other options such as Paper Roll, Ink, Plate etc. as it won't shows the desired result. Please help me out!

*This post is locked for comments

  • Nareshwar Raju Vaneshwar Profile Picture
    5,596 on at
    RE: Matrix report filtering problem.

    Hi Rajat,

    Please contact me via rajnareshwar at gmail dot com.

  • Community Member Profile Picture
    on at
    RE: Matrix report filtering problem.
    [deleted]
  • Community Member Profile Picture
    on at
    RE: Matrix report filtering problem.

    Hello Nareshwar,

                  Sorry for d late reply. If you don't mind would you send me any reference related to my question. It will be very helpful to me.

                                                                         Thank You & regards,

  • Suggested answer
    Nareshwar Raju Vaneshwar Profile Picture
    5,596 on at
    RE: Matrix report filtering problem.

    Hi Rajat,

    Just one question, why would you filter <>Ink, if you want only Scrap. Anyways, I recently developed a report which is very similar to your requirement (or I misread you completely). Please PM me so I can share the object for reference.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans