Assuming you have a master calendar (probably not linked to your invoice table in your case) then create a straight table chart with your invoice fields as dimensions. Then, as an expression called Status, enter:
If(ExpiryDate<Max(Date),'Expired','Active') or something similar - I don't fully understand your requirement.
Hope this helps,
Thank you for the reply. I have the master calendar by using script from Josh Good, however I am trying to connect the calendar to the chart by using the date in the invoice table.
What I need (and try) to do is to make a simple report where it display the organization, their premium, and their commission.Those three are under sales table, then I have another table called Invoice where it has start date and expiry date. I need to make financial report from July 2010 to August 2011 which the expiry date is still "valid" or within or after the report timeline when that report is made.