I have already tried that earlier. It is still showing a blank page in preview in BIDS.
 I am using SQL2008R2 BIDS.
I tried using page break for...

Please ignore this post. I have posted here
https://www.sqlservercentral.com/Forums/1875477/Blank-page-generated-between-two-tablix-in-SSRS

I cannot take a printout of this article. It is very small when I printed.

Hello, Steve Thank You for your kindness.

I made some minor changes in the code you have posted which suits my requirement, its working fine.

SELECT

What I understood is 
If activitycode is null, go to last position , activitycode. That is the logic.

If activitycodes a1 to a10 are not null and activitycodes a11 to...

Dear ChrisM@Work ,Thank You for your patience and kindness. Your guidance helped me a lot.

Thanks for the reply, ChrisM@Work. I liked the way you have shown the working of the query.
I have a doubt now.
Will the condition check in the...

I have tried this query , which is working

;with cte

as (select activitycode

,activityname

...

The desired output is like:

'S16-03269-01/005', 'EV1 0DA-A', '2016-04-29 10:36:08.093'

Since the activities 'A1 Beginning' and EV1 are having same modifiedon dates and times, it should consider alphabetical order in descending.

ie. E...