ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Exporting SQL reports to Excel

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
fdranguet Posted - 02/06/2012 : 09:34:29
Hello,

with the latest RP build (177), I have one issue that did not exist in the previous one (176): on some SQL reports, I included some html code in the SQL query in order to have specific formatting for those reports. It would be something like:

select '

'+FieldName+'

'
from TableName

This is still fine when you display the report from ReportPortal. However, as soon as you try to export it to Excel, that added html code will actually not be interpreted but will display within the Excel sheet.

Is there any way to fix that ? Many thanks.

Regards,
François Dranguet
Information Manager
Ingénieur Systèmes

Scott Bader SA
Tél : +33 (0)3 22 66 27 77
2   L A T E S T    R E P L I E S    (Newest First)
fdranguet Posted - 02/07/2012 : 02:35:44
Hello,

I requested the hot fix and applied it - I confirm it is working again perfectly now. Many thanks for providing a solution that fast ! Your support is worth the cost.

Regards,
François Dranguet
Information Manager
Ingénieur Systèmes

Scott Bader SA
Tél : +33 (0)3 22 66 27 77
admin Posted - 02/06/2012 : 20:49:05
Build 177 resolved the problem of Excel treating text data as numbers. It included the text value in x:str attribute. Apparently, this introduced a problem with HTML encoding.

This problem will be resolved in build 178. Please contact support@ReportPortal.com if you need an immediate hot fix.

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page