Yes michael.higgins, That is the one I am looking for.

But one small thing, I don't need the separation line between the audit descriptions for a particular audit.

i.e. for audit Id,...

Thanks for your reply.

Any web articles where I can get more detailed help having snapshots?

I am using 2008 R2 version.

Please add some more information on solution so that I can proceed further.

Thanks SQLRNNR, Very informative.

Please explain the difference of usage of REPLACE in your first post.

Also, why you used '$-','-$' in the query.

Hi Doug

Can you explain a bit on how you did it.

I have tried adding all the report textboxes in the report header into a rectangle and align it with...

Thanks for the post. Nullif is new to me.

Ok,.. I want the whole tablix and the tablix data to be shown on the first page and to be repeated on the following pages depending upon the materialcodes inputted.

Thanks Gail, thanks for your reply. That has worked for me.

Yes, Perry..I am looking for VS events which can be used in SSRS.

But I couldn't find the difference b/w these two events.

Thanks everyone for the replies..

I changed my script like this:

SELECT

ISNULL(C.containerCode, '') + ':' + ISNULL(C.containerName, '') as display,

C.containerCode AS code

FROM Containers C

INNER JOIN ContainersTypes CT ON

CT.containerTypeSqlId = C.containerTypeSqlId...

Thanks for the replies....I will try this.

Yes, Gila, That's what I did. I took the second option.

select case when St.alternateStudyCode = '' OR St.alternateStudyCode IS NULL then St.studyCode END AS StudyCode,* from Studies St

Thank...

Ok..Thanks Gila for the information.

But If I change the code this way, it is not showing the message:

DECLARE @SomeValue nvarchar(4000) = ' '

SELECT isnull(@SomeValue,'The variable is null');

ie. When the record...

Thank You, David once again. Let me try it out.

Thanks for the replies,

I got worked this way:

"<b>" & "Quality Assurance " & "</b>" & VbCrLf &

First(Fields!Auditor.Value, "DsGLPFindingsData")