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

All responses (8)

Answers (0)

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.
Community Member on at

Like (0)

Report

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

Suresh Kulla 47,688 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.
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?
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
Suggested answer

Amol Salvi 18,696 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...
mmv 11,467 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.
Suggested answer

Suresh Kulla 47,688 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.