Say you have two forms, parent/child relationship. So, to display children on the parent form, you just add a table list view and add a qualification to link the two tables (probably using InstanceID or RequestID). That works great. But now suppose that your client really needs the format of that list to be in a "record" style, not columnar format, like this:
name: brien phone: 111-222-3433 etc... So now the table list is out, and I need to make a report. But how exactly can I impose a qualification to join the tables AND embed the report into the Parent form? I seem to be able to do one OR the other, but not both. If I embed the report in a Data Visualization layer, I see no way to add any qualification to do the join. If I try to add qualification to the report itself (via report creator) you can't do the join since there is no way to tell it about the two forms and hence it complains about invalid field references. The other way seems to be an Active Link; Open Window. Window Type: Report. I can choose the child form, report information, and even do the join qualification... but how can I get it to open IN the parent form? I've tried fussing with Target Location but that doesn't seem to be the intended purpose. I tried giving the FV<fieldID> of a view field as the Target Location, but that didn't work and it is supposedly "web only" anyway, according to the workflow guide. My compromise thus far is to simply have a button "Open as Report" to open a new window with the report. Does anyone know if it is possible to embed this in the parent form? Thanks! Brien _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
