Parameter dropdown width

How do I adjust the reporting parameter dropdown width? the dropdown is
populated from a dataset and the width of the values exceed the width of the
drop down
thanks
--
Message posted via http://www.sqlmonster.comI am also looking for the similar solution. Please respond ,if it is possible
to adjust the drop down parameter list width. Would it be possible after SP2.
I hope somebody from Reporting Services team would help us here.
Regards
Vijay
"Angie via SQLMonster.com" wrote:
> How do I adjust the reporting parameter dropdown width? the dropdown is
> populated from a dataset and the width of the values exceed the width of the
> drop down
> thanks
>
> --
> Message posted via http://www.sqlmonster.com
>|||There is no way to do this that I know of. That sort of fine tuning of the
Report Manager UI is not possible. I don't know about RS 2005 but I for RS
2000 SP2 this is not possible. You would need to create your own web page
and then integrate via either URL or webservices.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vijay Tripathi" <VijayTripathi@.discussions.microsoft.com> wrote in message
news:49AAE0A4-A32E-41CC-A821-F81BBEDDD501@.microsoft.com...
>I am also looking for the similar solution. Please respond ,if it is
>possible
> to adjust the drop down parameter list width. Would it be possible after
> SP2.
> I hope somebody from Reporting Services team would help us here.
> Regards
> Vijay
> "Angie via SQLMonster.com" wrote:
>> How do I adjust the reporting parameter dropdown width? the dropdown is
>> populated from a dataset and the width of the values exceed the width of
>> the
>> drop down
>> thanks
>>
>> --
>> Message posted via http://www.sqlmonster.com

parameter

Hi,
I have created several parameters in my report.
These parameters are drop down controls which are populated from stored
procedures.
How is it possible to populate one of these parameters based on the
selection on another parameter drop down control?
ThanksOn May 29, 9:03 am, farshad <fars...@.discussions.microsoft.com> wrote:
> Hi,
> I have created several parameters in my report.
> These parameters are drop down controls which are populated from stored
> procedures.
> How is it possible to populate one of these parameters based on the
> selection on another parameter drop down control?
> Thanks
Yes it is. I'll give you a quick example and you can base your report
of it hopefully:
DataSet1 {This is your main dataset}
Select *
from cars_inventory
where make=@.make and model=@.model {here are you two parameter filters}
DataSet2
select distinct make
from cars_inventory
DataSet3
select distinct model
from cars_inventory
where make=@.make
Make sure in your main dataset that @.make comes first in the where
clause otherwise you will run into problems. Under the menu
Report>Report Parameters go to configure your parameters. Make both
of them queried (@.make from dataset2 and @.model from dataset3). That
should work. When you preview, model will be grayed out until you
select a make, then it will only pull back makes based on that model.
So for example you select Toyota for make, then under the model drop
down you will get a list {Camry, Corolla, etc}. If you select Nissan
you'll get a different list {Altima, Maxima, etc}.
I hope that helps.

parameter

Hi,
I have created several parameters in my report.
These parameters are drop down controls which are populated from stored procedures.
How is it possible to populate one of these parameters based on the selection on another parameter drop down control?
Thanks

keep your parameters in the order they are dependent. refer the parameter some thing like

select src_parameter2 where src_param1=@.param1

Thanks

Raj Deep.A

sql

Page number doubt in RS2000

Hi,
I have created a report which has a Table of Contents and two other sections say Sec1 and Sec2. Sec1 and Sec2 have tables which are populated from the database. The page numbers of Sec1 and Sec2 are not known at design time. In the Table of Contents, I need to show the page numbers where Sec1 and Sec2 start. How can this be accomplished?

Regards,
Asim.Were you able to find a solution? I am also looking to solve this issue for my reports.