I am using Crystal XI to report on a SQL 2000 table with the following properties...
Column Datatype Length Allow Nulls
mb_id bigint 8 FALSE
activity_date datetime 8 FALSE
media_provider varchar 20 TRUE
raw_impressions bigint 8 TRUE
raw_clicks int 4 TRUE
impressions bigint 8 TRUE
clicks int 4 TRUE
I then just display all fields in a single details section and insert a group using the activity_date field. Taking a record with activity_date = 9/1/2001, as an example, this records falls under a group name = 8/26/2001 along with other records showing activity_date = 9/1/2001.
There are no linked tables with the report also. I was just starting in on a project when I came across this. I have never seen the group value be different from the record values which fall within the group. Any ideas???? Thanks in advance for any help.
Column Datatype Length Allow Nulls
mb_id bigint 8 FALSE
activity_date datetime 8 FALSE
media_provider varchar 20 TRUE
raw_impressions bigint 8 TRUE
raw_clicks int 4 TRUE
impressions bigint 8 TRUE
clicks int 4 TRUE
I then just display all fields in a single details section and insert a group using the activity_date field. Taking a record with activity_date = 9/1/2001, as an example, this records falls under a group name = 8/26/2001 along with other records showing activity_date = 9/1/2001.
There are no linked tables with the report also. I was just starting in on a project when I came across this. I have never seen the group value be different from the record values which fall within the group. Any ideas???? Thanks in advance for any help.