Dont want to Show Blank Page when Subreport doesn't return Data in SSRS

(0) Share

Report

Posted on by Community Member

Hi All,

I have Main report in that i have 5 sub reports . i want to show each sub report on separate page,for that in main report i have added subeports inside the rectangle and set PageBreak to End. Its working fine when all sub reports have data.But if any subreport doesn't return any data then it showing the Blank Page. I tried all solutions like Hidding rectangle using expression ,Hidding subreport using expression but it's not working

I have also tried using Tablix and each row i have added rectangle and then in rectangle i have added sub report. Using =IIF(RowNumber(Nothing)>0,False,True) i was trying to hide the Row but blank page is showing when no data is return by subreport.

please suggest solution on this

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Tom Mathew 1,750 on at

Like (0)

Report

try hiding the section using the section expert in which the subreport sits based on your condition.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

There is no Section expert in SSRS

Was this reply helpful? Yes No
Tom Mathew 1,750 on at

Like (0)

Report

Oh Ok. Thought it was a crystal report you are talking about and sorry for that.

Was this reply helpful? Yes No
dgardner3 5 on at

Like (0)

Report

I am having this exact issue. I know this is an old post, but did you possibly ever find a solution? Thank you!

Was this reply helpful? Yes No