Print Page | Close Window

Getting specific records within a table

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11253
Printed Date: 28 Apr 2024 at 8:48pm


Topic: Getting specific records within a table
Posted By: PeterG
Subject: Getting specific records within a table
Date Posted: 28 Sep 2010 at 12:29pm
I am a new CR user. I am using CR9. I am being asked to do a report that requires me to get specific records in a table and use it as a paramater. The table fields and sample data in each field are: TABLE_NAME <PROVINCE, PSI_NAME, etc.>, CODE <NU, ACC, etc.>, SUBSTITUTE, UPPER CODE & DESCRIPTION <Ontario, Acadia University, etc.>.
 
I only need to get and use the data in the DESCRIPTION field AND ONLY records with PSI_NAME in the TABLE_NAME field. Then I will use the data in DESCRIPTION FIELD as my parameter.
 
I hope I made myself clear in here but I would really need any help on this.
 
Thanks,
PeterG


-------------
PeterG
Novice User


Print Page | Close Window