?
Solved

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

Posted on 2007-11-16
3
Medium Priority
?
408 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 2000 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

Monthly Recap

May was a big month for new releases from Linux Academy! Take a look at what our team built recently in our blog. You can access the newest releases from our blog.

Question has a verified solution.

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

In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

777 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