How can I change the structure of a column in oracle report builder

Question

How can I change the structure of a column in oracle report builder

Navigation

#1 by (0 votes)

0

Good morning,

I am currently managing oracle report builder 11g for the modification of a report, the report is created by means of a PL / SQL query but due to some changes there was a "Total" column with a structure number (9.2) and I had to change it to number (12,6), I made the change in the database but it does not let me change the structure in the oracle report builder and I do not know how to modify it since the "width" is not editable in the options where the structure is shown I appreciate any help and recommendation.

oracle-11g plsql

asked by Juan Sebastian 30.06.2016 в 01:41

source

1 answer

Help with error in process stored in sql vb.net Update datatable to MySQL

score 0 · Answer 1

In the Oracle Reports data model section, in the tool palette you must click on Formula Column (f (x)) , to create a function. In that function created you double click and go to the option "Formula PL / SQL" there you put your code that can be the following: function CF_1Formula return Number is v_total number(12,6); begin select total into v_total from tabla where condicion1 = :P_PARAMETRO1; return v_total; end;

Then you just have to create an empty field in your report design, to that field you give F4 and one of the options is ORIGIN there you search and select your < strong> CREATED FUNCTION .