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

Mysql Images & Blobs field

edited August 2010 in General
I need to create a 6 page document that comprise of 6 different images in
different fields. Image1, Image2 etc.

These need to fill each page with the image.

How do I create the 'extra' pages?

Comments

  • edited August 2010
    Hi Steve,

    1. Create a report with nothing but a Detail Band.
    2. Place 6 Section style subreports inside the detail band.
    3. Load each separate image into each subreport.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2010
    I now have a report with a header and footer containing a logo & page count.

    I have added into the DetailBand
    Subreport10
    Subreport11
    Subreport12
    Subreport13
    One below the other. ie 4 rows.
    Each sub report has a header & footer and 2 DBImages that fill the detail
    band.(one above the other).

    When I run the report I would expect to see :
    Logo - 2 images(image 1 & Image3) - page 1/4
    Logo - 2 images (image3 & image 4) page 2/4 etc

    I get 2 pages page 1/2 (image1 & image2) with (image3 & image4) on top
    page 2/2 (image5 & image6) with (image7 & image8) on top

    I have played with the page breaks but cannot get the correct result.

    What am I doing wrong here?
  • edited August 2010
    Hi Steve,

    I'm sorry, I did not realize your images were on a database (I missed the
    subject). Since each image is located in a dataset, there is another option
    using groups that would be easier. In a new report, try creating a group
    that breaks on each record and set the group to start a new page. This way
    you can place a single DBImage in the detail band and it will update for
    each record in the dataset.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited August 2010
    Not sure how to do this. I do not see any group icons. (Ver 9.01)

    I have Fields Sign1 / Sign2 ..... Sign8.

    I am trying to create a report where each page just shows Sign1 / Sign2 etc.

    CHeers

    SteveW
  • edited August 2010
    Hi Steve,

    Groups are a fundamental feature of ReportBuilder and are essential for many
    data-driven reports. I highly suggest spending some time with the
    Developer's Guide working through the provided tutorials to become more
    acquainted with the main features of ReportBuilder. It will make the
    development process much easier and more enjoyable.

    Groups are created using the Groups dialog (Report | Groups option from the
    main menu). Take a look at Demo 41 located in the \RBuilder\Demos\1.
    Reports for an example of what I'm talking about. This shows how to create
    a report with a single record for each page. You would want to do something
    similar to this with your report.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.