Crystal and Remedy Native seem to be the same for this case. Indeed it would use the same Active Link with just one setting change (Report Type=Crystal). In any case, I should be able to display any report in a View Field using an Active Link-->Open Window-->Report, which is what I think you are suggesting. The documentation states that I can use the frame ID of the View Field, which is VF536870957 in my case. This is web-only so not really a total solution, but at least "something".
However, if I put VF536870957 in the Target Location box, the report should open in that frame when I trigger the AL. However, it insists on popping up a new window (tried IE and FF). Initially it looks like a bug. AR System 7.1 Patch 003 Windows 2003, SQL 2005. Thanks again for everyone's help. This should be resolved assuming I can get the behavior to work as documented. Brien On Wed, Sep 3, 2008 at 2:08 PM, LJ Longwing <[EMAIL PROTECTED]> wrote: > ** What about a crystal report, with a crystal web server, and a view > field that you use to display the report in....would that do what you want? > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Brien Dieterle > *Sent:* Wednesday, September 03, 2008 2:39 PM > > *To:* [email protected] > *Subject:* Re: embedded report puzzler > > ** I understand this (I've actually use this before), but my point is that > when I have the Parent Request open in Remedy, I see all the information for > the Parent Request (who submitted it, etc). I don't need this information > displayed yet again in a Crystal report-- I just want the Child Ticket(s) > information displayed somewhere. Whether that is in a Remedy Report or a > Crystal Report doesn't matter so much as where that report is ultimately > displayed. I just want it embedded in the Parent Request and not a new > window :-) > Basically, exactly, in every sense, like a Table- List View, but with a > different format :-) > > Thanks!! > > Brien > > On Wed, Sep 3, 2008 at 1:31 PM, Benedetto Cantatore < > [EMAIL PROTECTED]> wrote: > >> ** Brien, >> >> I know for a fact Crystal can absolutely show parent/child >> relationships. I use Crystal to show Changes with associated Tasks. Per the >> last reply, use a subreport. >> >> Ben Cantatore >> Remedy Manager >> (914) 457-6209 >> >> Emerging Health IT >> 3 Odell Plaza >> Yonkers, New York 10701 >> >> >> >>> [EMAIL PROTECTED] 09/03/08 4:22 PM >>> >> ** I maybe missing something but what about Crystal & sub reports? >> >> The sub report would look at the 2nd form as if you were going to put a >> table on the screen. >> >> -----Original Message----- >> *From:* Action Request System discussion list(ARSList) [mailto: >> [EMAIL PROTECTED] Behalf Of *Brien Dieterle >> *Sent:* Wednesday, September 03, 2008 1:10 PM >> *To:* [email protected] >> *Subject:* Re: embedded report puzzler >> >> ** I don't know if a Join form would work, since this is a one-to-many >> relationship (one parent with many children). I tried to express that with >> the two records in my report-sample below (it could be any number). Since >> this is web based I definitely don't want to use Excel or Access. I'm not >> sure if Crystal would help either unless I can pass the join qualification >> to the Crystal report, which would seem to be the same missing feature that >> I am lacking with the regular Remedy Report. >> It looks like we'll survive with the "Open as Report" button on the parent >> form, that launches an Open Window activelink to open the report with a >> specific qualification to perform the join operation. Again, not embedded, >> but better than nothing :-) >> >> Thanks again, >> >> Brien >> >> On Wed, Sep 3, 2008 at 12:56 PM, Benedetto Cantatore < >> [EMAIL PROTECTED]> wrote: >> >>> ** Brien, >>> >>> I may not have a good handle on what you're asking, but I think the >>> solution is as simple as creating a join form. Then do your report off of >>> that form. The basic reporting has no ability to create joins, but that can >>> be done when you create the join form. Alternately, I'd advise trying >>> another product like Excel, Access, Crystal, or other reporting tool to get >>> the desired report. >>> >>> Ben Cantatore >>> Remedy Manager >>> (914) 457-6209 >>> >>> Emerging Health IT >>> 3 Odell Plaza >>> Yonkers, New York 10701 >>> >>> >>> >>> [EMAIL PROTECTED] 09/03/08 2:04 PM >>> >>> ** >>> Thanks Ben, I am using the Native remedy reporting using the >>> server-side reporting forms (ReportCreator). I'm not actually trying to >>> show the parent/child relationship on the report, but just a >>> qualification enforced on the report to show just the children (maybe that >>> is the same thing). It seems like what I need is small feature request on >>> the data visualization page to allow a qualification to be passed to the >>> report just as you would during an active link open window event. >>> Basically it is a form for transferring funds from one account to >>> another. You can have multiple transfers within one request. >>> >>> Request: 001 >>> Submitter: user01 >>> >>> *report starts here (showing child-info) >>> Account from: xxx >>> Account to: yyy >>> Amount: zzz >>> -------------------------------- >>> Account from: aaa >>> Account to: bbb >>> Amount: ccc >>> *report ends here >>> >>> Status: Completed >>> Assigned To: Agent01 >>> >>> >>> >>> That is the desired output format, generally speaking. >>> >>> Thanks for any help! >>> >>> Brien >>> >>> >>> >>> On Wed, Sep 3, 2008 at 10:30 AM, Benedetto Cantatore < >>> [EMAIL PROTECTED]> wrote: >>> >>>> ** Brien, >>>> >>>> I'm not sure if I understand what you're trying to do exactly. First >>>> off, before you shut down on the idea of displaying the data on the form, >>>> what exactly is the desired output? Give examples of the data in the two >>>> separate form, and then explain how you want to ideally display it. I know >>>> there are some very creative individuals on this list that might be able to >>>> help. >>>> >>>> Regarding reporting, its not clear if you're talking about Remedy's >>>> native reporting function or Crystal's. Remedy's native reporting >>>> functionality is very limited. If you want to show a parent/child >>>> relationship, you'll have to either use Excel/Access or Crystal to pull >>>> that >>>> off. >>>> >>>> Ben Cantatore >>>> Remedy Manager >>>> (914) 457-6209 >>>> >>>> Emerging Health IT >>>> 3 Odell Plaza >>>> Yonkers, New York 10701 >>>> >>>> >>>> >>> [EMAIL PROTECTED] 09/03/08 12:58 PM >>> >>>> ** >>>> 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 >>>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >>>> html___ >>>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >>>> html___ >>> >>> >>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >>> html___ >>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >>> html___ >>> >> >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> html___ >> >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> html___ >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> html___ >> > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
