Print Page | Close Window

Basic Help

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17658
Printed Date: 01 May 2024 at 2:25am


Topic: Basic Help
Posted By: SamuelFogarty
Subject: Basic Help
Date Posted: 28 Sep 2012 at 11:58pm
Hello,

I am very new to Crystal Reports and I am trying to grapple with the basics. Say I have a simple table, that is:
ID_Number, Name, Child_ID_Number.

And what I need to do is 'Display the name of the person of ID_Number '10' and the name of their child.'

This would require two SQL queries - one dependant on the result of the other.

So my report will have two name fields. I could use the 'select record expert' to get the data associated with ID_Number '10' but that's only halfway there.

I need the second field to understand its relationship with the first. What is the right way to go about this?
Formula fields? The select expert?
Thank you for any help.




Replies:
Posted By: SamuelFogarty
Date Posted: 29 Sep 2012 at 7:59pm
Nevermind. I figured it out.



Print Page | Close Window