Solved

In Crystal reports how to fetch the data fromthe dataset according to the condition

Posted on 2007-11-16
3
405 Views
Last Modified: 2013-11-26
Hi all,
               I have two datasets without any defined relation ship as follows
                       
dataset 1 --
with following columns
client name,  amount, benefit, company

and secound dataset 2 --
with the following columns
client name, amount

I have to compare the amount in the 2nd dataset with the amount in the first dataset for each and every client. 2nd dataset amount will always larger or equal to the 1st dataset amount.

I need to display this just after displaying the row of 1st dataset.

So I want to compare the client name form both the dataset and want to fetch the row from 2nd dataset just like " select * from 2nd dataset where client name=1st dataset.clientname". I am planing to store the reults in formula fields everytime and display after row from 1st dataset.

So what are the possible ways to do this please give steps also to do this.


0
Comment
Question by:navtarainc
3 Comments
 
LVL 7

Accepted Solution

by:
ast2550 earned 500 total points
ID: 20300142
Add both of your tables to the report, join them using 'Client Name' and insert your fields.  If you need to display [DataSet2].amount - [Dataset1].amount, then YES a formula field is the way to go.

This is a fundamental usage of Crystal Reports.  Do you have much experience with CR and I'm misunderstanding or is this new and I should provide more detailed description of the tasks to be performed.
0
 
LVL 1

Expert Comment

by:Computer101
ID: 20511476
Forced accept.

Computer101
EE Admin
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question