How to add a column in Group By field of reporting?

rezacol · ‎06-27-2014

Hi Guys,

I have a query on how to add some column which are not present in the Group By field on the reporting form for that particular table.

Quick help will be much appreciated.

Thanks,

Reza

Mike Moody · ‎04-17-2015

Hi Reza,

I was able to solve this problem by using the following procedure.

Open the report via the Edit link in the left-nav, export the report to XML.
Edit the <filter> tag in the XML to have the GROUPBY statement target the field name you want.
Save and Import the modified XML file back into the system.

Just keep in mind that if you change this report in the future you will have to repeat this process because the Group By field will be overwritten with the value none.

Example: (I targeted the url field here, which is a field that isn't available to Group By on the syslog_transaction table)

<filter table="syslog_transaction">sys_created_onONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0)^sql_count>0^sys_created_by!=guest^urlSTARTSWITH/u_analytics.do^EQ^GROUPBYurl

Regards,

Michael Moody

Software Engineer

Milestone Technologies, Inc.

View solution in original post

Mike Moody · ‎06-29-2015

You'll want to use the left-nav menu to navigate to Reports -> Administration -> Edit - This will give you a list of the report records in the system. You'll want to find the report in question in this list and then export it to XML.

inderpal · ‎06-29-2015

Thank you so much Michael. It worked.
Thanks for your help.