Help with formatting a Float DB field, losing precision.

BIRT version 3.7.1 I have a database field regularhrs defined as float(126) My output column is defined as type: Float The Edit Data Binding type is : Float I cannot get this field to display correctly. I am losing precision.DB values of .25 are coming out at 0 I have tried various values for the output column, Edit Binding Type, and the fieldsproperties Format Number (Format, Decimal Places, and Rounding Mode) Anyone know what combination of the Output column, binding type, and Properties (format number) will work ? Also, how can I force a decimal field to print the two positions to the right of the decimal, even if the numbers are .00 ? Thanks much

Find more posts tagged with

Comments

kclark

When you preview the data in your data set is it returning correctly? If you're having a problem with how it's being displayed in some report item you can use toFixed()<pre class="_prettyXprint">var currentValue = parseFloar(this.getValue);this.value = currentValue.toFixed(2);</pre>

cjm13905

<blockquote class="ipsBlockquote" data-author="kclark" data-cid="119923" data-time="1378321419"><div> When you preview the data in your data set is it returning correctly? If you're having a problem with how it's being displayed in some report item you can use toFixed()<pre class="_prettyXprint">var currentValue = parseFloar(this.getValue);this.value = currentValue.toFixed(2);</pre></div></blockquote>I'm a newbie, with limited training to date. I have the BIRT A Field Guide manual on-line but it is for BIRT 2.6 and we are at 3.7I don't see how to preview the data. I've opened up the Data Source.Clicked on Preview Results and no records.I added a filter but still no records I know it is a lot to ask, but if you have any ideas,or can guide me how to use the preview in 3.7 I'd be in your debt.And if you can point me to better online documentation for 3.7 that would be great. I should mention, I use BIRT to report off of Maximo application. In BIRT 3.7.1 the data source has a "Select Data Source" option, which is set to maximoDataSource. The actual sql is in the open/fetch script for the Dataset.

BRM

right click on the data set (not the data source) and select edit (top choice). In the dialog that results which should have your query in it, preview results should be the last entry on the left panel.

cjm13905

<blockquote class="ipsBlockquote" data-author="BRM" data-cid="119930" data-time="1378324698"><div>right click on the data set (not the data source) and select edit (top choice). In the dialog that results which should have your query in it, preview results should be the last entry on the left panel.</div></blockquote>Yes, I've done that but it is selecting 0 records.There is a parameter into the report called wonum, a valid value being 101010. I've tried the preview as you stated with 0 records.I've added a parm (wonum default value = 101010 ) and still 0 records.I honestly don't see how there is a connection between the data set and the actual Oracle table until I create sql in the open and fetch script for the dataset, I don't know how this preview can work without the connection to the sql in the open and fetch scripts.Again, I am on BIRT 3.7.1. I think the dataset creation has changed from prev releases.

BRM

If the preview is selecting no records then how are you getting data in the report when you run it? Preview should select the same data as the report when run with the default parameters. Your original post suggests that you get some sort of output.

cjm13905

<blockquote class="ipsBlockquote" data-author="BRM" data-cid="119944" data-time="1378391576"><div>If the preview is selecting no records then how are you getting data in the report when you run it? Preview should select the same data as the report when run with the default parameters. Your original post suggests that you get some sort of output.</div></blockquote>I am new to BIRT, and have only seen version 3.7.1 When I run the report I do get data. After trial and error, this is what I did.I updated my sql in the open, for the dataset, and hardcoded all values that were being passed as parms.I was then able to run the preview with data being displayed.

BRM

I'm glad you got it to work. Perhaps you didn't specify default values for your parameters. That will cause the behavior you describe.