You’re offline. This is a read only version of the page.
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
thanks
*This post is locked for comments
Hi Zaid
Yes i tried, it doesn't work
thank you :)
Hi,
Can you try applying filter using DataItemTableView in Properties?
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 );
Thank you very much Ziad for your answer :)
Hi Medo,
You need to customize this report, not possible to achieve with current functionality. Thanks
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 ..
(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.
HI zaid,
Please take look at 953 report to get what i mean
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (