RTC Report Filter Condition ?

postsauravpostsaurav Member Posts: 708
edited 2010-11-29 in NAV Three Tier
Hi everyone,



i am trying to create a RTC reports where i have to apply a filter so that blank rows should not get printed.

But the problem i am facing is that i am trying to set filter based on two fields with OR condition.

But the And/OR column is disabled in the filters list and it taking AND by default, i want OR in Place of AND.


Is it possible by changing it to OR.
Please let me know if it can be done.


Thanks in advance.

Thanks & Regards,
Saurav Dhyani

Do you Know this About NAV?


Connect - Twitter | Facebook | Google + | YouTube

Follow - Blog | Facebook Page | Google + Page

Answers

  • BeliasBelias Member Posts: 2,998
    i was banging my head over this uneditable column, too...but i think it's not possible to do such a filter...i don't remember how i solved it, probably with visible property, but this is not useful if you want to alter the "Sum" functions, too. (if i remember well, the hidden values are summed up, too)
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • postsauravpostsaurav Member Posts: 708
    No the problem is with visible condition that the empty line still get printed which is increasing space between values and i wanted to use the filter the empty rows.

    In my case those are not sum values, but normal values but there are two similar rows which get printed on different conditions. i set that using visibility but the empty space creating problem.

    Thanks & Regards,
    Saurav Dhyani

    Do you Know this About NAV?


    Connect - Twitter | Facebook | Google + | YouTube

    Follow - Blog | Facebook Page | Google + Page
  • BeliasBelias Member Posts: 2,998
    it's not true: if you make the entire row invisible it does not create blank space...but you have to higlight the entire row and set the property for it, you don't have to higlight all the textboxes of the row!
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
Sign In or Register to comment.