Ad hoc reports is an important part of External Report Integration framework within Business Reporting & Analysis. These reports are generally created by business users themselves to cater for their own reporting needs. Therefore, a user friendly GUI based ad hoc reporting tool is expected to suit the capabilities of such users who might not have an extensive knowledge of SQL, or database schema that a programmer would have.
Microsoft Report Builder 3.0 is an ad hoc reporting tool that is integrated with IFS Applications and can be reached via Business Reporting & Analysis/My Ms Reports in IFS Enterprise Explorer.
The Ad hoc reports provides access to the SQL Server Reporting Services (SSRS) web interface from within IFS Enterprise Explorer.
End users get personal areas, on the SQL Server Report Server, to place reports created through the Microsoft Report Builder tool.
Saved Ad hoc reports are, by default, only visible to the creator and administrators.