Solved

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

Posted on 2007-11-16
3
406 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Get sourcecode path 14 47
SSIS GUID Variable 2 37
Installing .NET 3.5 on Windows Server 2012 1 62
T-SQL and CLR parameter strings 9 29
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
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…

726 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