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?
3 Answers:
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.
What you mean by "data trim"?
I'm having the same problem here.
What does it mean by "data trim" ?
I am facing the same issue while using generic element in Jasper Studio
Solved by Changing from "Done't use a Data Adaptor" to "One Empty Record"