Has anyone used Report Builder Pro to design a general Flyer generation program. I'm looking for a way to add variable size and number of jpeg's as well as several text boxes. TIA
I'm not sure what your data is like, but here's my interpretation:
You could dynamically create TppDBImage and TppLabel components based on a query, and put them all in the detail band. Basically, you need one big detail band to print on a single page for your flyer. Use a query to return records for the image (blobs or network file locations as string) and text descriptions. To use only one detailband set AutoStop to True on the report. If you had Enterprise you could create the components in RAP. Probably want to create RAP pass through functions to get at the data pipelines and traverse the records manually from within RAP to see how many components you need to create and to fill them with data.
Or you could create a master-detail relationship, where the detail records would find all images and description text records for that flyer. Use section style subreports since they always start on a new page. I think you can get away with setting AutoStop to true on the subreport. Then each section style subreport would have the dynamically created components in their detail band.
Comments
You could dynamically create TppDBImage and TppLabel components based on a
query, and put them all in the detail band. Basically, you need one big
detail band to print on a single page for your flyer. Use a query to return
records for the image (blobs or network file locations as string) and text
descriptions. To use only one detailband set AutoStop to True on the report.
If you had Enterprise you could create the components in RAP. Probably want
to create RAP pass through functions to get at the data pipelines and
traverse the records manually from within RAP to see how many components you
need to create and to fill them with data.
Or you could create a master-detail relationship, where the detail records
would find all images and description text records for that flyer. Use
section style subreports since they always start on a new page. I think you
can get away with setting AutoStop to true on the subreport. Then each
section style subreport would have the dynamically created components in
their detail band.
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com
Bob