execution of a code to achieve the report mechanism of calling it.
On the other hand, a report running with no data does not mean your report is at the save mode. It's only a warning message that denotes one or more ambitious problems is waiting for you. Even though it is only one problem, but it.causes it has so many reasons
Today's task in shaa Allah, I will list the reasons for displaying a report with no data even though there is a data stored in the database.
- Execute the report query into SQLPLUS or Toad to check for data. If it displays data then the problem exists either in the report or the parameter form.
- Comment each suspected condition at the where clause query line by line.Then, re-execute the query. Repeat these steps until you get the data displayed.
iii. Is the query parameters are logically correct?
· A colon character, You may copy the parameter preceding colon ':' in the report query as follow:
The date range is reversed, so you can solve this problem if you correctly reverse the wrong date range to the correct one. A good developer can expect this problem and handle it through writing a date range validation on each item on the parameter form to enforce the user to input the correct logical date range and etc.