Multiple field calculations

[Dleners]

Let me begin by saying that I am a new R&R user. I have joined about 5 tables and am trying to perform basic calculations on some of the data. When verifying my syntax, the expressions are OK. The data will show up in my result set. However, it is not printing on the report through the field I^m calling out. Here are some of the specifics:____I would like to calculate labor costs for each work center within a job order. To begin with the estimates, I link the sales order tables to the sales quotes tables via the sales order number. I then set up SQL statements in the calculated fields menu like this:____IFF(FPRO_ID="E*",FSETUP,0) ____to get the engineering setup time to print on the report. I repeat this for all of the diferent FPRO_ID^s (for both setup and production time). While the result set shows each engineering line with its corresponding time, it does not print on the report. I get zeroes. Hence, I tried totaling the fields representing the SQL statement written above. Still the data is not printing. What am I doing wrong here? I appreciate any suggestions. Thanks - DML

[kfleming]

>Let me begin by saying that __>I am a new R&R __>user. I have joined __>about 5 tables and am __>trying to perform basic calculations __>on some of the data. __> When verifying my syntax, __>the expressions are OK. __>The data will show up __>in my result set. __>However, it is not printing __>on the report through the __>field I^m calling out. __>Here are some of the __>specifics: __>__>I would like to calculate labor __>costs for each work center __>within a job order. __>To begin with the estimates, __>I link the sales order __>tables to the sales quotes __>tables via the sales order __>number. I then set __>up SQL statements in the __>calculated fields menu like this: __>__>__>IFF(FPRO_ID="E*",FSETUP,0) __>__>to get the engineering setup time __>to print on the report. __> I repeat this for __>all of the diferent FPRO_ID^s __>(for both setup and production __>time). While the result __>set shows each engineering line __>with its corresponding time, it __>does not print on the __>report. I get zeroes. __> Hence, I tried totaling __>the fields representing the SQL __>statement written above. Still __>the data is not printing. __> What am I doing __>wrong here? I appreciate __>any suggestions. Thanks - __>DML ______

[kfleming]

Try placing the fields FPRO_ID and FSETUP on the same record band line as your calculation so that you can see their individual values.____Kathleen__R&R Support