sql server reporting services: Working with space in Report manager -- sql server reporting services

Working with space in Report manager

RajDeep
8/1/2006 3:50:36 AM

sql server reporting services:

Hi ,

I am struggling to appear a space between two fields .I do have
expression like this

Format((Fields!PERSON_ELASPED_TIME.Value\60),"#,###,###0") & ":" &
Format((Fields!PERSON_ELASPED_TIME.Value) Mod 60,"00") & Space(4) &
Fields!FLAG.Value
)
It was supposed to display in format like this

34:50 *
It was working Fine in Preview tab. but when i export it to Web(Report
manger).it was showing
34:50*
which was not correct
Can any body pls help me in doing this
Suggestions and sharing the Experiences are highly appreciated

Thank you
Raj Deep.A

RE: Working with space in Report manager

magendo_man
8/3/2006 8:01:02 AM

You could try:
Format((Fields!PERSON_ELASPED_TIME.Value\60),"#,###,###0") & ":" &
Format((Fields!PERSON_ELASPED_TIME.Value) Mod 60,"00") & " " &
Fields!FLAG.Value

i.e " " instead of Space(4)

Hth,
Magendo_man

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.