No Link Arrows in Your Query?
If you are missing a link to arrow next to a field you would normally expect to see an arrow, you must have forgotten to put...
Maximum Number of Fields for Print Layout Designer (PLD)
While creating a report in Print Layout Designer (PLD) from a query I noted that the maximum number of fields that the PLD would import was 100.
No Field Names in your Print Layout Designer (PLD)?
If you do not use FOR BROWSE in your query and you attempt to create a Print Layout Designer (PLD) report from that query, you may find that there will be no field descriptions for the fields.
Adding Fields to a PLD from a Query
The Print Layout Designer (PLD) apparently does not allow you to refresh the query (i.e., add columns to the query and thus add fields to the PLD). The only way we have found to overcome this is to copy all of the original layout and paste it into another layout (yes...you can do that!). Here are the steps:
- Change your original query and save it.
- Save the old report layout as a new name.
How to Make a Print Layout (PLD) Report from a SBO Query
Follow these steps:
How to Access the Query Manager
Access the Query Manager in two ways:
-
From the drop-down menus at the top of the screen, go to: Tools -> Queries -> Query Manager
-
Click on the Query Manager icon located on the icon bar at the top of the screen.
Print Layout Designer (PLD) - Field Properties
Line Break
- Determines how the values in the field will be displayed.
- Overflow will allow the text to extend beyond the length of the field.
Adjust to Cell will cut off the information to the assigned length of the field
Print Layout Designer (PLD) - Print Area Notes
Report Areas
Print Preview Size - PLD
While using print preview for a report you may find that the text is too small to see on the screen. You can control the size of the font by changing a setting in the Print Layout Designer.
Training Videos!
The Orchestra Team does it again! SAP Business One Partner the Orchestra Team has a series of videos (over 20) about using SBO that they have posted on YouTube. Here are a few examples of what you will find there: