Calrity Reporting "Features"

[Paul Schofield]

Hello again everyone,

Following on from my earlier posts, I'm trying to replicate some large extracts that currently use Jaspersoft to generate an excel file in the new Clarity reporting. I've had some success but there are a couple of "features" that I can't find a way round.

The generated file is processed by an external system and these features break the processing.

Problem 1:

The .csv file contains two header rows:

Row one is the name of the underlying query. Row 2 is the label for the attribute.

I'd like to suppress row 1 and have just the labels as column headers.

Problem 2:

When users open the file in Excel, all numeric fields have been imported as text even though the report fields are numeric. The problem appears to be with locales. I can import it without any problem, but French speaking users can't.

The .csv file uses a comma as the delimiter, no matter what locale I select for the export when scheduling the report.

Is there a way to tell Clarity to use a semicolon for the delimiter as that's what Excel seems to need when the locale is a French one?

-------------------------------------------

[Suman Pramanik]

Hi Paul

Here is what I did to test this out in 16.4.2 for Problem 1 

• Created a report based on Resource, Roles and Teams 
• Used the table widget and added columns like Name, Full Name etc
• Used the feature export to excel while previewing
• In Excel I dont see labels duplicating
• Published the report and used the same Export to Excel within the Widget and result is same  

Can you explain more how the report was created 

------------------------------
Thanks & Regards
Suman Pramanik
------------------------------

[Paul Schofield]

Hi Suman,

I created a new data source based on a query and gave the attributes proper names using the labels. I then used this to create a report that sends the output to a CSV file.

This is scheduled and emails the results.

-------------------------------------------

[Suman Pramanik]

Let me test that out and see 

------------------------------
Thanks & Regards
Suman Pramanik
------------------------------

[Paul Schofield]

Thanks Suman

[Ming Cheung]

Hi Paul,

Question 1: additional header row was addressed in release 16.4.1, behind a feature toggle.  

The report designer will still show the second column while designing the report but it will be removed when you generate the CSV.  You can also use the Hamburger menu to rename the column name to keep your columns straight and match your desired output.

For the number format issue, you should join our Reporting Office hours sessions on Mondays and Thursdays and raise the issue directly with our product management team.  To get the invitation to the session, just request the invite by sending an email to [e-mail].

We covered your column issue multiple times the last few months so it is a valuable learning resource.

-------------------------------------------

[Paul Schofield]

Thanks for this, but this is already enabled:

And I'm still seeing the double headers for each column. This is from the customer's 16.4.1 system.

On a 16.4.2 system the feature is no longer available and I'm seeing the double headers there too.

-------------------------------------------

[Suman Pramanik]

Hi Paul 

I used this query to create a data provider and published it 

select install_type as marker,
install_id as installedID
from cmn_dwh_install_history 

Then created a report and ran the export and the output I see is below and the 1st row is the Query name I saved while creating data provider and second row is the columns name which is exactly the same behavior you saw in csv export. 

I will check on this and will come back to you. 

------------------------------
Thanks & Regards
Suman Pramanik
------------------------------

[Paul Schofield]

Thanks Suman!

-------------------------------------------

[Suman Pramanik]

Hi Paul

I logged a defect regarding duplicate headers in CSV, details can be found here. 

I will check the locale and come back soon

------------------------------
Thanks & Regards
Suman Pramanik
------------------------------

[Paul Schofield]

Thanks Suman!

Paul