Hi,

Could you please try this:

1) Put a table Group on the EmpID.

2) Add group footer.

3) Get the total details in the group footer.

4) Keep a page break for the group.

Thanks a lot Jeff,

When I tried those two things, I'm able to see the difference... 🙂

Friends,

Did you get a chance to look into my previous reply? 🙁

I have created a table with two columns then inserted 1000 records with NULL for one column, then...

Thanks Jeff,

I have tried the same by using the below example. I have created a table with two columns then inserted 1000 records with NULL for one column, then checked...

Thanks for the clarification.

And as I asked above, can I know how can we find the exact space used...? Is there any script for that..?

My aim is if there...

Thanks mate..

As you mentioned that there is a way to find the exact space used, can I know how to find it..? is there any script for that..?

And one more...

Hi,

I have tried this in SSRS 2008, when I changed the Columns count to 3, in the design it is showing 2 additional columns with the specified width in between...

Correct in design only, I mean the width of the report body.

Hi ,

Could you please make it more clear, didn't understand what you are trying to achieve.

Hi Sasidhar,

As per my knowledge in the rdl the total length of the report can be 406.34 cm , so no matter how many columns you create with in...

Hi ,

Can you clearly mention what you are looking for..? Do you want to check whether the Field you specified starts with some string? If so try to user Left()...

Hi that is an alternative.

I have tried using the code itself , it is working but still Im not satisfied... 🙂 the code is below. As you told I...

But again, if there is a CREATE table it will give the same error as before right..?

USE SSC

CREATE #X (A INT)

USE TEMPDB

IF OBJECT_ID('#X') IS NOT NULL

BEGIN

USE SSC

DROP TABLE #X

CREATE #X...

Craig,

Thanks for the clarification.

Oh..ok thanks for your reply. Even I don't prefer to declare the table inside loop. But just wanted to know how it is working..

As you said the table is created...