Search results for query: *

so i did a crosstab: here are my fields [Inspections_and_Tests.InspectionsTests~InspectionDate]{Inspections_and_Tests.InspectionsTests~MaterialCode}{Inspections_and_Tests.InspectionsTests~Status} [Inspections_and_Tests.InspectionsTests~Udf_Failed] @sys.#failed = TONUMBER...

ANYONE ELSE THAT CAN ASSIST ME WITH THIS PLEASE!!!

Also is there any way to display the summary of the grouping Type vertically? month Structures Permit jan 10 20

Thanks It worked! however what my peers actually need is to hardcode these entries, so in the inspections table i created one field for each month (QTY Jan), etc My problem is how to tide each field with my Date Group which is displayed monthly) in my Date group footer i'm showing the...

Is grouped first by type then by inspection date the amount of activities will inputed by users per month one part of the report needs to show the totoal for each schd activities per month: Month SchdAct SchInps Actual Jan-11 202 78 55 the next part will show by results by type...

I have a report that shows a summary of inspections performed, this reports has two groupa date and type i.e: structures and permit, in each group footer i show the total by type and how many failed or passed and the failed % in last 2 weeks or last 5 days. now i'm task to create a report that...

There are 18 records in my database - i want this formula to be evaluated only in one record at time - in other words i don't want to evaluate ({Issues.IssueItems~Date} with ({Issues.IssueItems~Date} from the previous record but to evaluate ({Issues.IssueItems~Date} for same record but previous row

Also how do you get the average of a sum? I if Sum ({@sys.PossiblePoints}, {Inspections_and_Tests.InspectionsTests~InspectionNumber})=0 then 0 else (Sum ({@sys.AwardedPoints}, {Inspections_and_Tests.InspectionsTests~InspectionNumber})/ Sum ({@sys.PossiblePoints}...

I'm new at using crystal reports and i'm trying to find out a simple way to do the following report that will group the category and give me a average for month and YTD and also average and percentage for both: MANY THANKS! Categories: Circle, Square, Triangle Category Circle...

Ian, Thanks for your quick response, what i need is that the formula to run ONLY in ONE record at time not the previous one, I'm using 'previous" to be able to use datediff in the same column - perhaps i need to use or add something else?? Thanks again!

I am new to Crystal Reports and trying to use "Datediff" in the same column, so I's using "Previous" as well but I need this formula to run only for the current record not the previous one. How can i make this work? Here is the syntax I'm using: (DateDiff("d",{Issues.IssueItems~Date}...