Results 1 to 8 of 8

Thread: Problem3: How to separate Body Part in the Data Report

  1. Mar 9th, 2003, 03:05 PM #1
    bisdave
    bisdave is offline

    Thread Starter
    Junior Member
    Join Date
    Feb 2003
    Posts
    17

    Problem3: How to separate Body Part in the Data Report

    I want to show report, which the detail have to separate into 2 parts and 2 set of sql commands too.

    Is it possible to separate 2 set of of data and SQL commands on the same report. If Yes, how to do it, Thank you (Again)
    Mr.Dave
    Reply With Quote Reply With Quote
  2. Mar 9th, 2003, 03:14 PM #2
    usamaalam
    usamaalam is offline
    Frenzied Member usamaalam's Avatar
    Join Date
    Nov 2002
    Location
    Karachi
    Posts
    1,308
    I don't think because there is one DataSource property inwhich we assign object of Recordset.

    But may be I am wrong.
    Reply With Quote Reply With Quote
  3. Mar 9th, 2003, 03:18 PM #3
    mxnmx
    mxnmx is offline
    Frenzied Member mxnmx's Avatar
    Join Date
    Dec 2001
    Location
    I'm back...now!!!
    Posts
    1,396
    You could right click on the report and add Group Headers and have two sections and then drag where necessary...
    Can't Remember Birthdays or Important Dates- Never Miss any Important Date(s)
    Reply With Quote Reply With Quote
  4. Mar 9th, 2003, 03:22 PM #4
    usamaalam
    usamaalam is offline
    Frenzied Member usamaalam's Avatar
    Join Date
    Nov 2002
    Location
    Karachi
    Posts
    1,308
    But what code should we write in order to pass two queries.
    Reply With Quote Reply With Quote
  6. Mar 9th, 2003, 03:26 PM #5
    mxnmx
    mxnmx is offline
    Frenzied Member mxnmx's Avatar
    Join Date
    Dec 2001
    Location
    I'm back...now!!!
    Posts
    1,396
    Just add two command objects so you can have two queries in there, and in the first section drag the first object & in the 2nd section drag the second command object...that is it...
    Can't Remember Birthdays or Important Dates- Never Miss any Important Date(s)
    Reply With Quote Reply With Quote
  7. Mar 9th, 2003, 03:29 PM #6
    usamaalam
    usamaalam is offline
    Frenzied Member usamaalam's Avatar
    Join Date
    Nov 2002
    Location
    Karachi
    Posts
    1,308
    oh yeah.

    I didn't think about this.

    Thanks
    Reply With Quote Reply With Quote
  8. Mar 10th, 2003, 02:17 AM #7
    bisdave
    bisdave is offline

    Thread Starter
    Junior Member
    Join Date
    Feb 2003
    Posts
    17
    One Datareport can set only one Data environment and one data member (SQL command), so how we can add 2 SQL commands in one data report .....
    Mr.Dave
    Reply With Quote Reply With Quote
  9. Mar 25th, 2003, 05:40 AM #8
    AzidBurn
    AzidBurn is offline
    New Member AzidBurn's Avatar
    Join Date
    Feb 2003
    Location
    Copenhagen, Denmark
    Posts
    14
    Hi mxnmx

    You wrote...

    mxnmx: Just add two command objects so you can have two queries in there, and in the first section drag the first object & in the 2nd section drag the second command object...that is it...
    I would very much like to see this.. Could i please ask you to write code or sample project and post here...

    Thanx.
    Hello from Denmark
    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