Multiple item selection from a queried report parameter list

I am trying to mirror a report originally published through another non MS
reporting application which allows multiple selection from a query parameter
list by use of the normal Windows 'Ctrl' or 'Shift' keys in cojunction with
the mouse click.
This method does not appear to function with SQL Reporting Services. The
expanded list automatically closes on selection of one item.
Is there another method of performing multiple selection from a list.This is something which needs to be added reporting services. You can NOT do
a multi selection... About the best thing you can do is allow your user to
enter a delimited list... It's really a good option, but about the only
option right now...
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
"RW" <RW@.discussions.microsoft.com> wrote in message
news:63B4D8FB-A36B-485B-B251-9D07D810A513@.microsoft.com...
> I am trying to mirror a report originally published through another non MS
> reporting application which allows multiple selection from a query
parameter
> list by use of the normal Windows 'Ctrl' or 'Shift' keys in cojunction
with
> the mouse click.
> This method does not appear to function with SQL Reporting Services. The
> expanded list automatically closes on selection of one item.
> Is there another method of performing multiple selection from a list.

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 datasets

I have an area of my report that needs multiple data sets to be used to
populate the area. I keep getting the error "Report item expressions can only
refer to fields wtihin the current data set scope". Does anyone know how to
make the area allow me to use one data set in one row and one in data set in
the other? I have tried a table within a table, a list within a table....I
cannot find the fix to this problem. Please help!Have a look at subreports.
"KimB" <KimB@.discussions.microsoft.com> wrote in message
news:C6D864D3-BED0-48D2-BB39-C4C642A2B9C0@.microsoft.com...
> I have an area of my report that needs multiple data sets to be used to
> populate the area. I keep getting the error "Report item expressions can
only
> refer to fields wtihin the current data set scope". Does anyone know how
to
> make the area allow me to use one data set in one row and one in data set
in
> the other? I have tried a table within a table, a list within a
table....I
> cannot find the fix to this problem. Please help!|||Thank you. I will try.
"AshVsAOD" wrote:
> Have a look at subreports.
> "KimB" <KimB@.discussions.microsoft.com> wrote in message
> news:C6D864D3-BED0-48D2-BB39-C4C642A2B9C0@.microsoft.com...
> > I have an area of my report that needs multiple data sets to be used to
> > populate the area. I keep getting the error "Report item expressions can
> only
> > refer to fields wtihin the current data set scope". Does anyone know how
> to
> > make the area allow me to use one data set in one row and one in data set
> in
> > the other? I have tried a table within a table, a list within a
> table....I
> > cannot find the fix to this problem. Please help!
>
>