web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / RDLC Report Developmen...
Small and medium business | Business Central, N...
Suggested Answer

RDLC Report Development - Expression to display only sales column

(0) ShareShare
ReportReport
Posted on by M Saravanan 254

Hi Members,

I am trying to create an RDLC Report which displays the total number of sales and purchase document in a particular month. I have attached the RDLC Report design and its output for your better understanding.

The point is that, I wanted only the sales count to be displayed. But now, I am getting both the sales and purchase document count being displayed in the output. Also I am getting an extra row and column of zero which is not at all required in my output.

Could you please suggest me what will be expression to display only sales count and remove the row and column with zero??

Please do help me out to meet out my requirement.

Screenshot-2023_2D00_05_2D00_11-125638.png

Screenshot-2023_2D00_05_2D00_11-130321.png

Thanks a bunch in Advance,

Saravanan M

I have the same question (0)
  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,682 Moderator on at

    You can filter the data, to exclude purchases or only include sales.

    Filters can be put in the dataset (data items), and/or in the layout. You can also filter in the request page.

    Create report data items and their properties - Training | Microsoft Learn

    DataItemTableView Property - Business Central | Microsoft Learn

    Design the request page - Training | Microsoft Learn

    The empty row suggests you are grouping on a column that contains zero or null values.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,850 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,045 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans