Multi Value Dependent report parameters help

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=343618&SiteID=17

In continuition with above thread i would to like to ask another question.

Can we make Multivalue parameters to play for cascading parameters. I am trying with different combinations of using query parameters and Report parameters.

Can any body help me?

Regards

Raj Deep.A

Hi,

I've not tried it myself, but I think it should work.

In the second (dependent) parameter, you should use the IN in the WHERE clause like:

WHERE Region IN (@.Country)

Could you give a try?

Jordi Rambla
MVP SQL Server (Reporting Services)
Certia - rambla informàtica (http://www.certia.net)
Solid Quality Learning (http://www.solidqualitylearning.com)

|||I've done this and using the in clause does work.|||

Hello heather,

I will be really glad if you can send the RDL to me. actually i was for the first parameter its working ,for the second parameter the query runs and the result values were dropped down.I can't see even check boxes and i am unable to select the appropriate value(No action) and remains senseless just like label on canvas.

If in that example ,if it was working, i am really glad and you are great

pls send it to ralapati@.smart-bridge.co.in

Thank you,

Raj Deep.A

|||

Pls reply ,how did we do that?I am waiting for your valuable reply

Thank you,

Raj Deep.A

|||

I worked on this for some time around.

It's working fine now

Thank you,

Raj Deep.A

MSSQLServer dependent service startup

Hello,
I have some services that are dependent on MSSQLServer serivce but when the
computer is restarted, my services don't start and I get an error message
"Cannot open database requrent in login 'database name'. Login fails'.
It seems like to me that these services come up before SQL Server even
though I have the dependencies set right.
Any help is appreciated.
Thanks
Shipra,
From the error it looks like the sql server is up when your application
is trying to connect. Since it will not give login failure. if the SQL Server
is not up it will give a error "could not connect or something". Is your
application by default using any id to connect to the database. It seems that
the ID doesn't have access to the default database.
Neeraj
"Shipra Gupta" wrote:

> Hello,
> I have some services that are dependent on MSSQLServer serivce but when the
> computer is restarted, my services don't start and I get an error message
> "Cannot open database requrent in login 'database name'. Login fails'.
> It seems like to me that these services come up before SQL Server even
> though I have the dependencies set right.
> Any help is appreciated.
> Thanks
>
|||Yes, that's true. But the login ID being used has all the required
permissions, I think it is a timing issue because later when I start the
services, they all start without a problem.
Thanks
"Neeraj" wrote:
[vbcol=seagreen]
> Shipra,
> From the error it looks like the sql server is up when your application
> is trying to connect. Since it will not give login failure. if the SQL Server
> is not up it will give a error "could not connect or something". Is your
> application by default using any id to connect to the database. It seems that
> the ID doesn't have access to the default database.
> Neeraj
> "Shipra Gupta" wrote:
|||Its possible that database SQL Server is up but default database is going
through the recovery. Adding a bit of delay might help. In Sybase we can
chage the order in which the databases get recovered, i don't know if we can
do the same in sql server or not. If yes then you can set it such that the
database gets recovered before any other database.
Neeraj
"Shipra Gupta" wrote:
[vbcol=seagreen]
> Yes, that's true. But the login ID being used has all the required
> permissions, I think it is a timing issue because later when I start the
> services, they all start without a problem.
> Thanks
> "Neeraj" wrote:

MSSQLServer dependent service startup

Hello,
I have some services that are dependent on MSSQLServer serivce but when the
computer is restarted, my services don't start and I get an error message
"Cannot open database requrent in login 'database name'. Login fails'.
It seems like to me that these services come up before SQL Server even
though I have the dependencies set right.
Any help is appreciated.
ThanksShipra,
From the error it looks like the sql server is up when your application
is trying to connect. Since it will not give login failure. if the SQL Serve
r
is not up it will give a error "could not connect or something". Is your
application by default using any id to connect to the database. It seems tha
t
the ID doesn't have access to the default database.
Neeraj
"Shipra Gupta" wrote:

> Hello,
> I have some services that are dependent on MSSQLServer serivce but when th
e
> computer is restarted, my services don't start and I get an error message
> "Cannot open database requrent in login 'database name'. Login fails'.
> It seems like to me that these services come up before SQL Server even
> though I have the dependencies set right.
> Any help is appreciated.
> Thanks
>|||Yes, that's true. But the login ID being used has all the required
permissions, I think it is a timing issue because later when I start the
services, they all start without a problem.
Thanks
"Neeraj" wrote:
[vbcol=seagreen]
> Shipra,
> From the error it looks like the sql server is up when your applicati
on
> is trying to connect. Since it will not give login failure. if the SQL Ser
ver
> is not up it will give a error "could not connect or something". Is your
> application by default using any id to connect to the database. It seems t
hat
> the ID doesn't have access to the default database.
> Neeraj
> "Shipra Gupta" wrote:
>|||Its possible that database SQL Server is up but default database is going
through the recovery. Adding a bit of delay might help. In Sybase we can
chage the order in which the databases get recovered, i don't know if we can
do the same in sql server or not. If yes then you can set it such that the
database gets recovered before any other database.
Neeraj
"Shipra Gupta" wrote:
[vbcol=seagreen]
> Yes, that's true. But the login ID being used has all the required
> permissions, I think it is a timing issue because later when I start the
> services, they all start without a problem.
> Thanks
> "Neeraj" wrote:
>