Hi Peter,

In 2005 I'm able to do this as mentioned earlier, but the problem is with 2008 .

I have followed the steps you have mentioned.

The sorting tab also was showing...

Hi Peter Thanks for your reply.

It didn't work.

This is what I have tried:

1) In my tablix selected the detail row

2) Right Click --> RowGroup--> Group Properties

3) In General tab, for...

Hi All,

I have tried many options in SSRS 2008 to do this but no luck.. 🙁

Can some one help me on this please...

Hi,

You can use a List and then keep the text box in side that List and use the above expression.

Hi friends,

I have tried the expression as mentioned above

= Ceiling(Rownumber(nothing)/10)) this worked perfectly in SSRS 2005.

But can some please let me know how to do it in SSRS 2008?...

Ok , then can you try one thing, in the table form where you are getting the default value, make sure that that column value is same for all the...

That is up to you what you are going to do with this result, if you are not doing any thing then as you told you don't have to use...

Hi,

Can you make sure that the Default value that you are expecting is one among those in the available values?

i,e for example if the available value list is A,B,C,D,E then...

Hi

As you have mentioned that you know how to do this in SSMS, the same query you can use in a script task or Sql task in your SSIS.

Hi Jeff,

Its very nice . Thanks a lot. 🙂

Friends,

I'm still looking for a help to setup this.. any one have any idea..?.. 🙁

Hi,

I don't see any other reason, because as you followed the steps now the page break is with rectangle which you placed between the tables, so it is irrespective of...

hi

Could you please make sure that you have done it as below:

1) Place a rectangle between the tables.

2) Put Page break to the rectangle.

3) Made the size of the rectangle...

Sorry ,

One small correct, use any object which has got page break property(text box doesn't have this), use can use rectangle or matrix

Hi Renzo,

As per my knowledge, in SSRS the table visibility and page break wont work together...

One option is what you have tried, but as you saw it will give you...