Home General

Data Tab empty

edited June 2010 in General
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

Comments

  • edited June 2010
    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



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited June 2010
    SessionType was set correctly, but my DatabaseName is not. What if I'm
    creating my TSQLConnection at runtime?


  • edited June 2010
    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.


  • edited June 2010
    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.



  • edited June 2010

    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



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.