Search results for query: *

I tried that, but it only puts the page numbers on the detail pages, not the 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...

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...

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...

My main purpose of using TIMESTAMP and INTERVAL is to calculate the difference between two timestamps WITH FRACTIONS OF A SECOND. If I create a view with the TIMESTAMP converted to DATE and INTERVAL converted to integer, how do I maintain the fractional seconds? Thanks so much for your help...

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...

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.

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...