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 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: cswords
  • Content: Threads
  • Order by date
  1. cswords

    Display Page Number in multiple report headers

    I want to display the page number at the bottom of each page for EVERY page of my report, including all report headers. I have multiple "report header" sections (each containing a separte bar chart analyzing the detail data in slightly different ways). I have the page number displayed in the...
  2. cswords

    Minimum/Maximum/Median/Average Count

    This is probably simple to do, but I'm having problems! I have a report which displays the number of detail records in the group footer (using a running total). Now, in the report header, I want to display the overall minimum / maximum / median and average count of details records. For...
  3. cswords

    How create a left outer join?

    I am trying to display a report showing the number of transactions processed per time interval (i.e. hour, 1/2 hour, 15 minutes). The report must show ALL intervals, even if there are no transactions processed during that time interval. My data table has the transaction id/processing time, as...
  4. cswords

    Convert INTERVAL with milliseconds to an integer

    I need to calculate the time in milliseconds between two events and then display the results in Crystal Reports. The obvious solution is to use datatype TIMESTAMP and INTERVAL; however, Crystal Reports does not support either type. So, I was thinking that I would create a view with the...
  5. cswords

    Support for Oracle 9i TIMESTAMP and INTERVAL types

    Does Crystal Reports 8.5 support the following Oralce 9i datatypes: TIMESTAMP INTERVAL DAY TO SECOND I have an Oracle database table which contains data of this type, but when I display the data in a Crystal report, the field is blank.
  6. cswords

    Difference between two times WITH MILLISECONDS

    I have an Oracle database which contains a start time and end time (oracle datatype TIMESTAMP). These times contain milliseconds (i.e. HH:MI:SS.SS). How do I calculate the difference between these two times INCLUDING MILLISECONDS? I know that DateDiff ("S", startTime, endTime) will return...

Part and Inventory Search

Back
Top