Run Report with predefined filters

(0) Share

Report

Posted on by Shyamraoo

354

Hi,

I want to run the inventory valuation report with predefined filters, i have created a table to store the filters of the report then created list page and kept one action button, which calls report with predefined report filters.

Item.SETRANGE("Item Category Code","Item Category Code");
Item.SETRANGE("Inventory Posting Group","Inventory Posting Group");
Item.SETRANGE("Replenishment System","Replenishment System");
REPORT.RUN(10139,TRUE,FALSE,Item);

The problem is Item Category code filter has more than 10 chars, like this

<>A1&<>A2&<>A3&<>A4&<>MA&<>MB&<>MF&<>EA&<>EE&<>EG&<>EH&<>EI&<>EK&<>EL&<>EU&<>EV&<>RP&<>CN

when i call the report i stuck with this error message

Microsoft Dynamics NAV
---------------------------

The length of the string is 89, but it must be less than or equal to 10 characters. Value: <>A1&<>A2&<>A3&<>A4&<>MA&<>MB&<>MF&<>EA&<>EE&<>EG&<>EH&<>EI&<>EK&<>EL&<>EU&<>EV&<>RP&<>CN
---------------------------
OK
---------------------------

Could anyone know how to handle this.

Thanks,

Shyam Kumar N

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Suggested answer

RockwithNav 9,113 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey Shyam,

Cause of this Error message is very simple and clear as for Item Category Code the character defined is of Code 10 only(Item Table) and here its exceeding to even more then 80 that's why NAV is displaying this Error.

Was this reply helpful? Yes No
Shyamraoo 354 on at

Like (0)

Report
Copy link

Link copied!

Hi Rock,

i can able to give this filter in Request PAge of the report, but how to handle this during dynamically calling the report in C/AL code.

I understood that issue. give some suggestions to handle this.

Thanks

Shyam Kumar N

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (1)

Report
Copy link

Link copied!

I remember there has been error in 2013 that has been hotfixed...

dynamicsuser.net/.../65662

Would this be a workaround for you?

www.olofsimren.com/.../

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,278 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Instead of SETRANGE use SETFILTER

Replace it with this

Item.SETFILTER("Item Category Code","Item Category Code");

Was this reply helpful? Yes No
Verified answer

4BzSoftware 6,073 on at

Like (0)

Report
Copy link

Link copied!

Hi Shyamraoo,

Change SETRANGE to SETFILTER:

Item.SETFILTER("Item Category Code", '<>A1&<>A2&<>A3&<>A4&<>MA&<>MB&<>MF&<>EA&<>EE&<>EG&<>EH&<>EI&<>EK&<>EL&<>EU&<>EV&<>RP&<>CN');

Was this reply helpful? Yes No