Help with Variables 1

[Tatertot45]

I'm having a hard time recalling how to accomplish what i need. I'm using CR XI, with a SQL Datawarehouse. I have invoice data,in the form of Line items. There is sometimes one item that is given a 100% discount. I want to isolate that Item and display it in the Group Header. I'm grouping based on Order number of the invoice. I'm summing the item prices, displaying some other data, and i want to display the item description of the item given a 100% discount. i thought about using a string Variable, but can't get it to work. Basically, if the Inv.item-discount equals 100% then display the Item Description, otherwise display NA, or leave blank.



Any help would be apprciated.

 

[lbass]

Create a formula like this:

if {invoice.discount} = 100 then
{item.description}

Place this in the detail section and then insert a maximum on it at the group level and drag the result into the group header.

-LB

 

[Tatertot45]

Works great. Thanks for the help.