In CABI Jasper adhoc view, no data is being displayed in the screen, or if you click on "view SQL query" button

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:

Environment

CABI 6.30, 6.43. 7.1.1

Cause

In the adhoc view, the "no data" option was selected in the dropdown menu:

Resolution

In the dropdown menu, you must select "sample data" or "full data" to see both SQL query and report data displayed: