Skip to main content
Question

Question re Quick Reports


Forum|alt.badge.img+18

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.

2 replies

Forum|alt.badge.img+18
  • Author
  • Superhero (Partner)
  • 364 replies
  • June 2, 2020

One idea I had was to maybe using a PIVOT table


eqbstal
Superhero (Partner)
Forum|alt.badge.img+21
  • Superhero (Partner)
  • 677 replies
  • June 2, 2020

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings