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

