Custom SSRS Report Request page Filter not working

(0) Share

Report

Posted on by bgajjar

150

Hello,

I have developed on custom SSRS report for BC, I have added 3 parameters using RequestFilterFields command in my AL code. when I run report from BC and select filter value and Preview report, it does not filter data as per parameter value. does anyone know about this issue ?

Categories:

Business Central

Reports and Business Intelligence

Other

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Olister Rumao 3,967 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can create text variables and put them on Request Page, and set Table Relation on the page for the fields and filter the DataItem on OnPreDataItem trigger with the help of these variables.

Was this reply helpful? Yes No
bgajjar 150 on at

Like (0)

Report
Copy link

Link copied!

Thanks Olister for the reply, I fixed this issue using PrintOnlyIfDetail = true; for multiple linked DataItem.

Was this reply helpful? Yes No