To the experts,
We have an example with two datasources. Both hold revenues and week numbers of two independent businesses, they are based on different tools and the data need to be combined in one crossing table. The main report uses odbc to connect to the 1st source and the subreport in the report header uses odbc to connect to the 2nd source.
We grouped the subreport based on concatenation and created a grouping array and a summary array,
Issue: the crossing table in the main report doesn't show the rowfield and columnfield that were used in the subreport's grouper formula.
What do we have to do?
The table we look for:
-rows: business-1 and business-2
-columns: week numbers (we used a formula based on revenue dates and another formula to convert the numbers to text)