Visibility of a Blank Sub Report

Question

Hi to everyone,

I would like to ask if there is any property so that to keep a sub report visible even if it is blank (contains no data rows) when executing the main report. I want to keep the sub report headers visible as a sub-section of the main report.

Thanks in advance

Answer 1

Hello,

We can not have header and fotter section of the sub report into main report only detail section of sub report is visible in main report.

You can do one thing insert a header row in your sub report tablix and use that as header just an idea

---

blog:My Blog/

Hope this will help you !!!
Sanjeewan

Answer 2

This is not a supported feature of SSRS:

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/77af0687-1726-425c-b6d4-fadae606f337

Regards,Eshwar.

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 3

Let me come again,

I would like to ask if there is any property so that to keep a sub report visible even if it is blank (contains no data rows) when executing the main report.  I want to have the subreport table columns with no data demonstarated in the main report. 

thanks in advance

Answer 4

Hi,

Maybe you can try putting a static text box on your sub report, white font, outside of the header, between the header and your tablix and make the height 0.1 or barely visible. That will keep the report visible.

---

Hope this helps! k r o o t z

Answer 5

Hello,

Subreports have a NoRows property.  If a message is set for the NoRows property, and the subreport doesn't return data at runtime, then no subreport contents is shown, but the NoRows message instead.
 

Put your message Data not available

Answer 6

is it possible to demonstarte the subreport contents (even if that contain no data, as subsection of the main report) when subreport does not return data at runtime?

Answer 7

Hello Tassos,

Not sure but I think no. give a try to this just go to sub report columns and check in expression like this

=iif (len(Fields!ABC.Value)>0,Fields!ABC.Value,"-") in each column

---

blog:My Blog/

Hope this will help you !!!
Sanjeewan

Answer 8

Hi,

Ok, I see what you mean.

Modify the SQL on your subreport and add:

UNION SELECT NULL FROM DUAL

This will always add a blank record so the subreport will display the header.

You have to modify your subreport parameter to accept nulls.

This should work!

---

Hope this helps! k r o o t z

Answer 9

hello Sanjeewan,

Unfortunately it did not work. however, thanks for your help.

Answer 10

Hello,

Do some thing in your query, Create a temp table with all column you are using in report insert value zero in that and left join that in this every time you have zero in against each columns and you have all the tablix header in Main report

---

blog:My Blog/

Hope this will help you !!!
Sanjeewan

Answer 11

Hi Tasso85, 

Have you tried my suggestion above? I tested it and it worked for me.

---

Hope this helps!

k r o o t z

Answer 12

Dear Krootz

it seems to work properly at a first glance.

Sanjeewan thank you as well for your valuable help