Empty crosstab

[elroy]

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

[Lynn]

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?

[elroy]

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 :(

[blom0344]

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?

[elroy]

The aggregate function was on "Automatic" ..
I changed it to "Count" and it works now :)  :)

Many thanks,
elroy