Hello,
PB 2017 R3
Need to set Autosize height property for few columns in the header#1 band.
The output is a bill format, with company name and address at top, few columns in both ends [ left & right side] of the paper. eg.
**********************************************************************************************
Company Name
Address-Line 1
Address-Line 2
Address-Line3
City-Pincode
Tel: XXXXXXXXXXXXXXXXXXXXXXXX GST: 33XXXXXXXXXXX
Mob: 9XXXXXXXXXXXXX Counter 3
Bill No. : WB-33 Vou No. : WB-33
Bill Date : 18/02/2019 Type : Cash
Name :
Mobile :
**********************************************************************************************
All the above details appear in header#1 band. Here Address-Line1, Address-Line2, Address-Line3 may or may not contain details. Hence those column heights are made zero, with Autosizeheight property set to true and also the band autosizeeheight property to true.
But I see the results are overlapping. Address-Line 1and Address-Line 2 overlaps.
Similarly in Footer#1 band also, there is one such column to be set with autosize height property [ie it to appear only when there is a non-zero value ].
How to avoid this overlapping ? Don't want to have empty spaces when no values for such columns.
Tried reducing that band height through script. Arriving how much to reduce is another complex issue. Reading the Columns X n height values gives the original X and height values, not after it's re positioning.
Since this calculation is to be done for 3 bands ( DataWindow.Header.1.Height , DataWindow.Trailer.1.Height , Summary ), arriving re-positioned columns height and X position is vital. Couldn't arrive those values, so far.
I'll try with minimum header height in design mode and see the result.