| Author |
 Topic  |
|
|
lfessler
26 Posts |
 Posted - 04/09/2018 : 15:05:39
|
Version:
ReportPortal 5.0, Build 198
Issue:
This was not an issue until installing build 198. It may have been introduced in one of the preceding builds since I just upgraded from 194 directly to 198.
I create an OLAP report with one of the dimensions being 'Item' with Key and Name as 'Item Code' which is an NVARCHAR in the database and shows as WCHAR in SSIS cube designer. This field is mostly, but not all, numbers. Many of them contain leading zeroes such as '00112'. When this report is exported to Excel, the field is formatted as General and the leading zeroes are dropped leaving me with '112'. Can this field be exported as Text?
|
Edited by - lfessler on 04/09/2018 15:06:30 |
|
|
admin
1635 Posts |
|
|
lfessler
26 Posts |
Posted - 04/10/2018 : 11:57:39
|
| I'm not very familiar with the AdventureWorks SSAS cube. Is there a dimension member that has numbers with leading zeros, but is defined as a string type? I looked through, but didn't immediately see any. |
Edited by - lfessler on 04/10/2018 11:57:53 |
 |
|
|
admin
1635 Posts |
Posted - 04/10/2018 : 21:57:28
|
Try:
Customer - Demographic - Commute Distance - 0-1 Miles
Product - Large Photo - Financial - Standard Cost and List Price
|
|
|
|
lfessler
26 Posts |
Posted - 04/11/2018 : 07:57:20
|
I put a report together, but I was unable to download. Chrome gave an error (see below) and IE just didn't generate a download file. I saved my report into the admin My Report folder under 'Leading Zeros Download to Excel Test'.
Chrome error:
Print/Excel var sExcelExt = "xlsz"; var bExportExcelImage = (""=="True"); var bLocalize = false; var bDataOnly = false; var bExcelFilterSplit = false; var sError = ""; var sPage = "OLAP"; var sSessionID = "ndxxhtvzovkisssao5f4bef3"; var sAppUrl = "http://reportportal.us/reportportal/"; var sDecimalSeparator = "."; var sThousandsSeparator = ","; var oLabels = []; oLabels[1060]="No root node found:"; oLabels[454]="There is no data to export"; oLabels[857]="To export the chart image to Excel please:\n open the generated file in Excel, cut the chart image and paste it special as Picture."; Loading... |
|
|
|
admin
1635 Posts |
|
|
lfessler
26 Posts |
Posted - 04/11/2018 : 10:25:04
|
Thank you, but I understand that error was previously fixed. However, you asked me to recreate the report/error on build 194 of your demo server. I tried to do that, but when I went to download the report from demo 194, I ran into the error I posted above.
Thanks.
|
|
|
|
admin
1635 Posts |
Posted - 04/11/2018 : 21:57:12
|
The Chrome bug should be fixed after you clear the cache.
I takes about 70 seconds to export the excel file with the chart and 40 secs without the chart. |
|
|
| |
Topic |
|
Report Portal
SQL Report Export to xlsx - Text Formatted General
