"Contacts"."Customer Name" "Customer Name",

"Recurring Invoice"."Start Date" "Start Date",

"Recurring Invoice"."Next Invoice Date" "Next Invoice Date",

"Recurring Invoice"."Total (BCY)" "Total (BCY)",  /* BCY (Basic currency) is a column with all subscribed amount */

"Recurring Invoice"."Recurrence Frequency" "Recurrence Frequency",

"Recurring Invoice"."End Date" "End Date", 

/* converts the  invoices with months/years recurrence frequency to Revenue  Per Month */

"Recurring Invoice"."When" "When",

if ( "Recurring Invoice"."Recurrence Frequency" = 'Months', "Recurring Invoice"."Total (BCY)" / "Recurring Invoice"."When", "Recurring Invoice"."Total (BCY)" / ("Recurring Invoice"."When" *  12 )) as "Amount Per Month"

FROM "Recurring Invoice"

"Recurring Invoice"

LEFT JOIN "Contacts" ON "Recurring Invoice"."Customer ID" = "Contacts"."Customer ID"

WHERE "Recurring Invoice"."Status" = 'Active'

SELECT  

addmonth( current_date () , "Number_of_Months"."Month Number" ) "Date",

"Subscribed Amount per Month"."Customer Name" "Customer Name",

"Subscribed Amount per Month"."Start Date" "Start Date",

"Subscribed Amount per Month"."Amount Per Month" "Amount Per Month",

"Subscribed Amount per Month"."End Date" "End Date"

FROM ( SELECT 0 "Month Number"

UNION

SELECT 1 "Month Number"

UNION

SELECT 2 "Month Number"

UNION

SELECT 3 "Month Number"

UNION

SELECT 4 "Month Number"

UNION

SELECT 5 "Month Number"

) AS "Number_of_Months"

CROSS JOIN "Subscribed Amount per Month" 

WHERE ("Subscribed Amount per Month"."End Date"   is null

  OR "Subscribed Amount per Month"."End Date"   >= addmonth( current_date () , "Number_of_Months"."Month Number" ))

  AND start_day( month, "Subscribed Amount per Month"."Start Date")   <= addmonth( current_date(), "Number_of_Months"."Month Number" )