Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Including a filter in a report

Created: 20 Mar 2011 • Updated: 23 Mar 2011 | 8 comments
This issue has been solved. See solution.

I added a report parameter type Basic GUID and a value provider "Filter Chooser Parameter Control" . I named it filter. I included the same in Query parameters but I am not able to see filtered results on appling specific filters. I still see all the results of the report...

Can anyone please help to identify the step that I may be missing.....

Comments 8 CommentsJump to latest comment

Andrew Bosch's picture

If you named the drop-down "filter", then make sure you use that exact variable name in your SQL.  For example...

WHERE Guid = '%filter%'

------------------------------------
Sr. Principal SQA Engineer
Symantec

mclemson's picture

In general, have you followed this process?

https://www-secure.symantec.com/connect/videos/symantec-management-platform-reports-creating-dropdown-menu-filter

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

siddharth.kakkar's picture

But I was no able to add any thing in Filter Expression. Tis is because I made filters myself based Subnet. Now what condition should I give to check the membership of a computer in a filter?

I tried giving {Aex Ac TCPIP]{Subnet] equals Filter but it does not work. what should i give in filter expression?

mclemson's picture

It probably works, but just returns no results.  That's because you're saying that when the Subnet equals a GUID, then display results.  The value for subnet will never match the GUID of a filter, so you get no results.  Read my posts below for recommendations on how to proceed.

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

siddharth.kakkar's picture

 

I followed the steps in the video but I was no able to add any thing in Filter Expression. Tis is because I made filters myself based Subnet. Now what condition should I give to check the membership of a computer in a filter?

I tried giving {Aex Ac TCPIP]{Subnet] equals Filter but it does not work. what should i give in filter expression

mclemson's picture

First step would be renaming filter to something less generic, like FilterGuidParameter. 'Filter' is already a variable used in very many reports.  Andrew recommended this two days ago.  Have you done this yet?

It seems to me that you do not need to worry about the filter expression until your report shows some data.  That's because a filter expression would limit/restrict/reduce this even more, making it difficult to troubleshoot why you aren't getting results.

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

mclemson's picture

Or follow this process here in this KB:
http://www.symantec.com/business/support/index?page=content&id=HOWTO35873

If you create a new computer report and follow these instructions, you create a report based on a filter.  If you create a new computer report that presents certain data, and then create the report based on the filter, you restrict the results based on the filter membership.

I would suggest:

  1. Create a New > Computer Report without adding any fields or filter expressions or parameters
  2. Follow this KB to the letter (except using a GUID from one of your own filters, not the GUID in the KB)
  3. Apply what you learn to the report you were trying to build in the first place, adding your fields and filter expressions until the results are what you wanted to see

It's easiest, in my opinion, to follow this KB once, using the GUID from something like 'All Computers,' calling it something like 'Computer Report with Filter Picker,' and then cloning it whenever you need a report with a filter picker.

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

SOLUTION