Conditional Field Not Showing up in report Fields

[TanmedIT]

I have a field called ItemCount with the following formula:

If (PreviousIsNull ({ARLINH.Shipqty}))
then
{ARLINH.Shipqty}
else
If ({ARLINH.Docdate} = Previous ({ARLINH.Docdate}) and {ARLINH.Shipqty} = Previous ({ARLINH.Shipqty}) and {ARLINH.Itemkey} = Previous ({ARLINH.Itemkey}))
then 0
else
{ARLINH.Shipqty}

In the detail line it works fine, but when I try to use it in a running total it doesnt show up in the report fields window. I am using CR 7.0.

Any Ideas?

 

[ABerkowicz]

Are you trying to get at a total for {ARLINH.Shipqty}? You can use variables to keep track of a running total.

Create a variable in the header section like this (to initialize):
whileprintingrecords;
numbervar total:0

Create a variable in the details section like this (to start adding the amounts):
whileprintingrecords;
numbervar total:=total+{ARLINH.Shipqty}

Create a variable in the report section like this (will display answer):
whileprintingrecords;
numbervar total:=total

Hope this helps.
Angela

 

[TanmedIT]

I am trying to get rid of the duplicates. I have made this formula and it works in the detail line:

If PreviousIsNull ({ARLINH.Shipqty})
then
1
else IF (Previous ({ARLINH.Docdate}) = {ARLINH.Docdate} and Previous ({ARLINH.Itemkey}) = {ARLINH.Itemkey} and Previous ({ARLINH.Shipqty}) = {ARLINH.Shipqty})
then
0
else
1

But when I try to use it in a running total or selection expert, it doesnt show up in the report fields section. If I manually type it in a formula and place it in a group header, the report doesnt run. HEEELLLLPPPP. I just want all the records that have a "1" from this report to be totaled.

 

[TanmedIT]

I figured it out.. Thanks a bunch

 

[Guest_imported]

How to create variable columns in report.....using sql statement thru coding.....not by drag and drop method.....

waiting your reply

your
padam