SAS Viya 3.5 - no data appears because too many values were returned from the query

[mrafiqahmed]

Hi,

I have a crosstab in my report. When I open the report, it doesn't load the data into the crosstab; it shows the warning

'no data appears because too many values were returned from the query...'

Please look at the screenshot. 

I have set 5000000 limit for crosstab in reportdata.properties; but, still this issue occurs. Any help to resolve this issue is appreciated.

[rodrigo_pereira]

Hello,

same issue here!
There are other parameters which should be changed in order to have the data displayed and exported as is in the cross tab?

Thank you,

Rodrigo

[rodrigo_pereira]

Even after the changin the CrossTab limit to 500.000, the cross tab apparently is still limited to 40.000 rows. 

[Madelyn_SAS]

There are other cardinality properties that can impact the amount of data shown. Please see 

https://support.sas.com/kb/62/148.html