Filters in Report

bona_dona
bona_dona Member Posts: 72
edited 2007-11-07 in NAV/Navision Classic Client
hiii all!
I have one problem,when I set filter in report I would like that this filter was shown too.I use STRBUSTNO,but nothing is result.:(:(
thanks:):)

Comments

  • Savatage
    Savatage Member Posts: 7,142
    Look at the OnPreReport Section of other reports to see how it's done.

    & Look at c\side guide about using GETFILTERS
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • Revolution1210
    Revolution1210 Member Posts: 161
    Taking the Customer - List report (101) as an example:

    On the OnPreReport trigger grab the filters which have been set, where CustFilter is a text variable, 250 in length:
    CustFilter := Customer.GETFILTERS;

    Add a TextBox to display the filter(s) to a separate header section in your report. Give the TextBox this source expression:
    Customer.TABLECAPTION + ': ' + CustFilter

    Place the following code behind the OnPreSection() trigger of the header section where you placed your text box: 
    CurrReport.SHOWOUTPUT((CurrReport.PAGENO = 1) AND (CustFilter <> ''));
    Ian

    www.NextEqualZero.com
    A technical eye on Dynamics NAV

Categories