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.

Partner

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

2

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)

SELECT
ASSET_TYPE.NAME,
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
FROM ASSET_DATA_11   

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

Answered 10/30/2012 by: Partner
White Belt

  • If you are changing the SQL report's selected columns and/or aliases in an existing report, the headers will not change. I believe this is a bug and have run into myself when editing SQL reports. What you'll have to do is start a new SQL report, at which point the headers should be reflected as desired. It is possible to connect to the K1000's database using other clients including Access, so what you are looking to do should be possible. Just not solely with the K1000's interface (without some modifications made by KACE professional services). John
Please log in to comment
1

1) Using the wizard, you can setup filters (which will generate the WHERE statements for you, along with the rest of the query - i.e. wizard).

2) Using the wizard - in the Classic Reports, yes - as it gave direct access to the resulting XML code.  In the current Reports, no - but I discussed with a product manager and they are planning on adding more features (possibly this level of access, at some point).

If you play with the SQL code, you'll find it's pretty flexible.  Maybe this can help:

http://www.itninja.com/blog/view/primer-for-writing-select-statement-queries-on-the-k1000-w-custom-sql-report-example

John

Answered 10/29/2012 by: jverbosk
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity