Share
ReportHi Experts,
I want to add range on from customer To customer parameter how can i please help?? This is report parameters as shown in the above image.
Best Regards,
Shabir Ahmad
You’re offline. This is a read only version of the page.
3,090
Hi Experts,
I want to add range on from customer To customer parameter how can i please help?? This is report parameters as shown in the above image.
Best Regards,
Shabir Ahmad
I think the users should simply use the standard query range dialog. By learning to use the standard dialog, they are empowered in a way that can never be matched by manually adding fields in the report dialog. What you are now developing is less powerful and more expensive than the standard dialog, so please try to convince your customer to use the standard feature instead. The upside is also that once they learn it, they can use it on any report and batch dialogs throughout the system, and they don't need to purchase expensive developer additions to be able to specify filter values. And you can focus on tasks that add more value to the customer. Everybody wins.
Anyway, if your user provides Cust001 in the first field and Cust002 in the second field, you simply need to combine them into one string in your code, and put two dots in between(result will be "Cust001..Cust002") and apply that as a query range in x++.
Hi Leo Wang,
You are right did it as you mention making query range but they want contract bas range as shown above in the image.
Best Regards,
Shabir Ahmad
Hi Shabir,
You don't need two parameters as from and to, just one is ok. User can type in "Cust001..Cust010" ,like this.
Hello Dr. Ludwig Reinhard,
Thanks for your reply, I want if there are total let say 1000 customer in the system if user select from customer account (1) to customer account (3) it will show only these 3 customer such as from date and to date perameters.
Note the parameters which i want to add range are custom fields i developed it on custtable. If further info need tell me.
Best Regards,
Shabir Ahmad
Hello Shabir,
What do you mean exactly? Write some code that fills the from and to customer fields or what is it that you wan to do exactly?
Would be great if you could elaborate.
Many thanks,
Ludwig
Hi Blue Wang
Thanks for referencing my previous link as below
community.dynamics.com/.../1107863
We have made 5 fields on custtable and that fields are string data type now i want to show thems as drop down parameters, for from customer and To customer should work"From date to date". Further city Region status should work simple drop down as user click on this it will be control from parameters.
The last thing i aready developed the report but only range issue. If you want more info i am here.
Best regards,
Shabir
Hi Shabir,
Based on your last thread community.dynamics.com/.../1107863
You defined 5 parameters, so FormCustomer is FromDate?Please explain in details.
So you want to ask how to implement the date range?
Your DP class has been added SRSReportQueryAttribute(queryStr(JDCustomerInvoice)) , so what about the JDCustomerInvoice query settings?
#1
André Arnaud de Cal...
293,278
Super User 2025 Season 1
#2
Martin Dráb
231,983
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
All responses (
Answers (
