Lost link problem (adding and order by a calculated field)

rbuser

Hi all,

We noticed this problem editing a report in the data view.
In RB 7.03 end-user report, try to put two (or more) dataset linked in
master-detail relationship.
Let's say that you have a calculated field in the master dataset.
Now suppose that, after you have defined your report with all links in
in it, you return to the data view window to add an "order by
calculated field" to the master dataset.
After confirm you will see:
1. The link lines between dataset disappear BUT
2. If you go into the detail dataset to see the link properties you
still will see the link expression but they are all messed up (field
names changed in random(?) order and so on)

Does anyone notice the same behaviour ?

Thanks in advance, as always..

Bye
Nicola

nardmoseley

There are some limitations of the DataView linking feature when calculated
fields are added to a dataview.

The DataView linking requres the detail dataview to be ordered on the same
fields as the master dataview. RB does this by augmenting the detail
dataview SQL with a join to the master. But it will not be able to do this
for a calculated field in the master.



--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Are there any workaround ?
We are thinking about including our calculated field in a sql view and
then include this view in the dictionary (in order to let rb see the
field as a "standard" field)
But generally it would be a nice feature not being forced to do this
way.....

nardmoseley

You would need to programmatically create the datapipeline masterfield
links.

http://www.digital-metaphors.com/tips/LinkDADEPipelines.zip

--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com