Data Tab empty

rbuser

We recently upgraded to RB 11 (from 7 I think). Reports previously created
with RB 7 have the data tab where I can modify filters, order bys, etc. If
I create a new report using the Report Wizard the data tab is there but
empty.

My Delphi 7 app is setup as follows:

1) TppReportExplorer -> TppDesigner -> TppReport
2) We have a Folder and Item TppDBPipeline (stored in a firebird database)
3) No data dictionary, just a TppDBPipeline to our (firebird) database
4) daDatMan, daIDE, daDBExpress are in my uses

Why do existing reports have a working data tab but new reports have a blank
one? Any pointers would be greatly appreciated...

Daniel

nardmoseley

Check that Designer.DataSettings.SessionStype is set to DBExpressSession.
And that the Designer.DataSettings.DatabaseName is configured to reference
you SQLConnection.


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

rbuser

SessionType was set correctly, but my DatabaseName is not. What if I'm
creating my TSQLConnection at runtime?

rbuser

I dropped a TSQLConnection on the main form and use that instead of creating
one on the fly and connect it to Designer.DataSettings.DatabaseName (=
SQLConnection1).
Create new Report, run the Report Wizard, I can see the data on the preview
tab but my Data tab is still empty. Strange that existing reports have the
window to edit calcs, filters, groups etc...

So basically I've verified those two settings and still no luck.

rbuser

To replicate the behavior I'm getting, I modified the
"\RBuilder\demos\Demos\3. EndUser\1. Report Explorer" demo as follows:

1) Cleared property: ppDesigner1.DataSettings.DataDictionary
2) Set property to false: ppDesigner1.DataSettings.UseDataDictionary
3) Added a TTable, TDataSource, TppBDEPipeline connected to
DBDemos.BioLife.db
4) (Optional) Set the ppReport1.DataPipeLine to the new TppBDEPipeline

and I get the same behavior. Existing reports have a working Data tab, new
reports have an empty Data tab.

nardmoseley

I re-read your question and additional posts.

To create a query, access the Data workspace and select File | New..., then
use the Query Wizard or Query Designer to specify the query.

At Delphi design-time, the ppReport1.DataPipeline should be nil as shown in
our end-user report explorer demo. Run the demo, create a new report. Next
access the Data workspace and select File | New... to create a query. Now
access the Design workspace and use the report wizard or other layout tools.

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