This document is empty

1

So when I run the report and apply certain paramaters the report returns no data.  I get  "This Document is empty"

 

Some of the fields i'm using the sql nvl function.  Thoughts?

 

 

 

winterhawk's picture
Joined: Sep 9 2015 - 3:05pm
Last seen: 3 years 11 months ago

2 Answers:

0

Some possibilities for the situation that coming to my mind:

1. Check the report datasource if it is correct or not?

2. Be sure that after adding parameter, is your query generated as you want?

3. If you create and use different dataset from the main dataset, are the parameters send to dataset in use? 

4. If you are using different dataset from the main data set and parameters are send to dataset properly, Does your main dataset generate a result even if it is not in use? Because even main dataset is not used, it has to be generate at least a row. If it is the situation you can add 'SELECT 1 as TEMP' to your main dataset.

zh3ntil's picture
531
Joined: Nov 19 2014 - 11:02pm
Last seen: 3 years 3 months ago
0

Data trim was the issue.angry

winterhawk's picture
Joined: Sep 9 2015 - 3:05pm
Last seen: 3 years 11 months ago
Feedback
randomness