samwoo Posted June 12, 2018 Share Posted June 12, 2018 hello, I have made a report which combines a few tables in order to pull information related to Leavers requests, including the assets linked to those requests. Whilst it initially worked, I wanted to get the "Asset Type" name attached to it, so as soon as I joined this table and included the field, the Asset Name column is now sharing the same details as the Asset Type Name column. If i remove the Asset Type Name column, the Asset Name column reverts back to the actual asset name. That was probably confusing I have attached the report definition file...tech-support-equipment-assets.report.txt You can also see the screenshot below: Without Asset Type Name With Asset Type Name As you can see the Asset Name column shares the AssetTypes->Name fields. Can someone assist? Thanks, Samuel Link to comment Share on other sites More sharing options...
Victor Posted June 12, 2018 Share Posted June 12, 2018 @samwoo the report you just ran... the query behind it was quite unfriendly with the database ... I think Armando was preparing a more resource friendly report for this.... Link to comment Share on other sites More sharing options...
samwoo Posted June 12, 2018 Author Share Posted June 12, 2018 I mean I ran it and it didn't take long to run at all Link to comment Share on other sites More sharing options...
NeilWJ Posted June 12, 2018 Share Posted June 12, 2018 Hi Samuel, That only happens in the report "preview" right? If you "run" report does it output correctly? The problem with report preview is known issue. I will remind api team to fix it. Cheers Link to comment Share on other sites More sharing options...
NeilWJ Posted June 13, 2018 Share Posted June 13, 2018 @samwoo In the mean time I believe a workaround is to give one of the "name" column an alias. The actual problem is in the preview data response it returns data when cols have same col name like :- {"name": "somevalue","name":"some other value"} So when you parse that in JS it just becomes {"name":"some other value"}. If you give one of the columns an alias it will then return:- {"myalias":"somevalue", "name":"some other value"} As mentioned though your actual report output should be ok, it is the preview api that needs sorting out. Cheers Link to comment Share on other sites More sharing options...
samwoo Posted June 13, 2018 Author Share Posted June 13, 2018 Hi @NeilWJ, Many thanks for getting back and investigating this. Yes I can confirm the report output's with the correct values as opposed to the Report preview. At least I am aware so wont be worried about it now as long as the data comes out ok on the report. Another question - regarding the XLSX output, is there a feature coming that will allow the report to be appropriately formatted? The Data preview table is nice to view but the output on the XLSX file itself isn't Thanks, Samuel Wood Link to comment Share on other sites More sharing options...
NeilWJ Posted June 13, 2018 Share Posted June 13, 2018 I will speak to trevk about the XLSX output. I assume that we should be able to add formatting options so it has column headers with a bgcolor and make columns autosize, but it might depend on what api we are using. I will let you know. Cheers Link to comment Share on other sites More sharing options...
samwoo Posted June 13, 2018 Author Share Posted June 13, 2018 Hi @NeilWJ, That would be great - at least to make it more presentable upon opening it without having to make it manually look good each time you open it (especially when running them frequently). If there is a possibility of automatically showing the filter arrows as well would be great. Cheers! Samuel Link to comment Share on other sites More sharing options...
NeilWJ Posted June 25, 2018 Share Posted June 25, 2018 @samwoo Hi Samuel, So the xls column auto sizing will be in an upcoming build. So there are some restrictions to it but it is a lot better than it was:- Cheers output before: now with autosizing: Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now