×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Best Practices for linking two data sets into one

Best Practices for linking two data sets into one

Best Practices for linking two data sets into one

(OP)
I am trying to create a report that needs to link two different rows of data into one.

I have a mortgage and a 2nd mortgage and these are both individual rows in our tables. The Mortgage id is 123456 and the 2nd mortgage id is 123456x2nd I need to create a report that shows the detail from both the mortgage and 2nd mortgage in the same detail section.

I tried creating a sub report and linking the ids by trimming the last 4 characters. This worked but was very slow in processing.

I then tried to create a command and linking the same way but it is still very slow to process.

What is the best method to pull data from two different data sets into one and keeping the processing speed for the report?

table sample:

123456 Joe Doe loan Amt: 50000 number of years 30
123456x2nd Joe Doe Loan Amt: 10000 number of year 10

I want my report to display in the details section:

Joe Doe loan amount 50000 30 years
loan amount 10000 10 years

RE: Best Practices for linking two data sets into one

If you group on a formula:

Left({table.mortageID},6)

...you should get the desired display. You can format the name field to “suppress if duplicated”.

-LB

RE: Best Practices for linking two data sets into one

One option is to create a database VIEW or a Crystal Command as the data source for the report and use a UNION ALL in the SQL:
Select * From mortgage
UNION ALL
Select * From SecondMortgage

view, export, burst, email, and schedule Crystal Reports.
www.MilletSoftware.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close