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 ...
16th October 2009, 12:01 PM #1
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:
Any idea how to do this? I'm a bit of a Crystal Reports noob.
17th October 2009, 06:27 PM #2
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)...
Not sure how you do that in crystal but from my experiance all reporting software works the same sort of way.
A group by "Tran ID" with a join on "Item ID" to show "Item name"
17th October 2009, 06:32 PM #3
Yeah, in the end I am INNER JOINS in SQL instead of subreports or anything in crystal.
9th November 2009, 02:06 PM #4
- Rep Power
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.
By sarah09 in forum MIS Systems
Last Post: 15th April 2009, 04:25 PM
By Ric_ in forum MIS Systems
Last Post: 16th January 2009, 09:42 AM
By danIT in forum General Chat
Last Post: 18th June 2008, 08:02 PM
By conehead in forum Educational Software
Last Post: 14th May 2008, 06:04 PM
By Sean in forum Educational Software
Last Post: 15th January 2008, 09:26 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)