Format parameter field

Question

Post reply

Format parameter field

keywestfl9

SSCertifiable

Points: 5215
More actions
August 19, 2010 at 6:30 pm

#226393

i have a parameter planno
and then i have a textbox with the expression as below in the page header
FormatNumber(round(Parameters!PlanNo.Value,1),0,-1,-1)
i get #error
Can anyone tell me what i am doing wrong?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

kpsr_kpsr 63487 SSCommitted Points: 1875 More actions · Answer 1

Hi

Could you please tell me what is u r requirement?

sank

Cadavre SSC-Forever Points: 41690 More actions · Answer 2

keywestfl9 (8/19/2010)
i have a parameter planno
and then i have a textbox with the expression as below in the page header
FormatNumber(round(Parameters!PlanNo.Value,1),0,-1,-1)
i get #error
Can anyone tell me what i am doing wrong?

This might help

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

kpsr_kpsr 63487 SSCommitted Points: 1875 More actions · Answer 3

Haaa haaa haa haa.good joke.keep it up.

I am asking why u r doing format?

which type of format u r expecting and what is old format?

sank