No Fields in Data Tree and Wizard using ADO

rbuser

I em evaluating the standard edition of Report Builder and it seems to be a
great product fit for our needs.

One problem I have though is that I can not use the Data Tree og the Report
Wizard. They do not show field names, so I can not select any. On a DBText
field I do get a drop down with the field names on the DataField property
though. I can also wun the report and get a report with data from my
database. But i get no field names in Data Tree and Report Wizard.

I am connection to a Microsoft SQL Database using the standard ADO
components.

Regards,

Michael

nicocizik

Hi Michael,

Thanks for your interest in ReportBuilder!

Be sure the report object is properly connected to the correct DataPipeline
using the TppReport.DataPipeline property or selecting Report | Data from
the main menu in the designer.

Is this issue confined strictly to reports created with ADO data connection?
If you create a simple test application using the BDE and the DBDEMOS
database (TTable, TDataSource, TppDBPipeline, TppReport) are you able to use
the Data Tree and Report Wizard to create reports?

--
Regards,

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

rbuser

Hi Nico,

I works fine in the Demo projects that come with Report Builder.

Could it be caused by our use of Stored Procedures? We are using the
TADOStoredProc component to connect to our database.

Regards,

Michael

nicocizik

Hi Michael,

ReportBuilder retrieves the fields and data as-is from the dataset it is
connected to. If for instance you are connected to a Stored Procedure that
has not been given a parameter, RB will see a blank dataset.

Are you using DADE? If so, there is a Stored Procedure example located in
the \RBuilder\Demos\Enduser Databases\SQL Server\Stored Proc\... directory.
This uses custom dataviews to leverage the autosearch feature to allow the
user to insert parameters from the actual report.

--
Regards,

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