I am trying to create some reports in VB.NET 2005 using the Crystal Reports designer. My problem is whenever I do a report off a particular table it is not grouping correctly. I'm trying to group off a field Called EffectiveDate. What happends in my case is the date 5/7/2006 shows up in bold as the start of a group then all the dates are shown below. The problem is there is no 5/72006 in the database and the report is not grouping by the actual dates. I've tried making a formula field out of the date and it does the same thing. Other reports grouped by dates are fine.
Problem w/ Crystal Reports
CMOYA
Chuck W.
Yup, it's a date type.
Euge GIm
Try printing the field you group by in your details rows and temporarly delete the grouping. Is the field as you expect ist If yes, it should group correctly. I had often problems the field was not correct, but you can find this as described best.
Hope this helps.
mdorison
The fields print fine whether I delete the group or not. The dates may all be someting like 5/10/2006. 5/10/2006, 5/11/2006, etc with dates from the 10th to the 15th but the group will print 5/7/2006. a date that does not exist. I tried several reports and this table will not work. I ended up creating a user defined variable and pulled the date apart and made it into a string. That seemed to work.
There has to be a bug somehwere, I even took a report from ,NET 2003 that works fine for the same table, imported it into my 2005 project and it prints wrong.
mothballd
Crystal Report might not recognize the date not as "date" type but as some other types.