Year Filter

amsire2 · Post by **amsire2** » Tue Aug 16, 2022 2:49 pm

Im creating a crosstab report.

in column headings I select Field(Date). but when I running my project the filter didnot come out

arbei · Post by **arbei** » Tue Aug 16, 2022 4:26 pm

Make sure the field is a date or datetime field.

amsire2 · Post by **amsire2** » Wed Aug 24, 2022 10:36 am

I already used date.

arbei · Post by **arbei** » Wed Aug 24, 2022 1:21 pm

You may post your complete report settings (including the table schema) so other users can try.

amsire2 · Post by **amsire2** » Fri Aug 26, 2022 11:30 pm

I create a custom view call Statistic and consist of following fields
a. ID (PK)
b. BookDate (Date)
c. TotalTourist (Int)
d. BookingStatus

Then I created a crosstab report and this is the settings

Row Headings = BookingStatus
Column Headings = BookDate
interval = Month
and I tick the Year filter
Value = TotalTourist
Summary Value = SUM

When I used phpmaker 2021, the year filter come out but when I used the 2022 version, this not happen.

Post by **Webmaster** » Sat Aug 27, 2022 10:26 am

Please update to the latest template (Tools -> Update Template) and try again.

amsire2 · Post by **amsire2** » Sat Aug 27, 2022 11:28 pm

Done and its work. Thank you so much