QUERY BASED PRINT LAYOUT
SAP Business One allows us to create a report based on the system generated and user defined query. With the help of this feature we can generate reports according to our own requirements.
Creating A User Defined Query
Choose Tools –> Queries –> Query Generator
Click on Execute button.
Click on the highlighted Pencil Icon to enable to write sql query in the editor. Write SQL query and
Click On Save Button.
Select the Query Category. Enter Query Name and Click on Save button.
Creating A Query Print Layout
Now we have created the query as per our requirement. All we have to do is to link the query to the print layout. For this follow below mentioned steps.
Choose Tools –> Queries –> Query Manager
Select User Defined Query generated earlier and select Create Report
User Defined Query name will reflect in the name field automatically. You can change the name if you wish to.
Select the base template from which to design the report and click on Ok button. Create User Report window will get closed.
Viewing A Query Print Layout Report
To view the Query Print Layout Report based on system template, choose
Tools –> Queries –> Query Print Layout –> Reports Tab –> Select Recently Created Report –>Click on Preview Icon on the toolbar.
This is how the QPLD looks like at first place. It needs to be refined through Print layout designer wherein you can change the appearance of the field by making use of formatting options like font, colour, Size, Border etc. and customize it as per your requirement.
Scheduling A Query Print Layout Report
Some reports are meant to alert the users for some action to be taken. In such cases the scheduling helps. In scheduling we can set the frequency of executing the report, we can mail the report to the designated recipients.
To schedule, Choose Tools –> Query Manager –> Select The Appropriate Query On which Report Is Based –> Click Schedule Button
Enter the password
Set the start time and the frequency of report execution. If this is a time bound activity, then set the End Date, else leave the field blank. And click On Add button.