Question about use of TppDatadictionary component
I have a question about the use of the TppDatadictionary component in Report
Builder 7.03 for Delphi 6.
I have a simple table with address data, for which I want to substitute the
field names (and the table name) in the Report Designer.
So I followed the standard tutorial and I made two tables with aliases for
both the table name and the field names, TABLES.DB and FIELDS.DB. I filled
these two with aliases for both the table name and the field names, and I
linked these two via data sources and data pipelines to a data dictionary
component. Then I placed a TppDesigner component on the main form of my
application and I linked that to the data dictionary component. Problem is,
when I show my designer run time, I see the pipelines with aliases as they
are, i.e. the pipeline with the table alias and the pipeline with the field
aliases. I would expect to see a pipeline with the table I entered in
TABLES.DB (and with the name I entered in the field TableAlias), with the
fields I entered in FIELDS.DB (with the names I entered in the field
FieldAlias). I must be doing something wrong, but I can't find what in the
tutorial. Somehow I expect the datadictionary component to create a new
pipeline based on the info in the alias tables and show that pipeline in the
designer when linked to it, and have it be aware of the data in the
underlying address table. This doesn't seem to be how it works however.
Please help me out.
Bram Boogaard,
Eco Systems
b.boogaard@ecosystems.nl
Builder 7.03 for Delphi 6.
I have a simple table with address data, for which I want to substitute the
field names (and the table name) in the Report Designer.
So I followed the standard tutorial and I made two tables with aliases for
both the table name and the field names, TABLES.DB and FIELDS.DB. I filled
these two with aliases for both the table name and the field names, and I
linked these two via data sources and data pipelines to a data dictionary
component. Then I placed a TppDesigner component on the main form of my
application and I linked that to the data dictionary component. Problem is,
when I show my designer run time, I see the pipelines with aliases as they
are, i.e. the pipeline with the table alias and the pipeline with the field
aliases. I would expect to see a pipeline with the table I entered in
TABLES.DB (and with the name I entered in the field TableAlias), with the
fields I entered in FIELDS.DB (with the names I entered in the field
FieldAlias). I must be doing something wrong, but I can't find what in the
tutorial. Somehow I expect the datadictionary component to create a new
pipeline based on the info in the alias tables and show that pipeline in the
designer when linked to it, and have it be aware of the data in the
underlying address table. This doesn't seem to be how it works however.
Please help me out.
Bram Boogaard,
Eco Systems
b.boogaard@ecosystems.nl
This discussion has been closed.
Comments
Try running the completed tutorial:
\RBuilder\Tutorials\Complete\II. Applications\03. End-User with Data
Dictionary
The DataDictionary component is used by Query tools that are available from
the Data workspace of the Report Designer.
Set DataPipeline.Visible to False to hide the rbField and rbTable
DataPipelines from view from within the Report Designer.
To create an end-user report you first need to define a query. Select the
Data tab of the report designer and then select File | New. Choose the Query
Wizard or Query Designer. Provided you have properly configured the
Designer.DataSettings and the DataDictionary, the Query tools will show a
list of the table aliases and field aliases defined in your data dictionary
tables.
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com