In Crystal reports how to fetch the data fromthe dataset according to the condition
Posted on 2007-11-16
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.