K1000 KACE reporting question
Two questions related to KACE reporting:
1.Is there a way to pass parameters to the report instead of adding or changing WHERE clause to SQL?
2.Is there a way to change the header once it is created by the Wizard? I found one tip on the web to change XML. See this link http://www.kace.com/support/resources/kb/article/Customizing-a-Report-Layout-With-Jasper-iReport
but it says that I need to copy XML script from XML tab in the SQL edit mode. I don't see this tab. Maybe I have different version of KACE. All column names have to be the same as field names and once they are created they are cast in stone. To change anything in the column titles I need to create new report and then paste SQL from other report. I waste lots of hours on it and still it is not what I really want.
I am total newby to KACE and I am stumbling in the dark. Please, help.
Thanks in advance.
Community Chosen Answer
Thank you for your response John.
Regarding changing report header you explained that just specifying alias for the column in SQL selection statement will create header name. It is not the case in my application:
Here is the list of headers in my report:
Name Model Location Asset Id Asset Tag Serial Number Inventory Comments
Here is my SQL (I just included select statement no "FROM" and "JOIN" statements)
ASSET.NAME AS ASSET_NAME,
A58.NAME AS FIELD_58,
ASSET.ID AS ASSET_ID,
ASSET_DATA_11.FIELD_55 AS FIELD_55,
ASSET_DATA_11.FIELD_51 AS FIELD_51,
ASSET_DATA_11.FIELD_347 AS FIELD_347
Column aliases do not correspond to header column names.
As for the WHERE clause my client does not know anything about SQL statements. I would like the report to popup a dialog box and ask for selection criteria that could be dynamically entered into WHERE statement. I always do it in Access application.
If this is not possible I would like to know it so I can look for another solution.
In summary I did not receive an answer to any of my questions.
thanks for responding to me and trying to help me.
Best Regards Stefania