I want to thank you both for the replies.

To be honest, I am not familiar with the web server, so I probably need to read up some materials before I...

Dave,

Thank you very much for the reply.  But could you be more specific how do I regenerate the rdl file and upload on the fly? 

What I understand is the...

Hi,

Never mind, I figured out the reason.  When I make the matrix so close to the textbox above.  The position of the matrix will be changed.

Cheers,

I thank you very much for the big help.  It worked!! 

I was sort of using the similar way to concatenate them, but I either put the double qoutes outside...

Hi all,

What I thought is too complicated.  I just need to pass the field value from my dataset to the url.  I mean write an expression to insert the field...

Thank you very much for the reply, it's textbox in the body.  All textboxes are fine when they have values from the dataset.

I took away all the textbox border make...

Never mind, I need to change my stored procedure and the value now is formatted as ########0.#####.  The resulkts is looking fine.

Thank you very much,

Thank you very much for the reply.

The problem is sloved, not by me though.   One member of our team did that, I will find out later if adding the user...

I finally got it fixed. To work around, I have to make the textbox smaller (acts like header) than the column width and make the rectangle borderstyle solid to...

Got it, Thank you very much for your help, David.  I knew there must be a way to do it.  I am sorry I didn't explain it more clearly in the...

I am stuck..., I thought what I need to do is create a user defined function.....

I need to take one column(columnA) from the select query and use it to format...

What I meant is in order to successfully using something like cast(#temp1.col1 as decimal(8,col2)), I should create a user defined function that will take the col2 as parameter and return...

I need to create a function so that it will take the value of Col1 and return something replacing the decimal(p,s). Am I in the right direction?

Thank you very...

Thank you very much for replying. What is scalar function? If I need to use one column's value in the decimal(p,s), what should I do to accomplish that?

solved, - for this error message.

What I did is changed the dataset's stored procedure name since I got a new stored procedure.  However, the layout matrix was bound to the...