RDLC Report Development - Expression to display only sales column

(0) Share

Report

Posted on by M Saravanan

180

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 (1)

Answers (0)

Suggested answer

Steven Renders 5,500 Moderator 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.