Computed expression at summary band is shown at detail band at the time of print.

Powerbuilder Version 12.5
datawindow dw_xyz style grid
I have created a computed expression 'Total sales of the above scenario' at summary band
but when I take the print it shows at detail band, rather it mix ups with detail band.

When I attribute the position as "band" at the time of print only 'Total sales' (the width of the column is shown and 'of the above scenario' is not shown.

When I attribute the position as "foreground" or "background" 'Total sales of the above scenario' is shown but it mingles with the contents of the detail band. Is there any solution.?
Who is Participating?
Harish VargheseConnect With a Mentor Project LeaderCommented:
Hello Mehram,

Setting the layer to "foreground" computes the position of the control (computed field) relative to top of the datawindow. This will position the control in fixed position irrespective of the number of rows you have in detail band. Hence you will not be able to judge where the control will appear when you retrieve and when you print.

So, for all controls you should use the layer "band" only except for background images or borders you want to display relative to top of the page.

Now, regarding your problem of not displaying/printing text completely, have you given enough width for the complete text to appear? If you want the text to wrap to next line, you need to check "Autosize Height" property of the computed field in Position tab. Also, make sure that your summary band has enough height to accommodate multiple lines. If you are not sure, try increasing the height of the summary band.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.