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"

Reply via email to