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

Report Formatting

edited February 2003 in General
Hi,

I am trying to do a Report, which displays the ply details for a given Job.
Maximum number of ply's, a Job can have is 15. Most job will have 2 or 3
ply's. Regardless, of number of Ply's the Job has, I want to print 15 rows
out, with Ply details in, if less than 15 ply is used, leave the rows blank,
but still print it....

Example: (Job 9009 consists of 2 Ply's, but I still want to display the
other 13 rows, as blank.....)

Job 9009

Ply Description Cost
-------------------------------

1 Ply 1 12.99
-------------------------------
2 Ply 2 1.99
-------------------------------

-------------------------------

------------------------------- ....and so on....


How is this achievable in RB? I used to do this in Crystal....

Thanks in advance....

Comments

  • edited February 2003

    Create a subreport and set it to pbFixed. Size the subreport to occupy the
    desired amount of page space - for this example it needs to be "15 lines"
    tall. Connect the subreport to the datapipeline containing the ply details.


    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited February 2003
    I tried your suggestion, but it didn't show any data at all...

    Which band of the subreport do I put the 15 lines.....and which band of the
    main report do I put the subreport in?

    Thanks in advance

  • edited February 2003

    The specific data connections and location of the subreport depends on the
    datasets and the exact report output that you need.

    My guess is that the main report will be connected to a master dataset or
    will not be connected to any data at all. The subreport should be connected
    to the detail ply data.

    Reports and subreports traverse that datasets to which they are connected.
    That is fundamentally how RB works. If you need help with this, try working
    thru the tutorials in the Developers Guide and the see the
    RBuilder\Demos\Reports project.

    The subreport will need to be positioned on the main report at the exact
    location on the page where you want the ply detail to appear. If you need to
    draw some lines, use a PageStyle band, it can print in the background of a
    report or subreport.

    If you would like to create a simple example, using DBDemos that shows what
    you are trying to accomplish, you can send it to
    support@digital-metaphors.com and we can check it out here.




    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.