Crystal Report 9 is displaying only the 1st record if records vary only by millisecond
I am using SQL Sever 2005, VC 6 ++ and Crsystal Report API to print a report in a child window.
If the records vary Only by Milliseconds, Crystal Report is showing only the 1st record. Otherwise, it is perfectly fine.
I am picking the timestamp from SQL Server DateTime Field.
In Formula inside Crystal Report, i am only giving the following expression TableName.Ti开发者_如何转开发mestampField.
The Field format for Timestamp field is mm/dd/yyyy hh:mm:ss (in 24 hrs)
Can you please tell what change i need to make to get all records displayed?
Note:- If I run the same sql query that i give to Crystal Report in Sql Server, It gives me all records.
New ---- Edited after posting the question.....
I want to make change in Crystal Report. Actaull, the records inside Cystal Report are being supprested based on the following formala:
if not PreviousIsNull ({Table.TimeStamp}) then
if {TABLE.TimeStamp} = Previous ({TABLE.TimeStamp})
and {TABLE.Object_Id} = Previous ({TABLE.Object_Id}) then
true
Somehow, Cystal Report is comparing Timestamp field only till Seconds.
Can now you tell me how to force Crystal Report to consider Milliseconds while doing comparison? b/w Timestamps?
Thanks
SQL Server 2005's DateTime
datatype has a granularity of approximately 3.3 milliseconds.
精彩评论