Formatting report parameters?

Hi,
I have 5 report parameters to show in a report. I want to properly align the
controls(list boxes, text boxes) of parameters. How do we format the report
parameters in SQL Server 2005 Reporting Services using Report Designer tool?
Thanks in advance!
Regards,
VenkatOn Nov 6, 7:14 am, "Venky Dosap" <ven...@.translogicsys.com> wrote:
> Hi,
> I have 5 report parameters to show in a report. I want to properly align the
> controls(list boxes, text boxes) of parameters. How do we format the report
> parameters in SQL Server 2005 Reporting Services using Report Designer tool?
> Thanks in advance!
> Regards,
> Venkat
As far as I know, the best control you can get over this is to order
them differently in the Report Parameters' list (via Layout view >>
Report drop-down list >> Report Parameters...) by selecting the up/
down arrows on the left. Unfortunately, there is not much more in the
way of layout customization available. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Formatting Currency

Hi all,
I have a currency field in my database, when I select data from that
column, I want it to right align.
Any help?This is performed in the client application. SQL Server sends back data
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
<riversmithco@.hotmail.com> wrote in message
news:1110819266.183608.268260@.z14g2000cwz.googlegroups.com...
> Hi all,
> I have a currency field in my database, when I select data from that
> column, I want it to right align.
> Any help?
>|||Which software do you use to display these values to the end users? Have you
considered researching the options on the client programming language or
report writer to see if they have provisions to support such alignment &
formatting functionality?
In SQL Server, such formatting requires you to do explicit type conversions
and padding up with spaces. For instance with a value like 123.45 you would
display it right aligned using a 10 character string value as:
DECLARE @.c MONEY
SET @.c = 123.45
SELECT RIGHT( SPACE(10) + CAST( @.c AS VARCHAR ), 10 )
Anith|||Tibor Karaszi wrote:
> This is performed in the client application. SQL Server sends back
data
But what if I am not using a client app, perhaps I am just running a
report from a sql query?|||Then use Anith's suggestion. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
<riversmithco@.hotmail.com> wrote in message
news:1110820375.127912.77870@.g14g2000cwa.googlegroups.com...
> Tibor Karaszi wrote:
> data
>
> But what if I am not using a client app, perhaps I am just running a
> report from a sql query?
>