Gunnar:
I have run into this problem when I have to report totals on the footer of a
report with many columns and where real estate is at a premium. In most
cases the column width at the detail level is fine as the numbers are not
necessarily big, but, when you have several thousand detail lines, the
totals can get pretty large and one of the options is to display less
columns and allocate more space for the column totals. Since this is not
always feasible what I do is display the totals in 2 lines, allocating more
room for the totals; for example, total for column 1 is displayed on line 1,
total for column 2 is displayed on line 2, total for columns 3 is again
displayed on line 1 and so on. The result looks like:
Col1 Col2 Col3 Col4
Col1 Col2 Col3 Col4
Col1 Col2 Col3 Col4
===== ===== ===== =====
My_Total 1 My_Total 3
My_Total 2 My_Total 4
Hopefully the above will display correctly, but you get the idea...with this
approach I can assign a much larger space to the totals...
Javier,
Javier Valencia, PE
President
Valencia Technology Group, L.L.C.
14315 S. Twilight Ln, Suite #14
Olathe, Kansas 66062-4578
Office (913)829-0888
Fax (913)649-2904
Cell (913)915-3137
================================================
Attention:
The information contained in this message and or attachments is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon,
this information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the sender and
delete the material from all system and destroy all copies.
======================================================
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Gunnar Ekblad
Sent: Tuesday, April 26, 2005 10:48 AM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Old problem needs new solution
I wonder how you all handle reporting of numeric values (Real, Double,
Currency, Numeric) in windows version of R:Base!
I old DOS style, If I had a value that was bigger than fitted the field
I got nicely ********** as resultat telling me I had a value to was
bigger than could represented in the allocated space.
I windows version If I have a value of say $10,563,952.53 that on a
report comes out as 563,952.53 since I did not allocate space enough,
has any body figured out how I can get a warning/error/format/?? so I
will be aware that something is wrong. The only thing I have come up
with is to allocate more then enough space. But sometimes that solution
takes up to much space that could be better used for other purposes.
I guess what I am asking for is right clicking a report field beside the
existing "Display format, Null Format" I would like to see "Overflow
format". In a way I can use autosize, but that leaves me out of the
control of the format and space allocated.
Or has anyone already solved this in nice and smart way?
Gunnar Ekblad
