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 Westi 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: er123
  • Order by date
  1. er123

    Group number with multiple groups

    I have a report that has two groups. I would like to get the total number of groups in Group 2 under each group of Group 1. I know there is a Group Number field in the special fields but that will only give me the group number of Group 2 for the whole report. To clarify assuming Group 1=A and...
  2. er123

    Print section twice

    Yeah that is what I want to do, I was just wondering if there is a shortcut for copying it all, but I have been pointed to the copy all objects feature so I think I am good.
  3. er123

    Print section twice

    Is there a way for Crystal Reports to always print a particular section of a report twice? Is there a formatting formula for this? Thanks in advance for any help.
  4. er123

    Date Range based on print date

    What would be the formula for a date range that references the most recent 7am-7am period from the print date?
  5. er123

    Sum in Two Groups

    I have a report that involves 2 groups, a department (Group #1) and sub-department (Group #2). I have a sum for each subdepartment and I then went to get a sum for all of those sums which is the sum for the entire department. I would like to put this sum in the Group #1 footer. But CR in either...
  6. er123

    Group sum with condition

    I would like to get a sum for a field by group with a condition for filtering the field (when the field = x). How does one create a formula for a sum with a condition?
  7. er123

    Year to date of epoch time

    I am doing a report where I would like to select records year to date. My difficulty is that the date field is in epoch time from 1/1/1990. What would be the formula for this record selection? I know I could use yeartodate and dateadd but am having trouble pinning it down. Thank you.
  8. er123

    Calculate range of an event based on date

    Yes I would use a start and end parameter. Hugely helpful! Thanks very much!
  9. er123

    Calculate range of an event based on date

    I am writing a report that is meant to display how many hours in a particular date range a machine is running. Each time the machine is turned on it creates a new event in the db with a start time field and end time field. These times are in seconds in epoch form from 1/1/1990. I have discovered...

Part and Inventory Search

Back
Top