Print Page | Close Window

formula needed

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=12258
Printed Date: 18 May 2024 at 12:42am


Topic: formula needed
Posted By: 4sue2c
Subject: formula needed
Date Posted: 08 Feb 2011 at 4:17am
I would like to show a report with all products sold on an invoice if one specific product is tagged. The report fields are Invoice_no and Stock_num. How is this done, what is the formula?

When I enter stock_num sold = "the product" it will only return invoices showing that specific stock number. I need all the products sold on that invoice to show as well. Please help.





Replies:
Posted By: DBlank
Date Posted: 08 Feb 2011 at 4:52am
I tried to answer this in your other post and am not sure where you were having problems.
Greoup on Invoice_no
Create a formula called 'flag' as:
If {table.Stock_num}=" your certain product here" then 1
 
Now insert a Summary using this formula field 'flag'
Click on the Sigma sign (looks like an E)
select the formula field name 'flag'
calculate the summary as: SUM
Summary location = group footer - select the invoice number group
This wil insert a summary field in the group footer.
 
Go into your select expert cahneg it to a ghroup Select and use your condition here
SUM(flag,Invoice_no)>0

Posted By: 4sue2c
Date Posted: 08 Feb 2011 at 4:08pm
Hi, I did everything you wrote right up to the last part,
when you wrote "Go into your select expert cahneg it to a ghroup Select and use your condition here
SUM(flag,Invoice_no)>0".

Are you saying to select the flag formula in select expert and enter "SUM(flag,Invoice_no)>0" as a formula entry?

Thanks again and sorry if I sound stupid.

Posted By: 4sue2c
Date Posted: 09 Feb 2011 at 3:15am
I got it to work thank you very very very much!


Print Page | Close Window