Multiple grouping / sorting problem

I've got trouble with a report I'm building up that isn't sorting properly.
It's an invoice report, which displays all invoices for a given day, however, the order lines aren't grouped by invoice, they are by article type and article. Crystal however still sorts by invoice number and then applies my grouping.
This results in multiple entries for a given type if there are more than one invoice with the same type on a given day. How can I convince CR to not sort by invoice. Oh, no I'm not using a querry, I've got a dataset with all relevant information linked to CR with an XML Schema.

Here is a breakdown of it:

InvoiceDate
- Element Type
- Invoice Element
-Invoice Element Sub categories.

And this is how it displays:

7-9-2006
Accomodation
Hotel
2PK Room
Flight
Return Ticked Paris
Business Class
[ and now comes the 2nd invoice on that day ]
Accomodation
Motel
Bride Suit
Flight
Return Ticket London
Economy class

What it SHOULD be:

7-9-2006
Accomodation
Hotel
2PK Room
Motel
Bride Suit
Flight
Return Ticked Paris
Business Class
Return Ticket London
Economy class

Anybody got any ideas?
I'm using Visual basic .Net 2003 and the crystal reports editor that came with that.Right... something I forgot to mention.
This report can also be used to sort on depareture date.. which the original builder had added as a group along with invoice date, and displayed the one that he needed.. ofcourse crystal still GROUPS by this group even if it's not visible. hence my sort order got messed up.

Multiple columns full text search doesn't seems to work properly

Hi all !
I have a full text search index on a table with several fields
indexed.
I tried the following query :
SELECT MyIndexedTable.MyIndexedTableID
MyIndexedTable.Title,
KEY_TBL.RANK RANK_Total
FROM
MyIndexedTable
INNER JOIN
CONTAINSTABLE(MyIndexedTable,*,'"sport" AND "news"') AS KEY_TBL
ORDER BY KEY_TBL.RANK DESC
There are some records that are not returned by the query but they
have the words "sport" and "news" in their fields.
Any idea what could be happening?
Thanks in advance.
Xavi
This should work. Note that sports and news will have to be in the same
column to get a hit form this row.
"Xavi" <xaspas@.gmail.com> wrote in message
news:1177326871.889457.41300@.e65g2000hsc.googlegro ups.com...
> Hi all !
> I have a full text search index on a table with several fields
> indexed.
> I tried the following query :
> SELECT MyIndexedTable.MyIndexedTableID
> MyIndexedTable.Title,
> KEY_TBL.RANK RANK_Total
> FROM
> MyIndexedTable
> INNER JOIN
> CONTAINSTABLE(MyIndexedTable,*,'"sport" AND "news"') AS KEY_TBL
> ORDER BY KEY_TBL.RANK DESC
> There are some records that are not returned by the query but they
> have the words "sport" and "news" in their fields.
> Any idea what could be happening?
> Thanks in advance.
> Xavi
>
|||Exactly but I'd like to know how to make it work when words are
located in different fields.
I have read about creating an extra Text (or nText) field with all the
content in it and then create an index based on that field, I also
have seen something using unions and multiple querys on the index. I
wonder if there's any better approach and which one will give better
perfomance.
Thank you for your answer!
Xavi
On 23 abr, 14:31, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
> This should work. Note that sports and news will have to be in the same
> column to get a hit form this row.
> "Xavi" <xas...@.gmail.com> wrote in message
> news:1177326871.889457.41300@.e65g2000hsc.googlegro ups.com...
>
>
|||The concatenated column offers the best performance.
"Xavi" <xaspas@.gmail.com> wrote in message
news:1177335970.294430.289990@.p77g2000hsh.googlegr oups.com...
> Exactly but I'd like to know how to make it work when words are
> located in different fields.
> I have read about creating an extra Text (or nText) field with all the
> content in it and then create an index based on that field, I also
> have seen something using unions and multiple querys on the index. I
> wonder if there's any better approach and which one will give better
> perfomance.
> Thank you for your answer!
> Xavi
> On 23 abr, 14:31, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
>