Great.  Thanks.

I misposted the image as I was replying to another post.

Here is another problem.  If I put the total my way, it is on the top below the column name.  It doesn't look nice but I am able to make...

You can use CASE in the select statement to display NULL as Unknown.  This way you will see Unknown instead of <<NULL>> in the report.

hth,

Thanks.  I figured a different way.  I right click on column and select add column.  I give it whatever expression then later edit its value to count(Field!ID.Value) then it works...

I don't know why but the column name TicketId is case-sensitive.  If I used TicketID I got null. 

DECLARE @RetVal int, @Doc varchar(8000), @iDoc int

SELECT @Doc = '

<AuditTrail>

 <AuditDateTime>2006-04-20T09:24:55</AuditDateTime>

 <UserName>Unknown</UserName>

<ChangesXml><Tickets>  <Ticket>

    <TicketId>554</TicketId>

   ...

Thanks for the reply.  However it is not what I wanted to find out.  I currently use a similar SELECT statement to include the percentage as another column but in...

Vladan, it works for me.  Thanks.

Claudia, I think stax68 meant r.ID, not r.RequestID.

Thanks everyone.

Sorry if I wasn't clear enough but here is what I would like to see.

ID          Received                                               Status     ClosedDate ...

i finally got it works.

look like the correct syntax for AuditDateTime is ../../../../AuditDateTime.  However it still shows nothing. 

if it does bother you that much, add a step to do a BACKUP WITH TRUNCATE_ONLY and DBBB SHRINKFILE, couple times if needed before the step to do your regular full...

thanks for your reply.  I figured it out, similar with yours but mine is longer.

you guys are great.  thx.

thanks a lot.

are you sure there is such button in SQL 2005 Management Studio?  I just looked one more time, there is no such button.