Hi all,
I have a stupid issue:
I created two queries and one of them as a SQL query tpe.
I created a third query where I would like to join the two queries.
Next I generated a new list with the third query as basis. The list works and shows me all needed data.
But if I want to replace the list by a crosstab the intersection becomes empty.
Does anybody know why?
Is a further setting necessary?
Many thanks and Regards,
elroy
The item in the intersection must be a number. Could it be that you are selecting some other type like a string or a date?
The item in the intersection is a "count" (so a number) from the SQL statement.
In addition I tried following:
1. Change the Data Format of the intersection properties to Number.
2. Add a cast clause (to integer) to the intersection data item
But nothing of this works :(
My addition to Lynn's reply would have been that - in any case - an aggregate has to be set, otherwise an empty crosstab is the result (even with numerical values) So what is the aggregate property setting in Report Studio?
The aggregate function was on "Automatic" ..
I changed it to "Count" and it works now :) :)
Many thanks,
elroy