Showing posts with label controls. Show all posts
Showing posts with label controls. Show all posts

Thursday, March 29, 2012

adjusting parameter controls of a report

Hi,
I'm making use of parameters to filter data in an report.
But the parameters appear in fixed-width listboxes in the report. Some
values of the parameters are longer than the width of the listboxes. My
question is how to adjust the width of these parameter listboxes. Any ideas?
Regards, Harry.Hi Harry,
apparently this is not possible.. I had the same question yesterday and I
got the following reply:
"On Jul 17, 3:54 am, mischa <mis...@.discussions.microsoft.com> wrote:
> I have designed a few reports in VS2005 with multi-parameter controls. When I
> view these reports in VS they look fine, however once deployed and viewed in
> the webbrowser (MS Internet Explorer) the drop-down boxes are too small (or
> the font size is too big).
> Is there a way to adjust (resize) the control boxes so you can make them
> larger so it's easier for people to actually read where they can choose
> between?
> thanks,
> mischa
As far as I know, there is not. This has been a common request on this
news group. Hopefully, this will be addressed in SSRS 2008. Otherwise,
you could try to inject CSS; however, I think that styling is only
allowed at the Report Manager page and report border level (though I'm
not sure). Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant
"
best regards,
mischa
"Harry2007" wrote:
> Hi,
> I'm making use of parameters to filter data in an report.
> But the parameters appear in fixed-width listboxes in the report. Some
> values of the parameters are longer than the width of the listboxes. My
> question is how to adjust the width of these parameter listboxes. Any ideas?
> Regards, Harry.sql

Sunday, March 25, 2012

Adding Viewer Controls to WinForms or Web project

With the release of the feature pack for SQL 2005 and the included Datamining Viewer Controls I was wondering three things. 1) How do you add these controls to your toolbox and 2) Are these controls installed with VS 2005 or SQL 2005 and these are just the redistributable versions for systems where VS 2005 and SQL 2005 are not installed? 3) Is there a description of the controls and what each one does?1) How do you add these controls to your toolbox

In the Winform designer, right click on the Toolbox and select 'Choose Items...' menu item. Hit the Brows button and select file 'Microsoft.AnalysisServices.Viewers.dll'. Hit the OK button to add all the viewer controls to your toolbox.

2) Are these controls installed with VS 2005 or SQL 2005 and these are just the redistributable versions for systems where VS 2005 and SQL 2005 are not installed?

The view controls are shipped with SQL 2005 as well as in its separate redistributable available for download.

3) Is there a description of the controls and what each one does?
You can find description of each individual viewer control in SQL Books online.