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

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 SQL Report Export to xlsx - Text Formatted General
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

lfessler

26 Posts

Posted - 04/09/2018 :  15:05:39  Show Profile  Reply with Quote
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

1609 Posts

Posted - 04/09/2018 :  22:08:21  Show Profile  Reply with Quote
Here is build 194 on the demo server. Can you please see if you can reproduce this problem?

http://www.reportportal.us/ReportPortal194/Login.aspx
Go to Top of Page

lfessler

26 Posts

Posted - 04/10/2018 :  11:57:39  Show Profile  Reply with Quote
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
Go to Top of Page

admin

1609 Posts

Posted - 04/10/2018 :  21:57:28  Show Profile  Reply with Quote
Try:
Customer - Demographic - Commute Distance - 0-1 Miles
Product - Large Photo - Financial - Standard Cost and List Price
Go to Top of Page

lfessler

26 Posts

Posted - 04/11/2018 :  07:57:20  Show Profile  Reply with Quote
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...
Go to Top of Page

admin

1609 Posts

Posted - 04/11/2018 :  09:57:46  Show Profile  Reply with Quote
http://www.reportportal.com/forum/topic.asp?TOPIC_ID=2119
Go to Top of Page

lfessler

26 Posts

Posted - 04/11/2018 :  10:25:04  Show Profile  Reply with Quote
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.
Go to Top of Page

admin

1609 Posts

Posted - 04/11/2018 :  21:57:12  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Forum © ReportPortal Go To Top Of Page
Snitz Forums 2000