On the left side of the report generator you will find the report controls. They can be inserted on the report and used in different ways.
Below is a description of the different controls and their use
Combine fields in a label
If you want to combine the postal code with the city name in one field, you need to fill in the lab as follows:
[DebtorInfo.Zipcode] [DebtorInfo.City]
You can do this with all available fields in the Report Generator.
Numeric label with 1000s separator and 2 decimal places
Right-click on the label containing the numeric value and select Edit
Select Format String
Select Number and n2
Click OK and see your result.
Labels
Language in labels In the report generator, you can use different languages depending on the language selected for the customer/reseller. You can see the different label names under "Tools/Labels/Labels" Here you can search for the Danish word and see if it exists. If you find the word, type @[lablesname] from the overview in your label i (works for report generator fields, custom fields and calculated fields). Example: We want to use Requisition, we find Requisition and in our label we write @Requisition. If an order does not exist, you can create it in "Tools/Labels/Custom Labels" Read more here... Note: Everything to do with fields is case sensitive - which means that the letters must be written with the correct upper and lower case. Translation of fixed texts in labels If you have debtors with different languages, you can either choose to create different reports for the different languages, but you can also control this via labels in a report. If we need Danish, German and English, we can create three labs, each with its own translation, and stack them on top of each other. Each label has been assigned the following values in the Visible field. This works for a user profile with Danish or English language selected in Uniconta. If the debtor has German language iif([DebtorInfo].[Language]='German', true, iif(Contains([DebtorInfo].[Language],'German'), true, false)) If the debtor has English language iif([DebtorInfo].[Language]='English', true, iif(Contains([DebtorInfo].[Language],'English'), true, false)) If the debtor has neither English nor German, the Danish label is printed. iif([DebtorInfo].[Language]<>'English', iif(Contains([DebtorInfo].[Language],'English')=False, Iif([DebtorInfo].[Language]<>'German', Iif([DebtorInfo].[Language]<>'German',True, False) ,false), false), false)
Combine fields in a label
If you want to combine the postal code with the city name in one field, you need to fill in the lab as follows:
[DebtorInfo.Zipcode] [DebtorInfo.City]
You can do this with all available fields in the Report Generator.
Numeric label with 1000s separator and 2 decimal places
Right-click on the label containing the numeric value and select Edit
Select Format String
Select Number and n2
Click OK and see your result.
Date format in labels
If your date field appears as date and time, select the field and click the small arrow to the right of the field. In the Format string field, select DateTime on the left side and on the right, select how that field should be formatted. Formatting the content of labels Select the field you want a different formatting for, click the small arrow to the right of the field. In the Format string field, choose what type to put in the field on the left side and how the field should be formatted on the right side.Panel
How do you show only the address fields that are filled in? To not show empty fields, such as the second and third address fields, use the Panel control- Select a control from the left side called: "Panel" (a gray square) and drag it onto the report
- Note: The panel should be placed in an empty space, can later be dragged to the desired location.
- Then select the fields and drag them on top of the panel.
- Note: The panel must be placed "at the bottom", i.e. the fields must be placed "on top" of the field.
- All fields except the panel should be selected and in Properties, they should be set to "Contractable" and "Hold together"
- It is also important that the fields do not overlap. become red, because then it won't work.
- The fields should be as close together as possible without overlapping.