Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Subreport question

Discussion in 'Information Technology' started by pokdbz, Jul 28, 2006.

  1. pokdbz

    pokdbz
    Expand Collapse
    Guest

    I have a report with multiple subreports on it. Sometimes when there is no
    data on a subreport it leaves a big blank space on the main report. Is there
    a way to make it so the subreports will shift up so that there is no blank
    space if one of the subreports has no data and is not showing up.
    Here is what is happening

    subreport 1
    subreport 2

    blank - a subreport with no data


    subreport 3


    blank - a subreport with no data


    subreport 4
     
  2. Loading...

    Similar Threads Forum Date
    Question About GGS Questions and Answers Aug 28, 2016
    Marriage And Discrimination Related Questions Blogs Mar 21, 2016
    Sikhi Questioning Faith Sikh Sikhi Sikhism Mar 3, 2016
    Entering into Sikhism: Questions on Reht Maryada. Blogs Oct 22, 2015
    A question about kes/hair? Blogs Oct 21, 2015

  3. Rick Wannall

    Rick Wannall
    Expand Collapse
    Guest

    Open the report in Design View. Open the properties sheet by looking at
    properties of any object on the report.

    Check the CanShrink and CanGrow properties on the controls on your report.
    If you want to compress space on the report when a thing has no data in it,
    set it to CanShrink. Be sure to set the report section (presumably Detail)
    to CanShrink = yes also.
     
  4. pokdbz

    pokdbz
    Expand Collapse
    Guest

    Thanks that worked

    "Rick Wannall" wrote:

    > Open the report in Design View. Open the properties sheet by looking at
    > properties of any object on the report.
    >
    > Check the CanShrink and CanGrow properties on the controls on your report.
    > If you want to compress space on the report when a thing has no data in it,
    > set it to CanShrink. Be sure to set the report section (presumably Detail)
    > to CanShrink = yes also.
    >
    >
    >
     

Share This Page