Search results for query: *

That was it thank you both for your time I tried the last post by synapsevampire worked perfectly Got to love Tek-Tips

Thanks for your posts I'm giving it a try now

Hi Lbass thanks for the reply I created (if isnull({INSMHI.HYCVRS}) or trim({INSMHI.HYCVRS}) = "" then 0 else tonumber({INSMHI.HYCVRS})) + (if isnull({INSMHI.HYFRAMES}) or trim({INSMHI.HYFRAMES}) = "" then 0 else tonumber({INSMHI.HYFRAMES})) + (if isnull({INSMHI.HYRINGSS}) or...

error the string is non numeric Please be patient with me I'm a novice at this crystal 8 Oracle database Each field (8 of them) below are observations for a sewer manhole inspection each one is populated by numbers I created this formula below called @Size which totals all 8 perfectly...

sum ({INSMHI.HYCVRS} + {INSMHI.HYFRAMES} + {INSMHI.HYRINGSS} + {INSMHI.HYCONES} + {INSMHI.HYWALLS} + {INSMHI.HYBENCHS} + {INSMHI.HYCHNLS} + {INSMHI.HYBASES} ) This is where I get the error saying a numeric field is needed

Crystal 8.0 oracle database I tried doing a sum of the fields but I get an error saying a number field is needed here Is there a way to make these fields numeric , if that is the problem

i have a sewer main inspection It shows 9 numeric observations ,each observation has its own table I need to add all 9 tables together and show the total only within the report anyone know the formula, I tried {1} + {2} etc to 9 and it shows all totals beside each other 201432106 it doesnt...

Thanks for the reply I'm using Crystal 8 , Oracle database

Ive created a water sprinkling report that shows all the letters handed out to taxpayers in 2004 for illegal sprinkling. My boss wants to see a chart showing a percentage of the amount of letters to amount of total water services in the city . My problem is : my report only shows the services...

lbass I'm going to nickname my first grandchild (lbass) that sql statement worked perfectly as you typed it my report is now showing the latest inspections in the sort order worst rated to best I think its time to ask my boss for a raise thankyou all for your effort and support Rod :)

hi LB I think we've broken the record for posts on this topic COMPSW TABLE is where the unitid field is INLAI TABLE is where the DATE FIELD is, and compsw and inlai are linked thru a common compkey field .There isn't a unitid field in Inlai INLAIR TABLE is where RATING FIELD is, inlair and...

Thanks for your patience ..I'm suprised you put up with me for as long as you did. I've got a lot of energy so I'll get this report workin or die tryin regardless of the outcome I did learn a few things All the best to you Rod

if there is more than 1 inspection for that unitid they are repeating there are 4500 unitids so I would like our report to show show the 4500 newest inspection/ratings right now its shows all the inspections .. the first four records are not the newest inspection , they are just the worst rated...

HI JIM says false first 4 values of the array: RW001904,RW000462,RW001906,RW001889 WHICH ARE THE FIRST 4 UNITID'S LISTED WHEN THE REPORT BUILDS ROD

Morning to add on to my last statement details and all the group footers are suppressed no drill down

Jim Yes I did group 1 "Rating" - no suppress at all group 2 "Unitid" - big formula in the conditional suppress group 3 "date" - small formula in the conditional suppress Rod

Jim I think we were talking about the same place: section expert when you open the x-2 button to the right of suppress this is where ive placed the long and short suppress formulas In crystal 8 when I open that x-2 button it opens up to an area called Format formula Editor...

Group 1 header - {table.Rating} descending (enabled with data) Group 2 Header - {table.unitId) descending (enabled with data) Group 3 header - {Table.date} descending (enabled showing the date and important information) Details - suppressed Group 3 footer - suppressed Group 2 footer -...

OOPs Jim actually all the ratings still show. What we did doesn't seem to filter out the old rating/inspections

Morning Jim Hope your weekend was a good 1 the formula I used in the Unitid group suppress was : WhilePrintingRecords; StringVar Array UsedIDS1; StringVar Array UsedIDS2; StringVar Array UsedIDS3; StringVar Array UsedIDS4; StringVar Array UsedIDS5; StringVar Array UsedIDS6; StringVar Array...