Report Portal

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
 Export to Excel in OLAP Drillthrough		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

lfessler

26 Posts
Posted - 11/18/2016 :  10:32:12  Show Profile  Reply with Quote
Using build 194... When using the Export to Excel in the Drillthrough on an OLAP report, I have a dimension attribute (identified in the cube as WCHAR) that is exported with automatic formatting instead of being formatted as Text.

For example, one of the values in the column is '00538', but Excel is showing it as '538.00'. Unfortunately, at that point, I can't just convert the column back to text because it converts it to '538', dropping the leading zeroes.

Is there a way to force column formatting (based on dimension/measure attribute properties)?

Thanks.

admin

1637 Posts
Posted - 11/19/2016 :  02:24:32  Show Profile  Reply with Quote
Please try this fix:

1. Download and unzip: http://www.reportportal.com/download/rp_194_Drillthrough.zip

2. Backup old files and copy unzipped files to:
"C:\inetpub\wwwroot\ReportPortal\olap\DrillthroughSelect.js"
"C:\inetpub\wwwroot\ReportPortal\olap\Drillthrough.js"
"C:\inetpub\wwwroot\ReportPortal\olap\DrillthroughSelect.aspx"
"C:\inetpub\wwwroot\ReportPortal\olap\Excel.js"

3. Clear browser cache
Go to Top of Page

lfessler

26 Posts
Posted - 11/19/2016 :  12:11:07  Show Profile  Reply with Quote
Great! That worked perfectly!

Thank you.
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