So I am creating a report that is based on a Fiscal year from April 1st to March 31st. In this report I have several calculations including Reported Week, MTD, Rolling 4 Weeks and Fiscal YTD. Everything works fine except when I try to create a graph for the rolling 4 weeks. Its a bar graph and it is added a blank bar before showing the dates. Here is the formula I used for the rolling 4 weeks:
if {table.date} in
cdate(DateAdd("ww", -4, cdate(dateadd("d",-(dayofweek(currentdate)-1),currentdate)))) to
cdate(dateadd("d",-dayofweek(currentdate),currentdate)) then
{table.date}
So I decided to use a subreport and while this does pull the results correctly since I force the above formula in the select expert it seems odd that I have to the subreport query against the report data when I already have it. I checked the formula as a group and I believe the issue is that it shows the last 4 weeks but the data before that is represented as a null value. Any ideas?
if {table.date} in
cdate(DateAdd("ww", -4, cdate(dateadd("d",-(dayofweek(currentdate)-1),currentdate)))) to
cdate(dateadd("d",-dayofweek(currentdate),currentdate)) then
{table.date}
So I decided to use a subreport and while this does pull the results correctly since I force the above formula in the select expert it seems odd that I have to the subreport query against the report data when I already have it. I checked the formula as a group and I believe the issue is that it shows the last 4 weeks but the data before that is represented as a null value. Any ideas?