Skip to Content

Supress blank pages from main report when linked to subreports

Hi,

I have one main report and three subreports linked to main report with user ID. When I execute, I get all data as I wanted. My main report has page header (not in any sub reports). When I run this report, I get blank pages with page header on each blank pages. I want to suppress these pages and I can not do it.

All my subreports have "keep together" options unchecked and supress blank pages on every sub report and main report. I am so puzzled and unable to fix this issue. Can anybody help me fix this issue please?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Apr 26 at 02:11 PM

    Look at the sections in the main report that the subreports are in - make sure that you have Keep Together turned off for those as well. Do you have any groups in your main report? If so, you should also turn off Keep Together for the groups.

    If neither of those fixes in the main report resolve the issue, you'll have to turn off Keep Together for the sections and groups in the subreports.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 26 at 02:22 PM

    Hi Dell,

    I tried both ways as you mentioned above. Same result.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Mona,

      Please re-attach the report "with saved data".

      Before attaching the report here, please change its extension from .rpt to .txt (you've exported the report to .txt which is not what Dell asked for).

      Another alternative is to upload the report to Google Drive or another file sharing site and post the URL here.

      -Abhilash

  • May 03 at 02:56 PM

    Hi Abhilash,

    I have been trying to attach the file as you instructed. Whenever I try to upload , I get a message the file type invalid and I can not upload the file in txt.

    Pl advise.

    Thanks

    Mona

    Add comment
    10|10000 characters needed characters exceeded

  • May 07 at 12:55 PM

    Hi Abhilash,

    https://drive.google.com/file/d/1iHWeN3KSCIPVCw0Bi2vjSydLpBlgK8tM/view?usp=sharing

    As requested , here is a link of my file. I want this file sorted by usergroup (homeroom) followed by student ID. All blank pages need to be removed.

    Thanks

    Mona

    Add comment
    10|10000 characters needed characters exceeded