ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
In CABI Jasper adhoc view, no data is being displayed in the screen, or if you click on "view SQL query" button
book
Article ID: 200884
calendar_today
Updated On:
Products
CA Spectrum
Issue/Introduction
In an adhoc view created on CABI, you click on "view SQL query" button and nothing is displayed:
Also, the view does not show any data, and the message "Set the data mode to Sample or Full to see data" is displayed:
Cause
In the adhoc view, the "no data" option was selected in the dropdown menu:
Environment
CABI 6.30, 6.43. 7.1.1
Resolution
In the dropdown menu, you must select "sample data" or "full data" to see both SQL query and report data displayed: