Link to home
Start Free TrialLog in
Avatar of navtarainc
navtarainc

asked on

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

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.


ASKER CERTIFIED SOLUTION
Avatar of ast2550
ast2550

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Forced accept.

Computer101
EE Admin