ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

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

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
lfessler	Posted - 11/18/2016 : 10:32:12 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.
2 L A T E S T R E P L I E S (Newest First)
lfessler	Posted - 11/19/2016 : 12:11:07 Great! That worked perfectly! Thank you.
admin	Posted - 11/19/2016 : 02:24:32 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

ReportPortal