Skip to main content

I have created a quick report that displays total order values for the Sales Group (CATALOG_GROUP) 

i.e. MTD, YTD, O/S Value, Overdue, Month+1, Month+2, Month+3, Month+4, Month+5 and Month+6.

The report works fine, however, in there old system the report displays the Period Date From and Date To values instead of Month+1, Month+2…..etc 

e.g.   Select net_value AS Date_FRom‘27/04/20 - 26/05/20’

I know I can get this information from ACCOUNTING_PERIOD_API.Get_Date_From and Accounting_Period_Api.Get_Date_Until BUT I didn’t think I could set column heading using these values.  

 

Could anyone please elaborate or confirm my suspicions.

One idea I had was to maybe using a PIVOT table

johnw66,

Are you shure there is only one header?

I can imagine a query that performs a union.

select a as part1

union

select b as part2

First the headers will be prepared and the second part will be the actual data that you already have the correct selection for.

Steve

Reply


Terms & ConditionsCookie settings