Topic Options
Rate This Topic
#39627 - 12/31/00 04:25 AM To many joinlevels
Anonymous
Unregistered



Hi - I have one form A - serverdata,
then form
B,C,D,E,F.

Servername is key in all forms. Index on key.

Now I woulds like to create a report /crystal report with data from all
forms. (outer joins)
So, i have to create some joinforms.

To many levels ? About 300 servers in form A, 2-10 entries in the others
forms related to each server.

4.5.1 - 974
Oracle 8.1.5

I have only used 3 level joins so far

Thanks, L ars





Top
#39628 - 12/31/00 11:09 AM Re: To many joinlevels [Re: dedney]
ravi bommareddy Offline
Stealth Member

Registered: 06/12/01
Posts: 248

LarS,
Instead of tweaking forms(I think remedy doesn't allow to include more than two
forms in single step), First create a view in Database

CREATE VIEW yourviewname ( SELECT form1.col1, form2.col1, form3.col1, ..... FROM
form1, form2..... WHERE your conditions )

You can reports form this View

Thanks,
ravi





Top


Moderator:  Matt Reinfeldt