Can I somehow create Master-Detail relationship between manually edited SQLs for subreports?

rbuser

Well, I certainly realize that I must be annoying with those "manually
edited SQL" questions but I really need this one so please answer it and I
hope it is going to be the last one on such theme.

I 'm going to give to end-user an ability to edit SQLs and work with
subreports as they would normally do. But as I saw it - the moment SQL is
edited user cannot establish Master-Detail relationship anymore. Can I
somehow create those relationships myself through some coding?

Thanks in advance,
Moisey Blehman

digitalmetaphors

Once you edit the SQL text, it doesn't support visual dataview linking.

You'll have to edit the detail dataviews to be ordered by the linking field
and any of the master's order by's and criteria through a join in the detail
dataview. Then you can perform data pipeline linking in code. Here is an
example:

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


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Thanks - it is exactly what I need.