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 and blank pages

I have a report with 2 types of grouping. The first is monthly and the second is basically a grand total. I want to have the report with 1 page per month with the grand total on the last page. Everything is in one table object, with two groups in the table footer.

The problem that I have is that if I put "Page Break After" on my Monthly grouping the total is going to end up on a different page at the end. If I put "Page Break Before" I get a blank page at the start. Anyone got a idea of how to get myself out of this?

Make sure the table starts from the top of the report, i.e. don't leave any empty space before the table. Then you shouldn't get the blank page.

We are working on improving this (adding a "page break between" feature) for the future releases.

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.