If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Empty crosstab

Started by elroy, 09 Jun 2011 09:20:37 AM

Previous topic - Next topic

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