I'm not sure what exactly you looking for..! but if you right click on table/matrix or F4 properties you can see property NoRows message , specify your own message, it...

Hi Thanks for reply..!! It works..!! but I'm not interested to use dataset , as I have got 12 summaries in my report. For this i have to create...

Apologies for delay..Much appreciated..thanks

Just now, I have created and attached image..I hope this is helpful to you..!!

I have Categorize into 3steps

1st step : Before search (Parameters will display)

2nd step: After Search (...

Thanks for your reply..I have gone through that link..but i'm still facing some problems 🙁

Thank you for your valuable explanation.!!...I'm trying to implement same concept and get back to you..!! once gain thank you..!!

Thanks for your reply and suggestions.!! 25million rows in source table and its taking more than 5hrs to run..is there any way to load all data into temp table? and...

Yeah.Sry.I'm new, don't know where exactly need to post..!! I never used cursors as well :..can you please guide me how to delete..thanks

Just now , I have done same task. Please look at images .thanks

set repeatonnewpage to true for rows properties of the advanced section. Not for columns properties. I hope this helps.

I think u need set Property RepeatOnnewpage to True for each column. Thanks

Make sure you run as Administrator .!you can do by right click Business intelligence Visual studio 2010 or Sql Server Data tools and run as a Administrator..thanks

Thank you 4r reply..I got the answer now..I have did same thing before but i have used top in my query..

the reason for using top query is i want to...

Thanks for your reply

Well, I have used matrix to display results..but i can't get desired result..thanks

ohh..thanks for quick reply.