Run-time report building question

rbuser

Is it possible to dynamically build a report at runtime? We have a database
structure that can change from client to client, so setting up statically
assigned fields won't work. What I am thinking about doing is using a
two-pipeline system that will open up the first pipeline, read in the list
of fields for a particular institution, and then inside the report build the
fields and header information based on the contents. After this, it would
open the second pipeline and read in the data to actually output the report.
Is this possible? Are there any examples I might be able to look at to see
how to do this properly?

Thanks

Tom

nicocizik

Hi Tom,

Yes it is possible to create reports completely in code as you describe.
There are complete examples of doing so in the ReportBuilder Developer's
Guide as well as some good articles in the Code Based thread of the
Tech-Tips newsgroup.

Also, take a look at the following example of creating fields dynamically
based on the current data. As in the example, there should be no need to
use two pipelines. You can gather information about a dataset and access
its data using a single pipeline.

http://www.digital-metaphors.com/tips/DynamicFields.zip

--
Regards,

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

rbuser

I'll give that a look. Thanks for the help.

Tom