Microsoft Dynamics NAV (Archived)

Filter processing report

(0) Share

Report

Posted on by MedInfoTech

1,392

Hi All,

this is a window variable in a processing only report
DataItem : ex Customer

when i run this report, in the No. filter (As shown in below demonstation) i get all No. of customers

The question is How get only the 10 first customers in the comboBox filter

0880.test.JPG

thanks

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Zaid Tariq 2,274 on at

Like (0)

Report
Copy link

Link copied!

Hi,
First of all, the processing only report does not have request page.
- If you want to get top 10 customers, either use filter by range like 123..1643 (i.e 123 is the first customer and 1643 is the 10th customer).
- If you have random Top 10 customers and dont know the id's at run time then you need to customize the report.

If you are using existing report Customer - Top 10 List then write 10 as Quantity.

For more details have a look: https://msdn.microsoft.com/en-us/library/hh179052(v=nav.90).aspx
https://msdn.microsoft.com/en-us/library/hh933864(v=nav.90).aspx

Let me know if you need help in report customization.

Thanks

Was this reply helpful? Yes No
MedInfoTech 1,392 on at

Like (0)

Report
Copy link

Link copied!

HI zaid,

Please take look at 953 report to get what i mean

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report
Copy link

Link copied!

(Report 953 Move Time Sheets to Archive )does not have any request page.

Second ally you can store the 10 first customer in a variable and then write code to filter those records. This you need to write OnPreReport trigger. If you know the 10 first Customer code would be fixed then you can hard code the same.

Was this reply helpful? Yes No
MedInfoTech 1,392 on at

Like (1)

Report
Copy link

Link copied!

Hi Manish,

If you run the 953 report you will get a request page asking you to specify The no. of TS that you want to archive .

it of type Window ..

Was this reply helpful? Yes No
Suggested answer

Zaid Tariq 2,274 on at

Like (0)

Report
Copy link

Link copied!

Hi Medo,

You need to customize this report, not possible to achieve with current functionality. Thanks

Was this reply helpful? Yes No
MedInfoTech 1,392 on at

Like (1)

Report
Copy link

Link copied!

Thank you very much Ziad for your answer :)

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report
Copy link

Link copied!

Have you tried the second option suggested ?

Was this reply helpful? Yes No
MedInfoTech 1,392 on at

Like (0)

Report
Copy link

Link copied!

Hi Manish,

Yes i tried but i doesn t work for me, the objectif is to see Cust001..Cust010 in No. comboBox

OnPreReport

SetFilter("No." , '%1..%2',Cust001,Cust010 );

Was this reply helpful? Yes No
Suggested answer

Zaid Tariq 2,274 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you try applying filter using DataItemTableView in Properties?

Was this reply helpful? Yes No
MedInfoTech 1,392 on at

Like (0)

Report
Copy link

Link copied!

Hi Zaid

Yes i tried, it doesn't work

thank you :)

Was this reply helpful? Yes No