Display record based on a condition in a report

Business Central/NAV Developers Forum
1

Hi All,

I am a beginner in C/AL. I am currently using NAV 2013.

I am trying to build a report which returns all those employees whose VISA DATe of Expiry(Custom field- data type of date)

are due to expire this month.

I try to subtract the Visa Date of expiry with TODAY which gives me no. of days in integer.

But i have no idea how I can conditional check this integer variable in order to display or hide a record.

Thanks.

2

Check the Row Visibility in RTC report.

3

To manage visibility in Visual Studio you need to add a condition in Hidden property of the corresponding row group based on no. of days field.

4

Thanks Amol! :slight_smile:

5

Welcome…