Group Header displays wrong data 1

[RenaG]

I am working in Crystal 10.

I created a report that contains a pat_id, create_dt, observation_desc, etc. I group the report by pat_id and then by create_dt. The detail of the report shows that the create_dt is 9/15/2011 but in the group header is says 9/11/2011. Why is that? If I drag the create_dt from the detail section to the group header it is correct.

TIA,
~RLG

 

[lbass]

I wonder if there are multiple create dates per Pat_id at times. Why don't you show a sample of your results here and indicate the report section in which they are located. Please show samples for a couple of patients and include detail level data.If you are using more than one table, be sure to identify the fields this way: {table.field}.

-LB

 

[RenaG]

Hi LB,

I'm not exactly sure what you are asking for but I have attached (or tried to attach) the report. Right now, it only looks as a specific patient. If I have not sent what you are needing, please let me know!

Warm regards,
~RLG

 

[lbass]

No, your link doesn't work, as I don't have access to your computer. I was only asking for mock data--across a couple of patients that shows what you are seeing, including for the group header #1, group header #2, and details section. Just show the relevant fields--patient ID and create date and identify the report sections.

-LB

 

[RenaG]

Hi LB,

Sorry for being so dense. I wondered how that was going to work but thought it was worth a shot!

I hope this is what you are asking for:

(page header) Type             Obd_ID        CreateDT          Label           Description
(group Head 1) {Observe.Pat_ID} 31257
(group Head 2) {ObsReq.CreateDt}9/11/2011
(detail)     {obsdef.type} {obsdef.Obd_ID}  {ObsReq.CreateDt} {ObsDef_1.Label} {ObsDef_1.Desc}
                12             23307          9/15/2011         23272         Communication Type
                               23308          9/15/2011         23273         Communication With
(group Head 2) {ObsReq.CreateDt}9/25/2011
(detail)     {obsdef.type} {obsdef.Obd_ID}  {ObsReq.CreateDt} {ObsDef_1.Label} {ObsDef_1.Desc}
                12             23309          9/27/2011         23283         Reason For Referral
                               23310          9/27/2011         11329         Referral Source

So the value for CreateDt shown in the Head2 line doesn't show the same as in the detail.

TIA,
~RLG

 

[lbass]

I think I know what happened--and I should have thought of this earlier. When you inserted the group on date, you probably allowed the default interval, which would be on change of "week". This would result in the groupname showing the date for the Sunday of the week containing the create date. Just go into report->group expert->createdate group and change the "on change of" to "day".

-LB

 

[RenaG]

Oh brother!!! I've been bit by that little bugger before. It's been a while so I forgot about it. Thanks for pointing me in the right direction.

Cheers!
~RLG