Data Dictionary and Report Designer

rbuser

I have setup the RB_TABLE and RB_FIELD tables for data dictionary functionality.

I would like to provide the SQL to the Report Designer separately to the Data section of the designer, i.e. set the
Report.DataPipeLine to a query created outside the Designer.

I had hoped the Data Dictionary would translate field names in the designer but it doesn't. If I 'design' a query inside the
designer the Dictionary works nicely.

Is this not a function of the Dictionary or have I done something wrong?

TIA.

nardmoseley

The DataDictionary is used by the RB Query tools to display the available
table and field aliases. When the query is created, the DataDictionary is
used to populate the
DataPipeline.Fields[ ].FieldAlias values.

When using external datapipelines, you will need to either write some code
or use the datapipeline Fields Editor to manually enter the FieldAlias
property values at design-time. In either case, you will want to set
DataPipeline.AutoCreateFields to false so that the datapipe fields will not
be re-created each time the query is opened.




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

rbuser

Hello Nard.

I'm fiddling with the Data Dictionary and the Report Designer and I got
a similar problem.

What do you mean by external datapipelines ?

Here, I have populated the RB_Field and RB_Table for the Data
dictionary, but when I open the Report Designer, all the fields in the
Data tree aren't renamed.

Do I must design a query in the Report Designer to use the Data
Dictionary or the query attached to a datapipeline is enough ?

If not, maybe adding a DataDictionary to the datapipeline would be great
to create the alias when the datapipeline create it's fields.

Thanks

JFPicard

nicocizik

Hi Jean-Francois,

The Data Dictionary is designed to be used when datasets are created in the
data workspace (DADE) of ReportBuilder only. When you create a query in
DADE, a pipeline is created internally to manage the flow of data. By
"external pipelines" we are referring to the pipeline components you place
on a form.

If you are using external pipelines you will need to manually assign the
FieldAliases of each field using the field editor or in code as Nard
mentioned in the second section of his post.

--
Regards,

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