Showing posts with label size. Show all posts
Showing posts with label size. Show all posts

Friday, March 9, 2012

Parameters input field size

Hi,

is it possible to change the appearence of input fields for parameters on the report server? My parameter is Multi-value with quite large amount of available values. On report server, user can (without scrolling) see only the first value. Parameter values are quite long, so user has to move alternally with both vertical and horizontal scrollbars to find the right value.

Thanks

Janca

I don't believe there is a way to do that directly, but you can build your own UI and include the ReportViewer control on the page. Take a look at the example at:

http://technet.microsoft.com/en-us/library/aa179197(SQL.80).aspx

Larry

Parameters in RS

Hi All,
Wats the maximun size for the parameters in SQl'
I have a string parameter and if a paa about 130 characters... Its getting
truncated ...
Any help please..
Thanks,depends on the datatype but I think 8000 for a char or varchar
also depends on case 4000 if you are case dependent
"CCP" wrote:
> Hi All,
> Wats the maximun size for the parameters in SQl'
> I have a string parameter and if a paa about 130 characters... Its getting
> truncated ...
>
> Any help please..
>
> Thanks,|||Unless, of course, the parameter is being passed via the querystring, at
which point it is restricted by the maximum length of the URL:
http://support.microsoft.com/default.aspx?scid=kb;en-us;208427
Mike G.
"letuce dance" <letucedance@.discussions.microsoft.com> wrote in message
news:AF5AFF64-8683-42F5-BBE3-47EECCC31C98@.microsoft.com...
> depends on the datatype but I think 8000 for a char or varchar
> also depends on case 4000 if you are case dependent
>
> "CCP" wrote:
>> Hi All,
>> Wats the maximun size for the parameters in SQl'
>> I have a string parameter and if a paa about 130 characters... Its
>> getting
>> truncated ...
>>
>> Any help please..
>>
>> Thanks,|||Hi ,
Thanks for the quick response.
Im not passing them in the query string...
I could execute the sp in the query analyser without any probs...
only when i run the report the parameter is getting truncated...
not sure where the prob is'
Any help please...
"Mike G." wrote:
> Unless, of course, the parameter is being passed via the querystring, at
> which point it is restricted by the maximum length of the URL:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;208427
> Mike G.
>
> "letuce dance" <letucedance@.discussions.microsoft.com> wrote in message
> news:AF5AFF64-8683-42F5-BBE3-47EECCC31C98@.microsoft.com...
> > depends on the datatype but I think 8000 for a char or varchar
> >
> > also depends on case 4000 if you are case dependent
> >
> >
> >
> > "CCP" wrote:
> >
> >> Hi All,
> >> Wats the maximun size for the parameters in SQl'
> >> I have a string parameter and if a paa about 130 characters... Its
> >> getting
> >> truncated ...
> >>
> >>
> >> Any help please..
> >>
> >>
> >> Thanks,
>
>

Wednesday, March 7, 2012

Parameters Bar

Hello,
I would like to expand the size of parameters bar, is it possible with SP1?
I have too many parameters to deal with and I don't want users to scroll
through.
Thanks.
Regards,
CemBecause of an IE issue the splitter bar between the parameter area and the
report body does not remember it location when Report Manager (http:
//<someservername>/reports/...). The splitter bar behavior works correctly
when you are view the report via the server (http://
<someservername>/reportserver/...)
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cem Demircioglu" <cem@.NoSpamPlease.com> wrote in message
news:%23r6kkCveEHA.3376@.TK2MSFTNGP10.phx.gbl...
>
> Hello,
> I would like to expand the size of parameters bar, is it possible with
SP1?
> I have too many parameters to deal with and I don't want users to scroll
> through.
> Thanks.
> Regards,
> Cem
>