Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************Got the opportunity to pen a Book on Database Cloud Services.......More details to follow.***************

Title : Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2020

**********************************************************************************


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Azure Certified Architect

Azure Certified Administrator

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

Search This Blog

Wednesday, June 7, 2017

Smartview Ad hoc grid cannot be opened as there are no valid rows of data


In smarview when trying to do the ad-hoc analysis you may see the below error message:

Ad hoc grid cannot be opened as there are no valid rows of data
















Fix:

Under Data Options:
you should clear the suppress options in the Data Options tab of the Options dialog box. Ensure that all Suppress Rows and Suppress Columns options are cleared, and that the Suppress missing blocks option is cleared



3 comments:

Anonymous said...

Thanks! Super simple fix but only because i found this article!

Feeroz Khan said...

Thanks

Anonymous said...

Thank you it work!