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