locked
Combining one-column and two-column layouts RRS feed

  • Question

  • Hello,

    Is it posssible to combine one and two-column sub-reports on a same report?

    Thanks,

    AC

    Monday, May 30, 2016 10:29 PM

Answers

All replies

  • Hi AC,

    In your scenario, what are the two column layouts? Are they column charts or just tables? And how did you want to combine them, combine records together (append query) or join two datasets? Please share us more information or screenshots.

    Thanks,
    Xi Jin.

    Wednesday, June 1, 2016 7:04 AM
  • Hi Xi Jin,

    I am trying to produce a report that would look like a newsletter (Table below. Sorry, I am not able to post images). The one-column section on the top could be a table or just a textbox (spanning over the two columns). The two-columns would consist of dynamic text. Each section has its indepent datasource. A query populates the table on the top and a unrelated query brings the text for the paragraphs that go in the two columns.

    one-column one-column one-column one-column one-c
    olumn one-column one-column one-column one-column
    one-column one-column one-column one-column one-c
    olumn one-column one-column one-column one-column
    
    two-column two-column        two-column two-column 
    wo-column two-column t       wo-column two-column t 
    o-column two-column tw       o-column two-column tw 
    -column two-column two       -column two-column two 
    column two-column two-       column two-column two-
    olumn two-column two-c       olumn two-column two-c
    lumn two-column two-co       lumn two-column two-co
    umn two-column two-col       umn two-column two-col
    mn two-column two-colu       mn two-column two-colu
    n two-column two-colum       n two-column two-colum
    Thank you,

    AC




    • Edited by A Cuahutle Wednesday, June 1, 2016 9:48 PM
    Wednesday, June 1, 2016 9:45 PM
  • Hi AC,

    In your scenario, you can insert a table or sub-report (two-column layout) into the first table rows (one-column layout).

    Please refer following sample:

    Or you can create a newsletter-style report, please refer:

    https://technet.microsoft.com/en-us/library/ms159107(v=sql.100).aspx

    http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/mssqlserver/creating-mailing-labels-in-sql/

    http://blog.hoegaerden.be/2012/11/01/creating-multiple-column-reports/

    If you still have any questions, please feel free to ask.

    Thanks,

    Xi Jin.

    Thursday, June 2, 2016 3:03 AM
  • I will give a try to inserting a (two-column layout) sub-report into the first table (one-column layout).

    Thank you.

    Friday, June 3, 2016 10:50 PM