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!

  • Congratulations TouchToneTommy 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: *

  • Users: ij76
  • Content: Threads
  • Order by date
  1. ij76

    Sum a variable in details

    In CR v9 I have a report where I list expenses. I have groups which consist of Employee Name (gr 1) and date of expenses (gr 2). In the details I have the expense type, the expense description and a formula to apply a currency rate to the expense amount. The way I need the details to diplay...
  2. ij76

    Applying business hours, weekends and holidays

    In CR V9.0 I have a report with a whack of variables all coming a datetime field. I need a formula for the datetime values which says if the hour is between 8:00pm and 7:59am change it to the following day (I guess it is 8:00 am the same day if the hour is from midnight to 7:59 am). I then...
  3. ij76

    Select expert in chart

    In CR v9 I have a report with a chart showign the number of incidents per client per month. I used the select expert to remove any with a monthly count less than 5. It filters them out in the report, but not in the chart and I can understand why. Can anyone explain, or let me know how I can...
  4. ij76

    In Chart - Data Points running total

    I have a stacked bar chart in which I am showing the values. The values are running totals though, which I don't want, I just wnat the actual values of each section, is this possible to do, or because it's stacked having the runnign total is the only option?
  5. ij76

    Show variable from one group to another

    In Crystal v 9, I have a report where in Group#2 (which is grouped by severity) I have 6 varibles in this group, 2 for each sveerity level (high, medium and low), the two for each severity calculate the average of two other variables (open to close, and open to first). A couple of examples of...
  6. ij76

    Sorting by summary

    In Cyrstal v.9: I have a report with groups of customers. For each customer I have a summary of total hours. I would like to sort my report from highest to lowest hours, not by customer name. Of course, I can't remove the group in the sort expert and can't move the summary ahead of the group...
  7. ij76

    Summarize a formula with variables

    I am trying to get a sum of a formula which contains variables. The formula field does not show up as an option to be able to summarize. When I tried doing it mannualy, I got an error saying the filed can't be summarized. Is there a workaround?
  8. ij76

    Adding evaluateafter toa chart?

    I am trying to create a chart and in that chart is the summary of variables. When I go to my preview page I get the message "A print time formula that modifies variables in used in a chart or map". I assume I am getting this sine I have formulas with variables calculating whileafterprinting as...
  9. ij76

    Extracting Part of Name

    I need to extract parts of some project names, but can't use Left(str, length) since the number of characters to extract are different. I would need it to do somehting like this: if projectname = www then www if projectname = www/xxx, do not include from / and on if projectname = yyy then yyy...
  10. ij76

    Choosing the first line in a group

    I have groups with a few details lines of info in each (a status and date for that status). The details can be different for each group. How do I go about creating a variable that chooses the first line in the group, no matter what the status or the date?
  11. ij76

    Reset datetimevar

    How do I reset a datetimevar? It won't let me use datetimevar x:=0
  12. ij76

    More than two X axis on charts

    CR V9.2.0 Can anyone confirm that you can only have a max of 2 axis on a chart? Whenever I try to add a thrid it overides the 2nd one under "On change of
  13. ij76

    DateDiff in minutes

    While I would have thought this was an easy one, it's just not working for me... I have to find the difference in minutes between 2 datetime fields, here's an example of the info I have: In a grouped field I have statuses with datetimes for each: Open 7/12/2004 2:29:31PM Assigned...

Part and Inventory Search

Back
Top