Dynamics Community Forum Thread Details

SSRS Report for Sales order filter Issuses

Hi,

On the Sales Order page, I have added a custom button to create a new report. The report uses the following tables:

Sales Header (default table)

Sales Line (default table)

Lot Data (new table)

Scheduling Window Line (new table)

The tables are linked to generate the new report, which is currently functional. I need to preview the report and apply filters for the following fields:

If no filter is added, the report should display all records.

Sales Header: Document Date (filter is working for this field)
Lot Data: Ask Ship Date (filter is Not working )
Scheduling Window Line: Fabrication Date (filter is Not working )

The filters should allow manual entry of date ranges in the report window. For example:
Single date format: 11/18/2024
Date range format: 06/01/2023..11/20/2024

Currently, the filter works only for the Sales Header table field (Document Date).
For the other fields (Ask Ship Date from Lot Data and Fabrication Date from Scheduling Window Line), the filter is not working—it shows all records instead of filtering.

How can I add filtering for these fields to work as expected?

Thank you,

Categories:

Business Central

Quick Links

Leaderboard