Get seperate DB records in a cross table with a formula

[Former Member]

Hi,

As my question suggests, I'm a beginner in Crystal Reports. I simply want to extract records from database and apply a formula on them at the same time.

I tried to create this formula :

WhilePrintingRecords;

ToNumber (Mid(Right (totext({ ...

The objective is to apply a formula to have a result for each column, but as you can see in the attached screeshot (red boxes), it only keeps the last column calculation.

Then a less important issue, what is this "second total column" (blue box) and how to get rid of it? 

Cheers,

Adam

[abhilash_kumar]

Hi Adam,

What is the formula you're tying to insert?

Could you elaborate more on what you're trying to do?

-Abhilash

[Former Member]

Here is the formula:

WhilePrintingRecords;

ToNumber (Mid(Right (totext({table2.field1}),8 ),1,2))*3 + ToNumber(Mid(Right (totext({table2.field2}),8 ),4,2))

The cross table is matching records from table 1 (lines: IMXXXX...) and table 2 (Columns:Application...)

I know this part is working fine because I tried it seperately:

ToNumber (Mid(Right (totext({table2.field1}),8 ),1,2))*3 + ToNumber(Mid(Right (totext({table2.field2}),8 ),4,2))

Is it clear enough or still not?

[abhilash_kumar]

Still not sure what you're trying to do in the crosstab.

Do you have some screenshots of what you wish to achieve with the crosstab?

-Abhilash