Maybe I forgot - looking at it again:
You can either create sub-report as part of an existing report, OR you can create a subreport separately and save it. Then you can add that sub-report into another Report. This is where I forgot, that you can not literally take only a section of sub-report and place only that section in a Report within Crystal 9. You have to take the entire sub-report and place it in a report. However, you can HIDE the pieces of the subreport and place that whole sub-report into a report. This can make a large report file, as you can guess. Depending on what you are trying to place in the report, you maybe better off simply using a formula (using the Formula Explorer). Basically, I reverse engineered the existing reports from Remedy to determine how these work and use the formula to do counts. Nick ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Wednesday, December 06, 2006 2:26 PM To: [email protected] Subject: Re: Crystal report formula requirement ** Nick, My first thought was to take the subreport # and set it on the main report, but I cannot seem to get it to do that. How do I get at that field? Thanks, Susan On 12/5/06, ARSList <[EMAIL PROTECTED]> wrote: ** IIRC - you can set the subreport # as a formula. Then you can call up that count from within the subreport to your report. But I am not sure. Good luck. Nick ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Monday, December 04, 2006 3:09 PM To: [email protected] Subject: Crystal report formula requirement ** Hi Everyone, To all you Crystal report experts, I need your help. I have a report giving Help Ticket aging information by Organization. One of the fields is # of Open HTs. I have a subreport that gives the number of Sites each Organization has that are in Production. Key here is subreport. I want to add a formula field that will tell the % of Sites with Open HTs. My problem is that the # of Sites is really the subreport and I cannot get that number into a formula. I think what I want to do is 'set' that # of Sites result into the main report, an actual number, not just as a subreport so I can use it as part of the formula. Will there be a problem since the # of Open HTs is a count also, does that field need to be somehow set as a number? I appreciate any help you can provide me with. Susan ps: could claim brain freeze, we did get 14" snow last Friday. The deer were still able to find old crab apples under it! http://share.shutterfly.com/action/welcome?sid=0Abs2TRo4csmLpg Server: ARS 5.1.2 Patch 1428 OS: Windows NT 5.0 2CPU's 4G Memory Database: Oracle 9i2 User: ARS 5.1.2 Patch 1316 User OS: XP, NT, Win 2000 Admin: ARS 5.1.2 Patch 1289 Crystal that created reports: 9 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
