How to apply filter on fields from three different tables in RDLC report of NAV2016

(0) Share

Report

Posted on by Community Member

I am trying to develop a RDLC report of NAV2016 using three tables 'Resource', 'Time sheet Header' and 'Time sheet Line'. I am facing issue while applying filter on each table.

1. First, I want record from Resource table for those resources who have ticked 'Use Time Sheet' and type 'Person'.

2. Second, from 'Time Sheet Header' table I want starting date and ending date of current week. Time sheet Header table is indented to Resource table.

3. Third, from 'Time Sheet Line' table I want Time sheet number and status is 'Open' for current week. Time Sheet Line table is indented to Time Sheet Header table.

when I am applying these filters in NAV2016 then it is also displaying records for those whose status is 'Approved' for current week. If I apply condition in Visual Studio to show only records with 'Open' status then it overrides other filters of report and doesn't show record from Resource table. So, how to get the desired result?

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Suresh Kulla 50,237 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to apply filter on fields from three different tables in RDLC report of NAV2016

How are you applying filters to those data items ? you can apply filters using DataItemTableView property.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

RE: How to apply filter on fields from three different tables in RDLC report of NAV2016

Hi,

You can apply the filter in the Time Sheet Header by navigating into the Properties -> DataItemTableView.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: How to apply filter on fields from three different tables in RDLC report of NAV2016

Apply filter on dataset directly rather than in visual studio...

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

RE: How to apply filter on fields from three different tables in RDLC report of NAV2016

Rema ,

can you mention your commend on here so we can give you the solution if you have any thing missing from u

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to apply filter on fields from three different tables in RDLC report of NAV2016

Hi,

I am using DataItemTableView property only, Can you suggest something else, what can be the issue?

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,237 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to apply filter on fields from three different tables in RDLC report of NAV2016

Please attach the screenshots of your filters. If you apply the filter on DataItemTableView it will not retrieve any other records, the other way you can apply filter is add the code OnPreDataItem of the DataItem.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to apply filter on fields from three different tables in RDLC report of NAV2016

Was this reply helpful? Yes No
Suggested answer

Yogesh Kulkarni_ 1,762 on at

Like (0)

Report

RE: How to apply filter on fields from three different tables in RDLC report of NAV2016

DataItems with their Indentation and specific properties seems ok.

Please check if you have any specific code to set filters on OnPreDataItem trigger.

Also, remove visibility from Visual Studio, if applied.

-Yogesh Kulkarni
Please verify, if you find answer helpful.

Was this reply helpful? Yes No