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:

Attachments