I have a simple two-column multiple row report with the repeated pattern of a static text heading in one row (the left hand cell only) followed by a memo/long text field in the two merged cells of the following row. The two column idea helps with the header.
Some detail fields are null, so I wish to suppress both the heading and detail rows of these pairs. I would have thought this was a common use pattern for reports BUT, the the 'suppress blank' property WILL NOT save as true for me. This is despite following the directions in the release notes to the letter, ie by assigning the property to the whole row rather than just the cell.
Each time I select 'suppress blank,' as true and save, then return to that row - the property has changed back to false. This applies to both the rows with the headings and the detail fields. I have also tried 'case if,' and setting the headings to null in the SQL so that there is definitely nothing there - neither with any success.
The html report version of the report looks fine, but the pdf version prints in a jumbled mess - detail fields lining up under the wrong headings. The 'shrinkable' property does save, but makes no difference to the layout of the pdf reports.
As there are no posts on this subject after about 2012, perhaps I'm missing something! I'd really appreciate a few tips on this little challenge from those who have gone before.
Some detail fields are null, so I wish to suppress both the heading and detail rows of these pairs. I would have thought this was a common use pattern for reports BUT, the the 'suppress blank' property WILL NOT save as true for me. This is despite following the directions in the release notes to the letter, ie by assigning the property to the whole row rather than just the cell.
Each time I select 'suppress blank,' as true and save, then return to that row - the property has changed back to false. This applies to both the rows with the headings and the detail fields. I have also tried 'case if,' and setting the headings to null in the SQL so that there is definitely nothing there - neither with any success.
The html report version of the report looks fine, but the pdf version prints in a jumbled mess - detail fields lining up under the wrong headings. The 'shrinkable' property does save, but makes no difference to the layout of the pdf reports.
As there are no posts on this subject after about 2012, perhaps I'm missing something! I'd really appreciate a few tips on this little challenge from those who have gone before.
Comment