Results 1 to 3 of 3

Thread: Two recordsets

  1. Feb 20th, 2006, 09:25 PM #1
    RBNRM
    RBNRM is offline

    Thread Starter
    New Member
    Join Date
    Jan 2006
    Posts
    10

    Two recordsets

    Hi all,

    I'm using VB6, ADO, Access Database and Data Report Designer for reporting. I'm generating my recordsets at runtime and using them to populate the reports. I have this problem:

    In a particular report, I need to display data from two recordsets. The data from the first recordset has to be displayed fully, then below it, the data from the second recordset has to be displayed.

    I tried connecting two rptTextBoxes to each recordset, but that causes data from the two recordsets to intermingle.

    Help me please.. I'm not up to speed with the Data Report thing.
    Reply With Quote Reply With Quote
  2. Feb 22nd, 2006, 04:51 AM #2
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: Two recordsets

    I think you need a subreport but sadly DataReport does not have such...
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  3. Feb 22nd, 2006, 10:58 AM #3
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Two recordsets

    If this is a typical Master-Detail report then you will need to use a Hierarchical recordset. Search for Data Shaping.

    This might get you started..

    http://www.vbforums.com/showthread.php?t=346079
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width