Re: embedded report puzzler

2008-09-03 Thread Brien Dieterle
ion Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Brien Dieterle > *Sent:* Wednesday, September 03, 2008 2:39 PM > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: embedded report puzzler > > ** I understand this (I've actually use this be

Re: embedded report puzzler

2008-09-03 Thread LJ Longwing
2:39 PM To: arslist@ARSLIST.ORG 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 i

Re: embedded report puzzler

2008-09-03 Thread Brien Dieterle
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 Di

Re: embedded report puzzler

2008-09-03 Thread Brien Dieterle
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:* arslist@ARSLIST.ORG > *Subject:*

Re: embedded report puzzler

2008-09-03 Thread Benedetto Cantatore
ailto:[EMAIL PROTECTED] Behalf Of Brien Dieterle Sent: Wednesday, September 03, 2008 1:10 PM To: arslist@ARSLIST.ORG 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

Re: embedded report puzzler

2008-09-03 Thread Pargeter, Christie :CO IS
Sent: Wednesday, September 03, 2008 1:10 PM To: arslist@ARSLIST.ORG 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

Re: embedded report puzzler

2008-09-03 Thread Brien Dieterle
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

Re: embedded report puzzler

2008-09-03 Thread Benedetto Cantatore
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

Re: embedded report puzzler

2008-09-03 Thread Brien Dieterle
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 seem

Re: embedded report puzzler

2008-09-03 Thread Benedetto Cantatore
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 k

embedded report puzzler

2008-09-03 Thread Brien Dieterle
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 tha