Results 1 to 3 of 3

Thread: Making a data report display in several columns

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jan 2007
    Posts
    65

    Making a data report display in several columns

    I am using the Data Report designer to create a report in my vb6 app. Can I make the report display it's information in several columns instead of it being in one continuous column?

    Thanks!

  2. #2
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Making a data report display in several columns

    The Data Report is pretty limited and does not have the functionality to create a multi-column report.

    What you could do is manually create a recordset which repeats the fields for the number of columns you want to print. For example, if you want a list of CompanyNames in 3 columns the recordset would need to contain

    Company1, Company2, Company3. Then use 3 labels on the report.

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Jan 2007
    Posts
    65

    Re: Making a data report display in several columns

    Ok, thanks! Unfortunately that won't work for me because I need to do a sort based on a calculation of several different fields. I was hoping there would be a way to display several columns like you can do with an Access report.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width