Groups appear out-of-sequence

[cp950]

I created a new report (CRW version 7.1) that takes in a single record-set (MS SQL view, unsorted) and prints a summary (summarising transactions by COUNTRY within DATE).

I set the details up for the records and suppressed it. The Date and the Country fields ARE in the suppressed detail. I set the major group as DATE (as type datetime) and the minor group as COUNTRY (as type text). COUNTRY has no headers (suppressed), and the footers show the detail-totals. DATE has Headers and footers.

My problem? The dates are NOT in order! I get 2004, 1995, 2001, 2002, 1997... How do I get the dates in sequeance (and I'll take ASC or DESC!)? Note that me countries ARE in the correct sequence... I look at the grouping, and its listed lkike this : "{view-name}.GrantDate - A" and that looks right.

My thanks in advance...

 

[synapsevampire]

That is odd...the only thing I can think of is that someone has used the Specified Order for the group, or it's grouped by the string equivalent.

Right click the Group and select Change Group and make sure that it's set to In Ascending Order, and for each day.

-k

 

[Turkbear]

Hi,
Is the GrantDate in your view actually a DATE type or is it a string?


If a string, you would get the behavior you indicated..

 

[cp950]

Ms. Vampire : (like the ID! )

I checked, and they are set that way. I also checked keep-together and repeat-on-new-page. No difference.

Spooky, no?

 

[cp950]

Turk:

No, its a SQL datetime. I figured if it was a text I'd see the date in month and date order, but nope!. I can determine NO form of order -- not even DAY (Fri, Mon, SAt, Sun...)

 

[cp950]

Found it on the 10th search of Seagate's support system!
1) Delete the group
2) Re-Insert the group
It now sorts correctly.

I don't get the logic of it, but it DID work...