News and Announcements icon

Dynamics 365 CommunityForums 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) Share

Report

Report

Posted on by M Saravanan

281

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.

Thanks a bunch in Advance,

Saravanan M

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Steven Renders 5,051 Super User 2024 Season 1 on at

Like (1)

Report

RE: RDLC Report Development - Expression to display only sales column

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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans