subreport should not include footer and header description

Question

Hi, In SSRS 2008 I need to suppress header & footer description of the mainreport on the Subreport page. Please guide me.

Thanks in advance.......

Answer 1

Hi ione721,

Here is what I understand from your question:

"You have a description (in a textbox control) in your Page Header and Page Footer of your report. You want this description in header and footer only on the first page and hide it in the subsequent pages".

To accomplish this, you can writer an expression on the visibility property of the textbox containing the description based on the PageNumber something like "If PageNumber = 1, then Show, else Hide".

Hope that helps!

---

Best Regards,
Datta
----------------------------------------------------------------------------------------------------
Dattatrey Sindol
My Blog: Datta's Ramblings on Business Intelligence 'N' Life
The information provided here is "AS IS" with no warranties, and confers no rights.
Please mark the post as answered if it solves your problem.

Answer 2

Hi Dattatrey Sindol, Thanks for your response. Not exactly I have a report lets call it the main report which makes use of a subreport and this main report has a header and a footer, by default SSRS displays that page header and footer on all the pages, is there a way for the SSRS to ignore page header and footer being displayed for the subreport page?

Regards..........

Answer 3

can you just delete the page header and page footer in your subreport, if you don't want them to be shown in the main report? Do you need it?

---

Think out of the box

Answer 4

Hi i_h, No the main report has header and footer that gets displayed on the subreport page. I do not want to show the main report's header and footer on the subreport page.

Regards............

Answer 5

Ione721,

From your description, you want to hide the textboxes in the Page Header/Page Footer for the page where the subreport displays. If I have something misunderstood, please feel free to let me know.

As Datta has posted above, we can control the visibility of a textbox that is placed in the Page Header/Page Footer based on an expression. In this issue, let’s assume the page number of the page where the subreport is displayed is N. Then, we can set the visibility of the textboxes in the Page Header/Page Footer by using the expression below:
=IIF(Globals!PageNumber=N, true, false)

Reference:
How to: Hide an Item

If you have any questions, please feel free to let me know.

Regards,
Mike Yin

Answer 6

HI,

IN design view have you tried to reduce spaces?

You can try overlapping controls and see the preview sometime it shows more space then design view.

Answer 7

Thanks all for your response. Mike I do understand what Datta has explained but the challenge I face is for different parameters passed I get different resultsets hence the subreport does not stay on the same page.

For instance parameter option A I get the report for 10 pages and the 10th page is where my subreport is displayed and it is of 1 page long and parameter option B I have report for 6 pages and 5th page is where the subreport is displayed and subreport is of 2 pages long. Is there a way for finding the sub-report displayed and hide the Page Header and footer dynamically?

Regards.............

Answer 8

Hi Ione721,

Thanks for your feedback.

I’m afraid that Reporting Services does not support this function when we design a report. Personally, I recommend you submit the good suggestion to the Microsoft Connect at https://connect.microsoft.com/SQLServer/Feedback. Your feedback is valuable for us to improve our products and increase the level of service provided.

Thanks for your understanding.

Regards,
Mike Yin

Answer 9

Thanks Mike.

Answer 10

ione721,

Were you ever able to find a way to do this?  I have the same situation where I need to display a large amount of text in a subreport as the final page.  I want to suppress the header and footer of the main report so that I don't have to display the subreport with such a small font.  

Even if I could have an alternate header that takes up less space, that would be an alternate way to go, but I still cannot find a way to determine when the subreport is actually printing, because the beginning of the report could be anywhere from 1-10 pages.

Does anyone have any workarounds or suggestions???

Answer 11

ione721,

Were you ever able to find a way to do this?  I have the same situation where I need to display a large amount of text in a subreport as the final page.  I want to suppress the header and footer of the main report so that I don't have to display the subreport with such a small font.  

Even if I could have an alternate header that takes up less space, that would be an alternate way to go, but I still cannot find a way to determine when the subreport is actually printing, because the beginning of the report could be anywhere from 1-10 pages.

Does anyone have any workarounds or suggestions???

Hi TracyAnn91, Unfortunately I have put this on the back burner as I was not able to come up with a solution.

Answer 12

Hi Ione721,

Thanks for your feedback.

I’m afraid that Reporting Services does not support this function when we design a report. Personally, I recommend you submit the good suggestion to the Microsoft Connect at https://connect.microsoft.com/SQLServer/Feedback. Your feedback is valuable for us to improve our products and increase the level of service provided.

Thanks for your understanding.

Regards,
Mike Yin

Hi Mike, Is there a work around for this problem? Please guide.........

Thanks.........