Welcome to SPN

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

Sign Up Now!

report columns

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

Tags:
  1. Accessidiot

    Accessidiot
    Expand Collapse
    Guest

    I have a report, on that is a subreport that has 2 columns on it.
    If I view the sub report on its own it looks fine.
    When I add it to the main report firstly the 2 columns changed to 1, so then
    I went into setup on the main report and changed that to 2 columns, the first
    column starts in the correct place, the second column however begins at the
    top of the page overwriting info on the main report!
    Is ther a simple solution?
     
  2. Loading...

    Similar Threads Forum Date
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014
    United Sikhs New Report Shows Increasing Hate Attacks on Sikhs Sikh Organisations May 21, 2014
    Legal ACLU reports: Judge orders Sikh man, "Remove that rag, or Go to Jail! Breaking News Sep 27, 2013

  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Accessidiot wrote:
    > I have a report, on that is a subreport that has 2 columns on it.
    > If I view the sub report on its own it looks fine.
    > When I add it to the main report firstly the 2 columns changed to 1,
    > so then I went into setup on the main report and changed that to 2
    > columns, the first column starts in the correct place, the second
    > column however begins at the top of the page overwriting info on the
    > main report!
    > Is ther a simple solution?


    Subreports with snaking columns will only "snake" if you use "Across, Then Down"
    columns or if the subform control on the parent report has CanGrow set to No.
    This is because the subreport has no knowledge of when the parent report hits
    the bottom of a page.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     

Share This Page