Results 1 to 5 of 5

Thread: Reports

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 1999
    Posts
    7

    Post

    Is there a way to print a simple Report
    using Crystal Reports,in which there are
    three tables the contents of which have
    to be printed independently in a single
    Report without linking of any field.

    e.g.

    < Field 1 of table 1 >

    <All Records of field 1 of Table 2 >

    <All Records of field 1 of Table 3 >

    Table 1 , 2 & 3 are independent Tables not
    linked to each other.

  2. #2
    New Member
    Join Date
    Nov 1999
    Posts
    9

    Post

    If I understand you correctly you would like to print a report that gathers data from 3 different tables?
    If that's the case then you can build SQL statement that returns recordset which includes data from all 3 tables.
    You can assign this rs to report after (in this case you need to base you report on data definition file rather then DB).
    On the other hand, there are several different ways, like filling details field on your own from recordset, etc.

    hpet

  3. #3
    Junior Member
    Join Date
    Nov 1999
    Location
    Forsyth, GA, USA
    Posts
    26

    Post

    Try using "subreports". Each can be designed separately and included in one report.

  4. #4
    Lively Member
    Join Date
    Aug 1999
    Location
    SLOVENIA, Europe
    Posts
    110
    I have the same problem. So I want my data to look like this:

    caption 1

    data from table 1 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
    data from table 1 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
    data from table 1 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
    data from table 1 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
    data from table 1 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx

    caption 2

    data from table 2 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
    data from table 2 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
    data from table 2 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
    data from table 2 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
    data from table 2 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx

    caption 3

    data from table 3 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
    data from table 3 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
    data from table 3 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
    data from table 3 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx
    data from table 3 xxxxxxx xxxxxxxxxx xxxxxxxxxxx xxxxxxxxx

    And so on...

    Can anyone help?
    Ermin Gutenberger

    VB.NET 2010

  5. #5
    Your Ad Here! Edneeis's Avatar
    Join Date
    Feb 2000
    Location
    Moreno Valley, CA (SoCal)
    Posts
    7,339
    Like baroberts said 'Subreports' then you can make seperate reports and use them as subreports in your main report, which would have all 3.

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