ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 SQL Report Export to xlsx - Text Formatted General

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
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
lfessler 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?

7   L A T E S T    R E P L I E S    (Newest First)
admin 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.
lfessler 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 Posted - 04/11/2018 : 09:57:46
http://www.reportportal.com/forum/topic.asp?TOPIC_ID=2119
lfessler 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 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 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.
admin Posted - 04/09/2018 : 22:08:21
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

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page