Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Groups with fixed size and a Layout with 3 columns

edited August 2006 in End User
Hi there,

we have a very big problem.

We have a non 3th normal form dataset (buts it is ordered) where we define a
group to perform a page break. All this work fine.

Now we want to define a layout (A4 size) with 3 columns. We want the
detail-groups (defined as RecieverID which break on every new Reciever) to
have a fixed height, so it matches the labels on the paper. We want all the
detail information to be printet inside the detail-group band until a
certain height is reached. If the maximum height isn't reached, then Report
Builder should adjust the detail-group height, so all the next label starts
alligned.

Can this be done?

/Brian

Comments

  • edited August 2006
    Hi again,

    here's a more precise description:

    What I'm looking for is to define a fixed height for each column. I cannot
    find any solution when I'm using a group!

    /Brian
  • edited August 2006
    Hi Brian,

    Take a look at Fixed style subreports. If you place a fixed style subreport
    in the detail band of your main report, you can size it to be as large as
    you want, then inside the subreport, the data will not take up more space
    than you have allowed. I would suggest playing around with this style
    subreport and see if it can work in your case.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2006

  • edited August 2006
    Hi Brian,

    You do not need a master-detail relationship in order to use Subreports.
    You could simply connect your dataset to the subreport rather than to the
    main report.

    In order to limit the amount of vertical space a column uses in the detail
    band you have two options. Use a Fixed Style subreport or set the detail
    band's PrintHeight to phStatic and size it how you need.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2006
    This is a multi-part message in MIME format.
  • edited August 2006
    This is a multi-part message in MIME format.
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2006
    This is a multi-part message in MIME format.
This discussion has been closed.