| Author |
Message |
|
|
Thanks. it helps when you know what those magic report wizard variables are.
Will a list of them ever get published?
|
|
|
|
Thank you, glad to help.
|
|
|
see this more recent report:- http://www.ilient.com/Sysforums/posts/list/7239.page#30467
I think it is because they have not updated all the jasper report components to the same version in the current release.
It is not browser type related in this current version of the problem.
|
|
|
Yes, read more here:- http://www.ilient.com/Sysforums/helpData.page?helpId=4250
or for a list of more fields look here
http://www.ilient.com/Sysforums/posts/list/4250.page?help=true
|
|
|
I think what you are looking for is ${userGroupDesign}
There is no official documentation/list of these as far as I know, these are the ones that I know about:-
${KB_typeDesign} ${PrCategoryDesign} ${PrList1Design} ${PrReqGroupDesign} ${PrStatusDesign} ${ProjectsDesign} ${SrLocationDesign} ${SrStatusDesign} ${ValidateAdmin} ${ValidateDate} ${ValidateNumRecords} ${ValidateSchedule} ${ValidateSingleAsset} ${ValidateThreshold} ${ValidateTitle} ${ValidateUser} ${adminDesign}
${agreements} ${assetDetailsGroupDesign} ${assetDetailsSingleAssetDesign} ${assetGroupDesignAll} ${assetGroupDesign} ${categoryDesign} ${companyDesign} ${cumulativeDesign} ${customFilter ${customFilterAsset ${customFilterCIList ${customFilterCIRelationTypeList ${customFilterCITypeList ${customFilterCatalog ${customFilterCompany ${customFilterGroup ${customFilterProject ${customFilterSR ${customFilterSRActivity ${customFilterSoftware ${customFilterSupplier ${customFilterTask ${customFilterTaskActivity ${customFilterUser ${detailsDesign}
${elementr ${fromDateDesign} ${groupAssetFilterDesign} ${groupDesign} ${groupingDesign} ${groupingPriorityUrgencyDesign} ${groupingSelectionDesign} !${groupingSelectionQualityDesign} ${includeDisabledAssets} ${itemTypeDesign} ${mainGroupingDesign} ${measurements} ${notClosedDesign} ${numRecordsDesign} ${reportTitleDesign}
${scheduler} ${selectCategories} ${selectDatePeriodAll} ${selectDatePeriod} ${singleAssetFilterDesign}
${sr_types} ${subGroupingDesign} ${thresholdDesign} ${timerDesign}
${userDesign} ${userGroupDesign} ${viewReportDesign}
I hope this helps.
|
|
|
Sorry, I never really could understand the maths behind standard deviation at school, so I am not going to be able to help you on this one!
One idea is perhaps export the report to excel and calculate it that way?
|
|
|
|
There is no official way to do this, but you could download open reports from http://oreports.com/ and then add a link to that to the end user portal.
|
|
|
David Lee wrote:However, the solution provided did not work for me and resulted in an 'error in query' (was good up to the " sqlStat= " part) .
Did you try just replacing the whole sqlStat= line with the complete line I gave at the bottom of my post which says "the finished sqlStat line should look roughly like this"?
|
|
|
techguy wrote:
@Inna, could you please post the bug number or SR# for this back to the forums.
Hello? Inna are you there? or can anyone from Sysaid support please post the bug number.
(Sometimes I feel ignored in this forum) 
|
|
|
|
i have tested this with several different software products and actually none of the fields get exported to excel for us nor does the print option work, it says "No data found".
|
|
|
I am glad you managed to work it out.
Yes the reporting can be quite frustrating and daunting, but it is a lot better now they have added report wizard!
|
|
|
testing on my sandbox, only some records get set and they get set with the incorrect american date order mm/dd/yyyy , yet if you turn on chatty it shows the sql statement it would put in was in the uk format dd.mm.yyyy ?
any ideas?
|
|
|
What and excellent script !
/BEGIN OFFICIAL DISCLAIMER/
All database modifications outside of SysAid invalidate your support
/END OFFICIAL DISCLAIMER/
Perhaps SysAid could provide their official blessing to use this script when we have finished please?
I ran it in test mode
in testing, I found I have some manual asset records for dell's that do not have an agent and were added by hand with either no serial number or duff ones! (I will get these fixed).
To stop these blowing up the script I added the following changes:-
Line 116 I added
and after the line
I added
This stops it bombing out if it cannot get a result because of a duff serial number.
|
|
|
Sorry Sylvain G, I got confused about which post I was replying to, that response was for another similar issue!
Ignore everything I said in that last post. ( I have deleted it now so as not to confuse anyone else). That response was for re-creating the problem with a similar issue in the report wizard, this time purchase cost not showing up (http://www.ilient.com/Sysforums/posts/list/6448.page#30947)
Now back to your question,
It's because when I first posted those instructions - we were not talking about the "belongs to" field - we were using "users". larronni modified my original report and was trying to use the owner (Belongs to) field.
To recreate this report in the wizard
Select "Asset" as your main entity
Select "SW Products" as your Secondary entity
Give it a caption like "All possible users of a software product"
Click Next
In step 2
From Available fields select "Product Name (Software)" and "Belongs To (Assets)"
Group By 1 select "Product Name (Software)"
Click Next
In step 3
Select "Product Name (Software)" and move it across to the visible filters.
Click Finish
|
|
|
|
Post deleted by Techguy - who put the wrong reply in - Sorry! - see my next post!
|
|
|
