Filters in Report

bona_donabona_dona Member Posts: 72
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

  • SavatageSavatage 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
  • Revolution1210Revolution1210 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
Sign In or Register to comment.