11 Replies Latest reply: Feb 27, 2017 12:48 PM by Sunny Talwar RSS

    nPrinting Filter

    Sunny Talwar

      Hi Team -

       

      I have created an nPrinting report where I want to use a filter. The field I am filtering on is not a part of the chart that I am trying to email. Does filters only work when the field you want to filter on is part of the chart?

       

      Best,

      Sunny

        • Re: nPrinting Filter
          Avinash R

          If its the part of the data model? then it will work . It acts as the normal filter if its s variable then your chart should has the variable in that ...hope this answers your question

            • Re: nPrinting Filter
              Sunny Talwar

              It is a normal filter, but for some reason the whole chart (without any filtration) is emailed to the recipients. I have no clue what might need to change here

                • Re: nPrinting Filter
                  Avinash R

                  It could be for couple of reason.

                  1.Any other filters applied ? which might override this filter

                  2. Filter value might have changed , check the data once

                  3.Where the filters are applied ? In the task level or report level. I preffer to do it at the Report level ..

                  4.Change in data model or any Single select value update on any list box

                    • Re: nPrinting Filter
                      Sunny Talwar

                      1.Any other filters applied ? which might override this filter

                      • There is only one filter.

                      2. Filter value might have changed , check the data once

                      • the data has not changed (added the application to nprinting today and I know the data hasn't changed)

                      3.Where the filters are applied ? In the task level or report level. I preffer to do it at the Report level ..

                      • I initially started with task level filter, but then I just put the same filter on both the locations. Does that make any differnece?

                      4.Change in data model or any Single select value update on any list box

                      • Not sure I understand this one?
                        • Re: nPrinting Filter
                          Avinash R

                          I initially started with task level filter, but then I just put the same filter on both the locations. Does that make any differnece?


                          Yes, Please remove it from the task level and have it only in the report level and check ...


                          4.Change in data model or any Single select value update on any list box

                          • Not sure I understand this one?

                          I mean if any changes in the data model would effect the data association linking and same goes with the Single select filter ..if any such filter are applied then it it will set the filter that can be applied after that , if your filter is grayed out then it won't allow you to apply the filters

                          • Re: nPrinting Filter
                            Vinay Bangari

                            Sunny use that filter in the report dont use that in the task

                      • Re: nPrinting Filter
                        Sunny Talwar

                        You were right, it did work. I just had to apply another filter to see the number of rows go down.

                         

                        Thanks Avinash!!

                         

                        Best,

                        Sunny

                      • Re: nPrinting Filter
                        Sunny Talwar

                        The issue seems to have resolved by adding the filter field into the chart. Not sure if this is a bug or if this is intended functionality, but it works for me now.

                         

                        Best,

                        Sunny

                          • Re: nPrinting Filter
                            Avinash R

                            It should work...is their any aggregation in the chart ?

                              • Re: nPrinting Filter
                                Sunny Talwar

                                Its an app that was developed by a user, so I am not really sure what that chart uses for expression, but it is a straight table with expressions. So I am sure it must be using aggregations.

                                 

                                I guess the point is that when I did not have it as dimension, it was not filtering out, but when I did add it as a dimension it worked. But while I was typing my response, another thing came to mind. I think you might be right, but let me test it out on Monday before I can let you know if it worked or not.

                                 

                                Best,

                                Sunny