Home » Developer & Programmer » Reports & Discoverer » Strange Output in excel (6i,Application Server 10g)
Strange Output in excel [message #388108] Mon, 23 February 2009 04:23 Go to next message
sirfkashif
Messages: 70
Registered: September 2007
Location: Rawalpindi
Member
Dear all,
I have a report in which there is a column naming comments of varchar2(2000) type, i put that column at the end of report and expanded it until i could get that column against each record(as it was a lengthy column).

when i run it from url, the spreadsheet output shows that column spanned over many rows, even though i set horizontal elasticity to variable and vertical elasticity to fixed,
which by the way works fine in live previewr of reports 6i.

Any help will be appreciated.

Regareds,
Kashif
./fa/5775/0/
  • Attachment: web_error.gif
    (Size: 36.76KB, Downloaded 291 times)
Re: Strange Output in excel [message #388113 is a reply to message #388108] Mon, 23 February 2009 04:42 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Check Excel cell's "Format Cells" properties. Is this cell's "Wrap text" checked? If so, uncheck it.

./fa/5776/0/
Re: Strange Output in excel [message #388117 is a reply to message #388113] Mon, 23 February 2009 05:07 Go to previous messageGo to next message
sirfkashif
Messages: 70
Registered: September 2007
Location: Rawalpindi
Member
Thanks for reply, But if i unwrap it,it gives me something like below which is far away from my expected output i.e.lot of spacing between each record and also this report will be generated by many many user and i don't expect everyone of them to unwrap cell's property so i have to do something at design time.

Regards,
Kashif ./fa/5777/0/
Re: Strange Output in excel [message #388121 is a reply to message #388117] Mon, 23 February 2009 05:28 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Take a look at your screenshot, pay attention to row number 6. See how it is wider than rows 1, 2, 3, 4, 5? It means that its "Row height" should be adjusted. Unfortunately, I wouldn't know how to do that on the Oracle side.

By the way, how do you export information from Reports to Excel?
Re: Strange Output in excel [message #388126 is a reply to message #388121] Mon, 23 February 2009 05:50 Go to previous message
sirfkashif
Messages: 70
Registered: September 2007
Location: Rawalpindi
Member
when i unwrap from format cell option, space was automatically created between rows, which i don't want and to convert report to excel on i use below URL

http://localhost:7778/reports/rwservlet?destype=cache&desformat=spreadsheet&report=d:pathofreport.rdf&userid=test/test@or cl&PARAMFORM=yes

Regards,
Kashif
Previous Topic: Change the Initial Value in User Parameter Field
Next Topic: Parameter Form: Word wrap a parameter field
Goto Forum:
  


Current Time: Fri Dec 02 12:24:56 CST 2016

Total time taken to generate the page: 0.06890 seconds