Migrating Report Builder to SQL Reporting Services

rbuser

Hi

I have a lot of reports written using the report builder components. The
definitions for these are all stored in a database and applied to a single
report runner object set at a time. I am hoping to migrate a lot of simple
reports (1 query, no subreports, no delphi logic required) to SQL Reporting
Services. We only want to keep complex reports in delphi and move
everything else over. This will involve pushing 500+ reports over. I am
investigating writing a script that will take the queries directly into new
code units. This step should be easy.

What I really want to do is migrate the layout - moving grouping bands,
fields, labels, lines, summaries. Report calculations and hard coded page
layouts will be ignored.

Has anyone else written any kind of migration tool?

Thanks
Amb

nardmoseley

You might also consider using RB Server Edition. You easily register all
your existing reports with RB Server. Download a trial version from our web
site and you can probably have the whole thing working in one or two days.

With RB Server you can use ClientReportExplorer and ClientReport to
browse/preview/print the reports from windows clients. And you can use the
WebTier to browse/preview/print reports from web browser clients.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com