Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

report builder ,create file with TAB

Status
Not open for further replies.

ang21

Programmer
Dec 1, 2004
1
SK
HI,
I need to create file a.txt with REPORT BUILDER be like this:
sum(a)||ch(9)|| sum(b)
1 ||a1)||ch(9)|| b1
2 ||a2)||ch(9)|| b2
3 ||a3)||ch(9)|| b3
..
.
.
n ||an)||ch(9)|| bn



result of my report is file but instead mark "TAB" there is space

first row I create with :

function CF_sumrowFormula return varchar2 is
tm varchar(1):= chr(9);
begin
sumrow:= ltrim(to_char:)cs_a,'999999'))||tm ||
ltrim(to_char:)cs_b,'999999'))||;
return(sumrow);
end;



another with:

function CF_rowFormula return varchar2 is
tm varchar(1):= chr(9);
begin
sumrow:= ltrim(to_char:)n,'999999'))||tm ||
ltrim(to_char:)a,'999999'))||tm ||
ltrim(to_char:)b,'999999'))||;
return(sumrow);
end;


Thanks .
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top