Formatting of report using calculation fields
The body of my report layout is designed to replicate a grid system, almost an excel style spreadsheet where cells expand and contract depending on the contents of the cells in that row. The picture attached shows this and also shows the problem I'm having.
There are 2 calculations that effect this;
List ( Substitute ( List ( Colour ; Material ) ; ¶ ; " " ) ; Description ; TextStyleAdd (Fittings;Italic) ; Brand ; Serial )
This creates the middle column and;
Let ([ Litem = Length (Report Item);
LDescrip = Length (Report Description);
LComments = Length (Report Comments) ];
Case (Litem ≥ LDescrip and Litem ≥ LComments; Report Item;
LDescrip ≥ Litem and LDescrip ≥ LComments;
Report Description; Report Comments) )
Which expands or contracts the given 3 fields depending on how many characters are in each.
As you can see from the image, due to the latter calculation, we are some times left with gaps in the report. Is there any way to change the 2nd calculation to be calculated by line breaks?
Is there any way to change the 2nd calculation to be calculated by line breaks?
ValueCount will count the number of items in a list. Since the items in a list are separated by returns (line breaks), this may serve your needs.