Problem w/ Crystal Reports

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.

Answer this question

Problem w/ Crystal Reports

The Eagle

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.
Justin Lee
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.
C&#35;
Have you checked in Field explorer the type of "date"
Crystal Report might not recognize the date not as "date" type but as some other types.
Jijo P Baby

Yup, it's a date type.
Joe InfoSec
i am having the opposite problem, i cant get a field to bold {w/in crystal 8.5 inside a section expert that only has color and background options} what does your code look like that produces the bold text if your formula has any format functions that are like crBold that may be where your problem is, use the crRegular to bring it back to non bold.
Problem w/ Crystal Reports

Answer this question