Small and medium business | Business Central, N...

Default Request Page has no filters

(0) Share

Report

Posted on by Schulaa

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:

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")
            {

            }

        }
    }

}

I have the same question (0)

All responses (6)

Answers (0)

divyeshchitte 968 on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
Schulaa 5 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Schulaa 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Robert B. 257 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Schulaa 5 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Robert B. 257 on at

Like (0)

Report

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!

Was this reply helpful? Yes No

Join the conversation

Community site session details

Default Request Page has no filters

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Default Request Page has no filters

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates