Skip to Content
0
Former Member
Apr 20, 2008 at 07:22 PM

How to develop this query

8 Views

Hi Experts,

From Source System (Flat File) in am getting Policy Expiry Date...

My requirment is to develop a report that will show...projection for Next 12 Months (Jan,Feb...Dec)

Report Format should be Count of Policies that are expirying in the next 12 Months classified according to month

-


(Columns)April(2008)....May(2008)....Dec(2008)...Jan(2009)...Feb(2009)..Mar(2009)

(Rows) No of Policies

expiring

How can i achieve this

Thanks

Edited by: BW USER on Apr 20, 2008 9:22 PM