I have a combined query, the results of which I am showing in a crosstab.
The resulting table has two column headings, the first 30/06/08, and the second 31/07/08. There are then rows of items with values under the two date columns.
The two columns appear to be a single object within the table, but webintelligence appears to be able to identify the two columns separately, for example of you use a max or min formula in a third column then it will identify the max figure on each row taken from either column.
Is there a way to identify the two columns within the table within a formula, for example to say column 30/06/08 less column 31/07/08 gives the movement?
Also I would like to sum the two columns and then define them as separate variable for use within other parts of the report, is this possible?
When you have a crosstab there is really only one value. If you view the report in structure mode, you can confirm this. For that reason you can’t use the standard min() or max() functions on the body of a crosstab and generate unique values per column…
With data your crosstab looks like this:
| Col Val 1 | Col Val 2
+----------------------
Row Val 1 | 1 2
Row Val 2 | 3 4
Row Val 3 | 5 6
In structure mode it looks like this:
| Col
+--------
Row | Val
So that’s why you get only one value for min / max as there is really only one value in the crosstab.
Thanks for replying so rapidly, and thanks for the welcome!
I thought that might be the response but was hoping there might have been some trick to get around it. Thanks anyway, I will have to think of another way.
(BOB member since 2002-06-06)