Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Default Request Page h...
Small and medium business | Business Central, N...
Suggested answer

Default Request Page has no filters

(0) ShareShare
ReportReport
Posted on by Schulaa 5

Hey everyone,
I'm completly new to developing in AL / Business Central and I'm currently doing some tutorials on learn4d365.com, especially creating my first report.

The report itself works perefctly fine, but the request page is missing the 'Default filters'. I've done nothing different than the guy in the tutorial, yet he has the possibility to set filters but I'm just getting a blank page (see attachment). 

I appreciate every help to get these filters like I'm used to in the old Dynamics (without creating every field manually).

I've added my code in the AL-File and the request picture.

Thanks in advance,
Schulaa

Request Page:

pastedimage1574250323777v2.png

My code:

report 50101 ReportFilter
{
    UsageCategory = ReportsAndAnalysis;
    ApplicationArea = All;
    DefaultLayout = RDLC;
    RDLCLayout = 'ReportFilter.rdl';
    UseRequestPage = true;

    dataset
    {
        dataitem(Item; Item)
        {
            //DataItemTableView = where ("Item Category Code" = const ('TISCH'));
            column(No_; "No.")
            {

            }

            column(Description; Description)
            {

            }

            column(Item_Category_Code; "Item Category Code")
            {

            }

        }
    }

}

  • Suggested answer
    Robert B. Profile Picture
    Robert B. 257 on at
    RE: Default Request Page has no filters

    Hi, 

    You can try with request filter fields, then you have that + sin so the user can add the fields he needs when he runs the report.

    There should be also a property savereportfilters you can set to true or something along that line, which will save the filters you had previously.

    From a user experience you don't want to have 20 fields listed there anyway, hard to even find the one you want to set, when generally a user would set from 0 (if you run a report with no automatically populated based on your list selection)  to 2-3 filters(depending on the user needs).

    Cheers,

    Robert

    If this helps in resolving your issue, please verify my answer!

  • Schulaa Profile Picture
    Schulaa 5 on at
    RE: Default Request Page has no filters

    Thank you very much, but that would mean I have to declare every field, filters can be used on, right? So there isn't an opportunity  to show all filters per default? For example, I have a table with 20 fields, and the user should be able to filter for every field. So I'd have to set every field in the RequestFilterFields manually?

    The DataItemTableView-Property was commented, my bad I didn't remove it.

    It was part of the tutorial to show how to filter in AL-Code and how to filter using the RequestPage. He didn't use the property RequestFilterFields at all, but his RequestPage looks like this:

    pasteboard.co/IHQ2l5q.png

    While mine is still blank, or with the fields I specify in RequestFilterFields.

  • Suggested answer
    Robert B. Profile Picture
    Robert B. 257 on at
    RE: Default Request Page has no filters

    Hi Schulaa,

      I noticed DataItemTableView, this is for dataset sorting filtering.

      For the page with the filters you'll use RequestFilterFields to select the fields you want to filter and RequestFilterHeading for the caption of your page.

     
                DataItemTableView = SORTING("Item Category Code") where ("No." = 'TISCH');
     
                RequestFilterFields = "No.";
                RequestFilterHeading = 'Report Filters';

    Cheers,

    Robert

    If this helps in resolving your issue, please verify my answer!

  • Schulaa Profile Picture
    Schulaa 5 on at
    RE: Default Request Page has no filters

    [double post, delete didn't work..]

  • Schulaa Profile Picture
    Schulaa 5 on at
    RE: Default Request Page has no filters

    Unfortunately that didn't solve the problem.. I tried adding the request page, but that didn't solve it either. And even if, still wondering why the guy in the tutorial wouldn't need it.

    I also converted my C/AL report to AL, but it shows the exact same behavior(no possibilities of sort/filter. Works properly in Dynamics) and it also hasn't any entries in the code part 'requestpage'.

    Maybe I'm missing one property or something? Might it be possible that I've blocked it in the administration center or something?

  • divyeshchitte Profile Picture
    divyeshchitte 950 on at
    RE: Default Request Page has no filters

    Try adding Request Page ,

       requestpage

       {

           layout

           {

               area(Content)

               {

                   group(Default)

                   {

                       field("Print Detail"; "PrintDetail")

                       {

                           ApplicationArea = All;

                       }

                       field("Group By Reason"; GroupByReason)

                       {

                           ApplicationArea = All;

                       }

                   }

               }

           }

       }

    If you are Good in C/AL Report building then you can built the same report in C/AL and convert to AL and can go through the logics.

    How to Convert Objects from C/AL to AL ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,001 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,837 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans