Skip to Content
0
Former Member
Apr 22, 2014 at 02:11 PM

has value function

21 Views

Hi All,

This is the continuation of below thread.

Now In my report I have 3 parameters when, week and year.

If I select When=schedule then the report should run for current week without considering year and week values given in parameter window.

If I select when=Now then the report should run for week value and month value that we have given in parameter window.

Please suggest.


I tried like this but not working.


if hasvalue({?Week}) and HasValue({?Year}) and {?When} = 'Now'

Then

{?Week} = {Command.WEEK} and {?Year} = {Command.YEAR}

else

({?Week} = DatePart ("ww", Currentdatetime) and {?Year} = DatePart ("yyyy", Currentdatetime)