Do not show less then 1

[CRilliterate]

I ran into this. My data in SQL Server

Prod EQ TotEQ Amount

ABC 1.000 3 $100
ABC .060 1 $10
ABC .250 1 $1

To pull EQ field I was suppose to multiply EQ*10.
Now in Crystal when I am pulling this field it brings only those 1.000 and not .060 and .250.

Calculation totally screwed.

________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server

 

[synapsevampire]

Create a SQL Expression of:

table.eq * 10

Now SQL Server will do the work (better performance) and you'll have a new field prepopulated with the results.

-k

 

[CRilliterate]

I did that. My SQL includes table.eq * 10 after which results are 1.000, .060 and .250

What do I do now?

________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server

 

[lbass]

Can't tell what the problem is here. Please provide more info. Are these results in the detail section or in a crosstab?

-LB

 

[CRilliterate]

Data I get in SQl running query is

Prod EQ TotEQ Amount

ABC 1.000 3 $100
ABC .060 1 $10
ABC .250 1 $1

This result I am getting AFTER table.eq * 10 which included in my query.

But is is abviously too small still. Because Crystal can't see those 2 records that are less then 1.

________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server

 

[lbass]

You haven't added any new information, and you didn't answer my question. I don't know what you mean by the last line. What is it that is showing up in CR, and where is it showing up--in the detail or in a crosstab?

-LB

 

[CRilliterate]

Sorry,
in details.

It suppose to show:

Prod EQ TotEQ Amount
ABC 1.310 5 $111

Instead it shows:

Prod EQ TotEQ Amount
ABC 1.000 3 $100

THANKS



________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server

 

[CRilliterate]

I got it by selecting System Number, it was rounding up.
THANKS

________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server