Multiple Grouping Collpase Issue

Hi,
Im running RS2000 and here is my problem:
I have a report that basically displays a multi-grouped report that
looks like this:
WEBSITE1
--ITEM CATEGORY1
--ITEM TYPE1
--ITEM INFORMATIOn1
--ITEM INFORMATIOn2
--ITEM INFORMATIOn3
--ITEM TYPE2
--ITEM INFORMATIOn1
--ITEM INFORMATIOn2
--ITEM INFORMATIOn3
--ITEM TYPE3
--ITEM INFORMATIOn1
--ITEM INFORMATIOn2
--ITEM INFORMATIOn3
--ITEM CATEGORY2
--ITEM TYPE1
--ITEM INFORMATIOn1
--ITEM INFORMATIOn2
--ITEM INFORMATIOn3
--ITEM TYPE2
--ITEM INFORMATIOn1
etc.
Now what I have as the initial state looks like :
[+]WEBSITE1
[+]WEBSITE2
whent 1 of those are expanded it should look like this:
[ -]WEBSITE1
--[+]ITEM CATEGORY1
--[+]ITEM CATEGORY1
[+]WEBSITE2
And it expands all the way down to item information.
The problem occurs on startup, It shows website 1 and website 2 on 2
different pages.
What's worse, it shows them a few pages apart since there is "invisble"
content in the pages in between.
Is there a way to make the report on one page ONLY?
1) I know there is 1-page HTML option
2) The try to make the report on 1 page property didnt work
Is there some other way to do this?Check to make sure you do not have each group start a new page...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Sorcerdon" wrote:
> Hi,
> Im running RS2000 and here is my problem:
> I have a report that basically displays a multi-grouped report that
> looks like this:
> WEBSITE1
> --ITEM CATEGORY1
> --ITEM TYPE1
> --ITEM INFORMATIOn1
> --ITEM INFORMATIOn2
> --ITEM INFORMATIOn3
> --ITEM TYPE2
> --ITEM INFORMATIOn1
> --ITEM INFORMATIOn2
> --ITEM INFORMATIOn3
> --ITEM TYPE3
> --ITEM INFORMATIOn1
> --ITEM INFORMATIOn2
> --ITEM INFORMATIOn3
> --ITEM CATEGORY2
> --ITEM TYPE1
> --ITEM INFORMATIOn1
> --ITEM INFORMATIOn2
> --ITEM INFORMATIOn3
> --ITEM TYPE2
> --ITEM INFORMATIOn1
>
> etc.
> Now what I have as the initial state looks like :
> [+]WEBSITE1
> [+]WEBSITE2
> whent 1 of those are expanded it should look like this:
> [ -]WEBSITE1
> --[+]ITEM CATEGORY1
> --[+]ITEM CATEGORY1
> [+]WEBSITE2
> And it expands all the way down to item information.
> The problem occurs on startup, It shows website 1 and website 2 on 2
> different pages.
> What's worse, it shows them a few pages apart since there is "invisble"
> content in the pages in between.
> Is there a way to make the report on one page ONLY?
> 1) I know there is 1-page HTML option
> 2) The try to make the report on 1 page property didnt work
> Is there some other way to do this?
>|||You set a property on the report to say 1 page only. This will stop the
issue of it going on to the 3rd or 4th page.
I would have thought that the initial state of collapsed would have placed
it on 1 page though. Guess it was being intelligent and expected the user
to expand all pages.
Craig
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:4A50FC91-C429-4D25-97CC-7016A940567A@.microsoft.com...
> Check to make sure you do not have each group start a new page...
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Sorcerdon" wrote:
>> Hi,
>> Im running RS2000 and here is my problem:
>> I have a report that basically displays a multi-grouped report that
>> looks like this:
>> WEBSITE1
>> --ITEM CATEGORY1
>> --ITEM TYPE1
>> --ITEM INFORMATIOn1
>> --ITEM INFORMATIOn2
>> --ITEM INFORMATIOn3
>> --ITEM TYPE2
>> --ITEM INFORMATIOn1
>> --ITEM INFORMATIOn2
>> --ITEM INFORMATIOn3
>> --ITEM TYPE3
>> --ITEM INFORMATIOn1
>> --ITEM INFORMATIOn2
>> --ITEM INFORMATIOn3
>> --ITEM CATEGORY2
>> --ITEM TYPE1
>> --ITEM INFORMATIOn1
>> --ITEM INFORMATIOn2
>> --ITEM INFORMATIOn3
>> --ITEM TYPE2
>> --ITEM INFORMATIOn1
>>
>> etc.
>> Now what I have as the initial state looks like :
>> [+]WEBSITE1
>> [+]WEBSITE2
>> whent 1 of those are expanded it should look like this:
>> [ -]WEBSITE1
>> --[+]ITEM CATEGORY1
>> --[+]ITEM CATEGORY1
>> [+]WEBSITE2
>> And it expands all the way down to item information.
>> The problem occurs on startup, It shows website 1 and website 2 on 2
>> different pages.
>> What's worse, it shows them a few pages apart since there is "invisble"
>> content in the pages in between.
>> Is there a way to make the report on one page ONLY?
>> 1) I know there is 1-page HTML option
>> 2) The try to make the report on 1 page property didnt work
>> Is there some other way to do this?
>>

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 dataset in a single report

Let's say we have two (logical) sections within a report, one that displays a record from table_A and on the other one displays a Barchart based on the values fetched from table_B.
Could we assign seperate queries (resultset) to above mentioned situation ?
p.s. Right now, we are doing it through JOIN between tables A and B. However, we would like to not use that.If you have different, tables, matrixes, etc within a report you may assign
a different result set to each one...Just define the multiple queries, and
make the assignment in the properties of the table/matrix
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:642C9A77-A4C2-44EE-B639-AC8C31E9776A@.microsoft.com...
> Let's say we have two (logical) sections within a report, one that
displays a record from table_A and on the other one displays a Barchart
based on the values fetched from table_B.
> Could we assign seperate queries (resultset) to above mentioned situation
?
> p.s. Right now, we are doing it through JOIN between tables A and B.
However, we would like to not use that.