Results 1 to 8 of 8

Thread: Multiple columns in data report

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jul 1999
    Location
    Linköping, Sweden
    Posts
    19

    Exclamation

    How can I put multiple columns in a data report? I want to have two columns on a page where each coulmn contains the same fields (but with different values).
    Any ideas?
    /Magnus

  2. #2
    Fanatic Member Gary.Lowe's Avatar
    Join Date
    May 2000
    Location
    In my sphere of influence
    Posts
    621
    Koma

    I am not sure if you can on the data report.
    microsoft seem to have rushed this option as it is similar to access reports but has nowhere near the same functionality.

    I have started to use crystal reports as this is similar to access reports and has a lot more functionality in VB.

    In access the option for the report to contain multiple colums is in the page set up, as of yet I have not been able to find the same thing on the data report.
    Gary Lowe
    VB6 (Enterprise) SP5
    ADO 2.6
    SQL Server 7 SP3

    OK I know my spelling and grammer is crap so don't quote me on it!

    To err is human to take the P! is only natural !!

    Click on the top section of image for Marcus Miller website and bottom section of image for 'Run For Cover' sound clip


  3. #3

    Thread Starter
    Junior Member
    Join Date
    Jul 1999
    Location
    Linköping, Sweden
    Posts
    19
    Thanks for your reply.
    I have VB6 Enterprise edition. Is crystal reports shipped with VB6 EE? I can't seem to find it!
    /Magnus

  4. #4
    Fanatic Member Gary.Lowe's Avatar
    Join Date
    May 2000
    Location
    In my sphere of influence
    Posts
    621
    Koma

    You can get the Report Designer Component from Seagate.
    It contains some good examples as well.

    I downloaded it from the site a while ago but could not find it recently. I phoned them up and told them I had used it previously and they sent me a new one.

    Hope this helps

    Gary Lowe
    VB6 (Enterprise) SP5
    ADO 2.6
    SQL Server 7 SP3

    OK I know my spelling and grammer is crap so don't quote me on it!

    To err is human to take the P! is only natural !!

    Click on the top section of image for Marcus Miller website and bottom section of image for 'Run For Cover' sound clip


  5. #5

    Thread Starter
    Junior Member
    Join Date
    Jul 1999
    Location
    Linköping, Sweden
    Posts
    19
    Thanks, I'll check it out.
    By the way, using data report, is there any way to improve readability by inserting a blank line after every five lines of data from the recordset?
    /Magnus

  6. #6
    Fanatic Member Gary.Lowe's Avatar
    Join Date
    May 2000
    Location
    In my sphere of influence
    Posts
    621
    Koma

    The best method for readability I have come up with is to contain a record in a box or frame. This enables the user to clearly define between different records.

    Also use bold font for the infomation in the records
    Gary Lowe
    VB6 (Enterprise) SP5
    ADO 2.6
    SQL Server 7 SP3

    OK I know my spelling and grammer is crap so don't quote me on it!

    To err is human to take the P! is only natural !!

    Click on the top section of image for Marcus Miller website and bottom section of image for 'Run For Cover' sound clip


  7. #7

    Thread Starter
    Junior Member
    Join Date
    Jul 1999
    Location
    Linköping, Sweden
    Posts
    19
    Ok, that's a good advice.

    The thing is that I'm creating a report that is just for printing, not for viewing on screen. I found the data report object which seemed to be nice but apparently can't do what I want. (That is: a two column report with a blank line in between every five lines of data.)

    Maybe the VB printer object is the only way to go?
    /Magnus

  8. #8
    Fanatic Member Gary.Lowe's Avatar
    Join Date
    May 2000
    Location
    In my sphere of influence
    Posts
    621
    Could'nt comment on that as I have not really used it.

    If Microsoft get the data report together and make it as good as Access reports I will go back to that
    Gary Lowe
    VB6 (Enterprise) SP5
    ADO 2.6
    SQL Server 7 SP3

    OK I know my spelling and grammer is crap so don't quote me on it!

    To err is human to take the P! is only natural !!

    Click on the top section of image for Marcus Miller website and bottom section of image for 'Run For Cover' sound clip


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