Including a filter in a report
Created: 21 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.....
Discussion Filed Under:
Comments 8 Comments • Jump to latest comment
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
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
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?
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
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
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
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:
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
Thanks a lot..It worked...:)
Would you like to reply?
Login or Register to post your comment.