Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help for a report I created a few years back..

Status
Not open for further replies.

bobbyr

Programmer
Nov 30, 2000
66
US
Hello, I have a report that I created a few years back that displays different departments of a company ("Type of Metal") and pulls current jobs ("Customer info") that are within each department. The report layout looks like the following:

------------------------
- Group1: Type of Metal
---------------------------
- Details: Customer Name P.O.# Received Date
---------------------------
------------------------

I now need to limit the report to a single customer and display only those jobs - without displaying the other departments that this customer does not have an active job in. What is the best way to do this?

Thanks,
Bobby
 
Have you tried a record selection formula?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown
 
Go to report->selection formula->record and place something like:

{table.cusotmer}= "My Customer"

-k
 
Thanks guys - that was exactly what I was looking for. I haven't worked in Crystal Reports in ages!

Bobby
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top