DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    47

    Unhappy create shape and append coomand data report

    helloo guyz...

    this is 3rd times i posted diz question....
    i want ur helping... plz help me to solve my problem...
    the problem is.. how to create the shape and append command for data report...

    i want like this....

    +Parent
    ++Child1
    ++Child2

    not like this

    +Parent
    ++Child1
    ---++grandchild

    my question is i want 1 parent and 2 siblings children....
    i dont know how to solve this problem...coz i just know bout 1 parent and 1 child...

    using shape and append command...... example logic is below

    SHAPE {parent-command} [[AS] table-alias]
    APPEND (
    ( SHAPE {child SQL statement} [[AS] alias]
    APPEND ( {grandchild SQL statement} [[AS] alias]
    RELATE child column TO grandchild column) [[AS] alias] )
    RELATE parent column TO child column) [[AS] alias]

    this is juz for 1 parent and 1 child... how to create another child???

    plz help me....

  2. #2
    Join Date
    Jan 2007
    Posts
    1
    I also have this problem.

    If I have two Group headers How can I write the SQL Statement?

Similar Threads

  1. shape append
    By Dave Kraft in forum VB Classic
    Replies: 2
    Last Post: 12-16-2006, 09:58 AM
  2. Create Report Command Child......
    By helme_syahiemie in forum VB Classic
    Replies: 1
    Last Post: 04-18-2006, 09:20 PM
  3. Shape Recordsets
    By Brent in forum VB Classic
    Replies: 3
    Last Post: 04-17-2003, 10:02 AM
  4. Report based on complex ADO Shape
    By PanamaAU in forum VB Classic
    Replies: 2
    Last Post: 08-16-2000, 04:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


Top DevX Stories

Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL


Sponsored Links