Hi all,
when i am generating a sample report in pdf format,and when i use on table column-total to get the report total,the total clause is coming in one line and the actual totals(calculations)are coming in the next(below) line.

i want the totals next to the 'TOTAL' clause

eg:
i am getting in the following way:

TOTAL
1000 20000 432222


I want the above in this form:

TOTAL 1000 20000 432222

This message has been edited. Last edited by: Kerry,

Not trying to be a jerk, here, but there are dozens of threads on this topic. Just do a search in Focal Point.

Unfortunately, this stupid problem is a hold-over from the mainframe core WebFOCUS language and I have wished it to go away for years and no one is listening. Of the dozens of threads Microfich refers to, I haven't yet found the definitive answer. The problem is caused by the first BY being a BY column-name NOPRINT...

It's not even necessarily a NOPRINT that is the issue, although that will ALWAYS cause the symptom. The problem is when the first column is not wide enough to display the sort value AND the label (TOTAL or something like that.) It can always be resolved by making enough space available, but that, unfortunately, can vary depending on column width, desired label, etc. Take your pick from the dozens of techniques mentioned - one of them will eventually work.

And I have wished it away many hundreds of times to no avail. I'm of the opinion that if a problem can be created by the GUI (which is easily done in this case by making the sort column invisible,) it should also be able to be solved by the GUI.

If we can't get this on the "fix-it" list by complaining unceasingly, how do we get it on that list of things that get "enhanced" even though no one has a problem with them?