Showing posts with label align. Show all posts
Showing posts with label align. Show all posts

Tuesday, March 27, 2012

align the parameters in reports

IS it possible to design the Parameters Layout in Reporting Service
reports
miniYou can modify styles in HTMLViewer.css style sheet present in Reporting
Services\ReportServer\Styles folder but you will only affect appearance of
the elements, not the distribution or type of controls you want to show.
If you want to fully customize that layout, you need to use reporting
services API, as I have done. For example, I have used radio buttons to
choose report parameters instead of the default combobox.
Jaime
"mini" wrote:
> IS it possible to design the Parameters Layout in Reporting Service
> reports
> mini
>|||thanks Jaime
can u explain how you use reporting
services API?
Can u reduce the Textbox width displayed in parameter layout?
thanks
mini

Align image

I have an image in a table cell in my report. Naturally not all images fit 100% in the cell which is why I'd like to align the images in the middle of the cell, horisontally and vertically.

I've been unable to figure out how to do this in Reporting Services for SQL Server 2000. Am I missing something or is this simply not possible? Does anyone know whether it can be done in 2005?

try manipulating the padding values Big Smile|||I would but we're talking an entire column of images of varying sizes here thus I would have to calculate the correct padding size based on the size of the column and of the image itself. It seems like a little much for such a simple thing.|||I have not seen any built in functionality for this in reporting services so I guess your options are pretty limited. Padding values are a sure way to get this done but you could have the cell fixed sized and have your image fit proportionally|||http://blogs.msdn.com/ChrisHays/

this link tells you what i been saying all along. paddings are the only way to go.

and the working sample is here

Align Calculated Members and Measures

Hi

I created two calculated member:

CREATEMEMBERCURRENTCUBE.[MEASURES].[Penetracion]

ASIIf([Measures].[Surtimientos] = 0,0,[Measures].[Seguros]/[Measures].[Surtimientos]),

FORMAT_STRING = "Percent",

VISIBLE = 1;

CREATEMEMBERCURRENTCUBE.[MEASURES].[Calidad]

ASIIf([Measures].[Seguros] = 0,0,[Measures].[Prima Seguros]/[Measures].[Seguros]),

FORMAT_STRING = "$#,##0.00",

VISIBLE = 1 ;

I have two measures called [Measures].[Surtimientos] and [Measures].[Seguros] and both have its FormatString property #,#.

When I browse the cube the measure and calculated meber values ared formated but they have left alignment. If I take away the FormatString they have right alignment.

Is there a way to align the values to right when I use FormatString?

Regards

If you change FORMAT_STRING = "$#,##0.00", to FORMAT_STRING = "$# ##0.00"?

Regards

Thomas Ivarsson