+ Post New Thread
Results 1 to 4 of 4
Coding Thread, Crystal Reports report design in Coding and Web Development; I have a report I wish to create for a program I am working on. This report should grab data ...
  1. #1

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,607
    Thank Post
    514
    Thanked 2,441 Times in 1,889 Posts
    Blog Entries
    24
    Rep Power
    828

    Crystal Reports report design

    I have a report I wish to create for a program I am working on. This report should grab data from 2 tables - A transactions table, and then for each transaction, and each transaction has data relevant to it from another table - namely the items that made up that transaction.

    In text form it would look something like this:

    -Transaction
    --Item
    --Item
    --Item
    -Transaction
    --Item
    --Item

    etc...

    Any idea how to do this? I'm a bit of a Crystal Reports noob.

  2. #2
    mossj's Avatar
    Join Date
    Dec 2008
    Location
    Leicester
    Posts
    1,466
    Thank Post
    157
    Thanked 189 Times in 174 Posts
    Rep Power
    52
    Need more info... then mayb I can help

    you have 2 tables, yes?

    Transaction table, with what columns?

    Same for the other one what columns?

    If you use logic I'm going to assume they look like this

    Tran Table - (PK), Tran ID, Item ID(FK)
    Item Table - Item ID (PK), Item Name

    I would do (based on Oracle, SQL, Access experiance)...

    A group by "Tran ID" with a join on "Item ID" to show "Item name"
    Not sure how you do that in crystal but from my experiance all reporting software works the same sort of way.

  3. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,607
    Thank Post
    514
    Thanked 2,441 Times in 1,889 Posts
    Blog Entries
    24
    Rep Power
    828
    Yeah, in the end I am INNER JOINS in SQL instead of subreports or anything in crystal.

  4. #4

    Join Date
    Nov 2009
    Posts
    5
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    0
    Inner joins for the selection script and using Crystal report groupings will be the most efficient way of doing this in my experience. You want to have it in the join regardless to prevent any cartesian nonsense, and using subreports for the internal selections will result in a much bigger (proportionally, at least) database load to extract the information.

SHARE:
+ Post New Thread

Similar Threads

  1. Sims and Crystal
    By sarah09 in forum MIS Systems
    Replies: 7
    Last Post: 15th April 2009, 04:25 PM
  2. 'Back saving' with Crystal Reports
    By Ric_ in forum MIS Systems
    Replies: 1
    Last Post: 16th January 2009, 09:42 AM
  3. Report Design for MySql Data
    By danIT in forum General Chat
    Replies: 2
    Last Post: 18th June 2008, 08:02 PM
  4. Crystal ICT Channel
    By conehead in forum Educational Software
    Replies: 13
    Last Post: 14th May 2008, 06:04 PM
  5. New 2D Design talking to the Old Mill Design
    By Sean in forum Educational Software
    Replies: 5
    Last Post: 15th January 2008, 09:26 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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