Sometime in the report you might wanted some extra information but you not able to select in the report design. So we had to self query to get the extra information.
Below is example using Sales Invoice