reports like Excel sheets with border rsp. frame
Hi,
now I've to create reports looking like a Table in Excel with
1. a normal thick line around the whole table
2. a normal thick line beneath column titles or between alle rows (case
3. thin lines that are between columns or also between rows (not case
4. the column titles should be left in column, but centered vertically
__________________________________
First Try - Grid Option of DataTree
Problems:
(1)
The second column is defined in database table with Varchar(100) so it
shift some columns out of the visble part of report.
(2)
In every case its seems to be necessary to rearrange the columns by
calculating and change left and width manually.
(3)
The thin lines between the columns aren't possible because of using
TppShape without a Border-property to suppress left and right border of the
inner fields and substitute it with a TppLine.weight = 0.2 i.e.
__________________________________
Second Try - using TppLine
it has the Border option but in setting true top an bottom, I doesn't see
any effect
__________________________________
Third Try - wow TppLabel/TppDBText have an border option and an assistant
to set top and bottom on - or what you like.
But you can't give it a nice look because the text stays in the upper left
corner - no chance to center it vertically or to give some pixels room left
(ok that's also not possible in Excel).
__________________________________
Fourth try - with region, shape and line
A TppRegion for the Titles (ParentWidth=True) and TppShape for the Details
(ParentWidth/Height=True). Vertical TppLines (ParentHeight=True) in both
for separating the columns.
It seems to be good. But in setting i.e TppRegion/TppShape.Pen.Width = 3,
you see top and border lines are both printed - clearly but not nice.
__________________________________
Last try - only using TppLines where they are needed
A TppRegion for the Titles (ParentWidth=True, Pen.Style = psClear) makes it
again possible, to use TppLines.ParentHeight=True.
This is OK for me.
But probably there is an easier way ???????????????????????????????????????
___________________________________
It would be nice to have (for TppLabel and TppDBText) some extra properies
- SpaceLeft, SpaceTop to shift it from the border
- possibly VerticalAlignment
- AutoFitToNeighbour for easy column-building
also for TppLine, calculating its width with its printed line width
--
Best regards
Dietmar Brueckmann
now I've to create reports looking like a Table in Excel with
1. a normal thick line around the whole table
2. a normal thick line beneath column titles or between alle rows (case
3. thin lines that are between columns or also between rows (not case
4. the column titles should be left in column, but centered vertically
__________________________________
First Try - Grid Option of DataTree
Problems:
(1)
The second column is defined in database table with Varchar(100) so it
shift some columns out of the visble part of report.
(2)
In every case its seems to be necessary to rearrange the columns by
calculating and change left and width manually.
(3)
The thin lines between the columns aren't possible because of using
TppShape without a Border-property to suppress left and right border of the
inner fields and substitute it with a TppLine.weight = 0.2 i.e.
__________________________________
Second Try - using TppLine
it has the Border option but in setting true top an bottom, I doesn't see
any effect
__________________________________
Third Try - wow TppLabel/TppDBText have an border option and an assistant
to set top and bottom on - or what you like.
But you can't give it a nice look because the text stays in the upper left
corner - no chance to center it vertically or to give some pixels room left
(ok that's also not possible in Excel).
__________________________________
Fourth try - with region, shape and line
A TppRegion for the Titles (ParentWidth=True) and TppShape for the Details
(ParentWidth/Height=True). Vertical TppLines (ParentHeight=True) in both
for separating the columns.
It seems to be good. But in setting i.e TppRegion/TppShape.Pen.Width = 3,
you see top and border lines are both printed - clearly but not nice.
__________________________________
Last try - only using TppLines where they are needed
A TppRegion for the Titles (ParentWidth=True, Pen.Style = psClear) makes it
again possible, to use TppLines.ParentHeight=True.
This is OK for me.
But probably there is an easier way ???????????????????????????????????????
___________________________________
It would be nice to have (for TppLabel and TppDBText) some extra properies
- SpaceLeft, SpaceTop to shift it from the border
- possibly VerticalAlignment
- AutoFitToNeighbour for easy column-building
also for TppLine, calculating its width with its printed line width
--
Best regards
Dietmar Brueckmann
This discussion has been closed.
Comments
Thanks for the suggestions.
The ability to adjust the buffer between the text and border and vertical
text alignment are both features we may look at for a later release.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com