ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Exporting SQL reports to Excel
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

fdranguet

France
82 Posts

Posted - 02/06/2012 :  09:34:29  Show Profile  Reply with Quote
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

admin

1644 Posts

Posted - 02/06/2012 :  20:49:05  Show Profile  Reply with Quote
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.
Go to Top of Page

fdranguet

France
82 Posts

Posted - 02/07/2012 :  02:35:44  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page