Position DB Cross Tab Object

How do I position the db cross tab object to an exact spot on a page?

I can position all the other controls 100% where I want them, but am finding that no matter where I position the DB Cross tab, it always starts at the top.

Any help greatly appreciated!

Kind regards,

A

Comments

  • How do I position the db cross tab object to an exact spot on a page?

    I can position all the other controls 100% where I want them, but am finding that no matter where I position the DB Cross tab, it always starts at the top.

    Any help greatly appreciated!

    Kind regards,

    A

    Actually, I want to do something even more simple:

    How do I position contents of a dataset (3 columns of 10 rows) at an exact Top and Left position?

    Many thanks!
  • gordkgordk St.Catherines On. Canada.
    edited 1:59AM
    Don't modify design top left props, modify where it is output by writing code
    in obp event of the object write code to use the engine object and set cury or curx props as required
    read the user manual on using the engine object.
  • gordk wrote: »
    Don't modify design top left props, modify where it is output by writing code
    in obp event of the object write code to use the engine object and set cury or curx props as required
    read the user manual on using the engine object.

    Thanks gordk, I'll try that. (I am still evaluating the product.)

    If I may ask, are there any plans to make this wysiwyg in future versions? (At least for simple tables. Is there another control I could use, btw?)

    I am happy with FR4 in pretty much all the departments, except that I want to produce a very complicated report like this:
    http://www.stanlib.com/vgn/images/portal/c...Fund_200806.pdf

    Positioning table items has to be precise, as you can see, it will be mighty painful to do this with code! [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> Kind regards, Abdullah[/img]
  • gordkgordk St.Catherines On. Canada.
    edited 1:59AM
    the dbcroos tab is designed to go to the top of the page if there is nothing above it controlling the engines cur y position
    take a look at the main demo crosstabs reports and see where it out puts to the finished page.
    the engine processes the design page from top down order depending upon band type, and within the band from left to right in order of creation.

  • gordk wrote: »
    the dbcroos tab is designed to go to the top of the page if there is nothing above it controlling the engines cur y position
    take a look at the main demo crosstabs reports and see where it out puts to the finished page.
    the engine processes the design page from top down order depending upon band type, and within the band from left to right in order of creation.

    Understood. (We've now managed to do as you suggested earlier re. engine.curx := 938 etc, but as we expected, it is really time-consuming to position the object precisely).

    Are there any plans to introduce a new control (like dbcross tab) that allows the user to position it precisely at design time any time soon?

    This is a major deciding factor now for us.

    Many thanks & kind regards,

    A

  • gordkgordk St.Catherines On. Canada.
    edited 1:59AM
    not that I know of.
    no object's position on the design page(s) is not necessarily relative to where it is on the output page.
    As the output page is formed by the report engine processing the objects on the design page, and depending upon the requirements of the object ( ie.stretching vertically to accomodate date recieved at runtime) the only setting that remains constant is the object's top position relative to the band that contains it and the height of the page footer band., in otherwords the fixed point is the printable area - bottom margin- height of the page footerband.
    one exception is the overlay band which really is an underlay, when used it is the first band processed
    any object placed relative to the top of the overlayband willout put that distance down from the output pages top margin.
    as the engine processes desig objects it constanly updates where it is curx, cury, and the remaining freespace on the output page.
    judging by the look of the screen shot you provided since you have other objects above the crosstab
    if those objects remain fixed in height then your crosstab will always appear at that point, on the output page.
  • gordk wrote: »
    not that I know of.
    no object's position on the design page(s) is not necessarily relative to where it is on the output page.
    As the output page is formed by the report engine processing the objects on the design page, and depending upon the requirements of the object ( ie.stretching vertically to accomodate date recieved at runtime) the only setting that remains constant is the object's top position relative to the band that contains it and the height of the page footer band., in otherwords the fixed point is the printable area - bottom margin- height of the page footerband.
    one exception is the overlay band which really is an underlay, when used it is the first band processed
    any object placed relative to the top of the overlayband willout put that distance down from the output pages top margin.
    as the engine processes desig objects it constanly updates where it is curx, cury, and the remaining freespace on the output page.
    judging by the look of the screen shot you provided since you have other objects above the crosstab
    if those objects remain fixed in height then your crosstab will always appear at that point, on the output page.

    Hi gordk,

    After some more investigation, we've concluded that working with the existing DBCrossTab object will not be feasible for us - as it does not allow transparency when overlayed with a shaded block (even after manipulating the engine.curx etc).

    We'd appreciate it if you could advise us regarding any other option to display tabular data without having to use bands (as show in the PDF link I posted earlier).

    1. Are there any third party controls for FastReport that does what we need?
    2. Is it feasible for us to develop a custom control? (How long do you estimate it will take to do so?)

    Any advice appreciated.

    Regards,

    A

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.