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___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
