Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. omoralez

    New Intelligent Postal Barcode - OneCore

    I am not finding clear information for the acquisition of the new Postal font for Intelligent Postal Barcode. USPS is offering free downloadable solutions for MVS, Word, Excel, Windows, but I see nothing for Crystal. We can purchase Crystal. Has anyone done that and implemented?
  2. omoralez

    Sum or count the group if it qualifies

    Thank you that worked.
  3. omoralez

    Sum or count the group if it qualifies

    That will not work, I don't want a count of all of the records that have that type. I need a count of all cases that have at lease 1 of that type.
  4. omoralez

    Sum or count the group if it qualifies

    There are three types of qualifing records in a case, each record can only qualify for one of the types. I need to total the cases(group) that have that type of record. So, if the case has: 2 type 1, and 3 type 2, but no type 3, it would count 1 for type 1, 1 for type 2, and 0 for type 3. I'm...
  5. omoralez

    Change Color of Bar in Chart based on Service Persentage.

    Service level goal is 85%. Same day tickets resolved / tickets opened that day = Service level %. In the chart I need to change the color of the Resolved Bar from green to red if service level was not met. Any ideas?
  6. omoralez

    How can I show the goal 85% on a chart?

    I have two types of incidents: Restoration and Request. I need to show total records received; total resolved the same day; the percentage of the total with same day resolution; for each of these two type on the same chart. Then show that the goal is set at 85% to incidate where the goal was...
  7. omoralez

    Crosstab group name value in labels

    I need to show the group value name in the crosstab total lables. I am totaling by Department, then by Project, then by Division. I can get the Field name in the total label, but I cannot get the group value.
  8. omoralez

    No Right Trim

    I have a report where I need to display messages just as they are. This is used to proof the message that will be printed using another software. I have to merge four fields to create one line of the message, then the next four, etc. for up to six lines. The issue is that I am getting a right...
  9. omoralez

    Can you use Distinct Count without Grouping

    I need to create Global numberVar's in a subreport of the total unique ReqID's to pass to a second subreport. I don't know how to do that using a group, but I also need the distinct count which occurs by using a group option. Can anyone tell me if there is a way to do this.
  10. omoralez

    Shared Variables

    I need to pass totals from one sub report to another sub report, and I am not totaling them in the main report. Can this be done. Everything I am reading states I can pass from the main to sub, but says nothing about sub to sub.
  11. omoralez

    Difference between two dates in dd hh mm ss

    I need to calculate the difference between two dates and show the result in Days, hrs, mins, and sec. I have converted to seconds, and can calc number of days, but not sure how to subtract the remainder to calc hrs, then mins, and have final sec. The display has to be "Total DD Day(s) HH...
  12. omoralez

    Formula Parameter Array Subscript

    I need to display the parm values user selected in the Heading of a report. Using Crystal 11.5 I have parameter option for multiple values, so 1 to 4 possiblities. I need to convert the numberic value parm to alpha value equalivant in the header. I receive formula error: This array must be...
  13. omoralez

    Formula to Sum a Summary Field

    Thank you, after a few modifications I got this to work. OM
  14. omoralez

    Formula to Sum a Summary Field

    The year(s) is a user mainframe parameter selection, but most of the test data I have seen has at least three years (2005, 2006, 2007).
  15. omoralez

    Formula to Sum a Summary Field

    ...:= sum({ViewTA04.SUM_TACHANGE}, {ViewTA04.AUTH_CODE}); FAuthCount := DistinctCount ({ViewTA04.AUTH_CODE}, {ViewTA04.YEAR}); FAuthTot := FAuthTAC * FAuthCount; FAuthTot; 0101       1052.26 2999       1052.26 3006       1052.26 4528       1052.26 4712       1052.26...
  16. omoralez

    Formula to Sum a Summary Field

    I wanted to give you a good sampling of the data. I am grouping Roll, Tax Dist, Year, Auth Code. I need to sum at the GP1 Roll level and Grand Total the SUM_TaxChange. I need to only total one TAC per AUTH CODE. Plese note that the MILLAGE_12 wraps in the display...
  17. omoralez

    Formula to Sum a Summary Field

    I need to total at the Roll level not the Year. If I place the formula in the Year GF I get the correct total. If I place the formula in either group prior I still get the last occurance. OM
  18. omoralez

    Formula to Sum a Summary Field

    ...local numberVar AuthTAC := 0; local numberVar AuthCount := 0; local numberVar AuthTot := 0; AuthTAC := sum({ViewTA04.SUM_TACHANGE}, {ViewTA04.AUTH_CODE}); AuthCount := DistinctCount ({ViewTA04.AUTH_CODE}, {ViewTA04.YEAR}); AuthTot := AuthTAC * AuthCount; AuthTot; Any suggestions!!!!
  19. omoralez

    Formula for date range to check two different fields in same record

    I think we have it figured out. As you asked I was not testing for the NULLs and creating a test case for each of the occurances. If(not isnull({prc_Rpt_DailyChangeRequest_Rita;1.Actual_End_Date})) then if(date({prc_Rpt_DailyChangeRequest_Rita;1.Actual_End_Date}) in {@StartDate} to...
  20. omoralez

    Formula for date range to check two different fields in same record

    I need a formula for a date range to check two different fields the origianl change request actual end date and the task actual end date. I need to pull the record if either of these dates are within the range. using record selection I've tried...

Part and Inventory Search

Back
Top