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?
>>