Wednesday, 11 March 2015
You are Facing This
Error because the fields in your query are not matching with the report fields.
Take following
precautions while adding query to report query window
- Use "Read Field" button in Report query
window, it fill Fields variables with the fields of the query and avoid
later problems.
- The length of the field $F {name} shouldn't exceed 32
characters (field < 32).
See below screenshot to
get the clear idea about the window where you need to focus.
Note : For best practice use aliases for Subqueries/DECODE/NVLstatements in your main query to avoid further issues.
