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.?
MehramAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Harish VargheseProject 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.

Thanks,
Harish
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Editors IDEs

From novice to tech pro — start learning today.

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.