End user reporting on read-only database, possible?

rbuser

I need to create an end-user reporting solution, much like the example in
"Delphi7\RBuilder\Demos\4. EndUser Databases\InterBase\4. IB Objects", but
the database I need to query data from is accessed via a read-only ODBC
connection. Can I split out the 5 RB tables (rb_folder, rb_item, rb_table,
rb_field, rb_join) into a separate database with r/w capability (Firebird),
but have the reports query data from a read-only source (SQL Server)?

I'm using Delphi 7, Reportbuilder 7.04, IBObjects to access my Firebird
databases (r/w), and ADO objects to access the SQL Server data (r/o). I
hope there is a method for accomplishing this, and I appreciate any help
finding it.

Chas Randal

nicocizik

Hi Chas,

It is definitely possible to create an end user application that stores it's
report templates on one database, yet accesses data from another. I would
suggest first getting the end user section built and working with your
Interbase database, then creating a couple templates that access your SQL
Server data to test with.

--
Regards,

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

rbuser

Thanks, Nico, but how do I accomplish this? I have already created numerous
end-user reporting apps, but in each case the RB tables are in the DB I'm
reporting from (all using Firebird). How do I modify one of these to access
the SQL server data for the reports? Do I create an ADO connection and put
it in the Data Dictionary component's "BuilderSettings"? Does it need to be
set anywhere else? Thanks for your help.

Regards,
Chas

nicocizik

Hi Chris,

If you look at the end-user demos, you will need to separate the database
connections of the designer (which will be connected to your ADO connection)
and the Explorer and DataDictionary (which will be connected to your
Firebird tables). The explorer handles the saveing and retrieving of
reports and the designer, including DADE, needs to access the actual data
you need to create reports.

--
Regards,

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