This discussion is archived
10 Replies Latest reply: Oct 18, 2013 2:10 AM by Sattu28 RSS

Text format appears to be diffrent while retrieving from FR

Sattu28 Newbie
Currently Being Moderated

Hi All,

 

We have a Financial report , designed with the help of FR studio. One of Columns of this FR is named "Affiliate Id " Which is pulling a unique ID for different companies. These Affiliate Ids are being pulled out from a data form where the entries are being submitted with the help of Smartview / Workspace.

 

Now the issue is that when FR is Run then the Affiliate Ids are Displayed in the following form: i mean the numeric values are being displayed Upto 6 decimal Places which is not the Way its should be and we want it to be without any decimal value as they are submitte in data form without any decimal value.Irony is that in the same FR we are getting the values in one another column(Governmenr Id) in proper way( Shown Below )

 

Affiliate ID

                        

1063.000000
1063.000000
Aff ID Undefined
1557.000000
1489.000000
1063.000000

 

Government ReportID

 

31480
31709

 

In both The Columns, Values are being pulled as celltext and formulaes being used are:

 

For Affiliate ID:

<<CellText("Grid1", Cur, C(A), 1)>>


For Government ReportID:

<<CellText("Grid1", Cur, D(B), 1)>>

 

So Please help in knowing that what may be the possible cause of Affiliated ID being deisplayed with such huge decimal values how i can correct that, through FR studio or from workspace/ Data form from where it is being pulled.

Note:Even if we See the Affiliated ID in data form after submitting and refreshing, its picking decimal places there also same way.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points