Report Formatting
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....
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....
This discussion has been closed.
Comments
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
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
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