Recent content by dkeller

I found the problem. Thanks for all your help. I was using the variable field in another calculation in the group footer. The other formula was used to calculate average sales per customer type. If {@LYOBCountDiv} = 0 then 0 else {@TYOBSumPrt}/{@LYOBCountDiv} I changed this to If...

Yes! Here is the reset formula. The variables are resetting, the only problem is the extra count from the last customer footer record. WhilePrintingRecords; NumberVar TYSameCountDiv:= 0; NumberVar LYSameCountDiv:=0; NumberVar TYNewCountDiv:= 0; NumberVar LYOBCountDiv:=0; NumberVar...

I had this problem on several reports that someone else wrote for our company. They all had blank report headers. I suppress the print on the report header and the blank pages went away.

I am. Here is the formula to set the variable //@LYOBCountDiv WhilePrintingRecords; NumberVar LYOBCountDiv:=iif({@LYOB} <> 0, LYOBCountDiv +1, LYOBCountDiv); Is that the one you where referring to?

I have a Variable formula to count the number of customers that are New, returning, or Out of Business. I have a variable formula for each incrementing the count by one based on their sales. These variables is in the group footer for the customer. I created separate variable to print the total...

Krickles, Thanks for the response but I think I have it figured out. I was unable to use the field as a selection field in CR. The field is defined as a charvar with a length of 2000. In the view I just pulled out the number of positions that I needed (10 Pos.) with a substring and I was then...

I created a view over an SQL table that selects out only certain record types. The view includes 3 columns. Record Type Record ID Value The original Table contains many Record types that I need to access seperately so I created a seperate view for each record type I need, each view containing...