datatechcorp
asked on
Crystal Suppress Page Footer Based On Line Items
Hello...
We are creating a simple Invoice Form for a customer. What's required...is that "IF" a "Particular" Line Item is included on the transaction, "THEN" we need to print out Various Instructions Text on the Report Footer. But, again, ONLY if such "widget" is sold. The transaction itself could be comprised of a single Line Item, or 100's of lines.
This conditional output at the Report Footer level...is where this output MUST exist; it cannot be displayed, in the 'body' of the invoice forms.
Any clue how to achieve this? I'm guessing (more or less) that some type of memory variable is required, to enable a "Flag" (for example)...and when such flag becomes "True"...then do the Report Footer Text Output. We need to know the syntax as well please. We understand the concept, but lack the general "syntax" knowledge.
Any help/guidance would be appreciated. Thank you!...Mark
We are creating a simple Invoice Form for a customer. What's required...is that "IF" a "Particular" Line Item is included on the transaction, "THEN" we need to print out Various Instructions Text on the Report Footer. But, again, ONLY if such "widget" is sold. The transaction itself could be comprised of a single Line Item, or 100's of lines.
This conditional output at the Report Footer level...is where this output MUST exist; it cannot be displayed, in the 'body' of the invoice forms.
Any clue how to achieve this? I'm guessing (more or less) that some type of memory variable is required, to enable a "Flag" (for example)...and when such flag becomes "True"...then do the Report Footer Text Output. We need to know the syntax as well please. We understand the concept, but lack the general "syntax" knowledge.
Any help/guidance would be appreciated. Thank you!...Mark
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
FWIW, another way to handle something like this would be to create a count of the lines that include the item in question. That would be a little simpler, because it doesn't require a variable, or as many formulas.
Create a formula (let's call it widget_count) like this :
if {field} = "that item" then
1
else
0
Then you could use a formula like this in the report footer:
if Sum ({@widget_count}) <> 0 then
"instructions"
Or, instead of using a formula to display the instructions, you could just put the instructions in a text field in the report footer section, and then use Sum ({@widget_count}) = 0 to suppress that text field, or maybe the entire section, when you don't have that item.
James
Create a formula (let's call it widget_count) like this :
if {field} = "that item" then
1
else
0
Then you could use a formula like this in the report footer:
if Sum ({@widget_count}) <> 0 then
"instructions"
Or, instead of using a formula to display the instructions, you could just put the instructions in a text field in the report footer section, and then use Sum ({@widget_count}) = 0 to suppress that text field, or maybe the entire section, when you don't have that item.
James
ASKER
Hi James...that's too simple, and I'm embarrassed that I didn't think of that myself. :-)
Brilliant amigo...thanks for the tip!...Mark
Brilliant amigo...thanks for the tip!...Mark
Hey, sometimes you can't see the forest, etc., etc. :-) Happens to all of us. You're welcome.
James
James
ASKER
:-)
ASKER