Finance | Project Operations, Human Resources, ...

adding range on from customer to customer number

(0) Share

Report

Posted on by Shabir Ahmad

3,110

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 have the same question (0)

All responses (7)

Answers (0)

Blue Wang on at

Like (1)

Report

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?

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi Shabir,

You don't need two parameters as from and to, just one is ok. User can type in "Cust001..Cust010" ,like this.

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

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++.

Was this reply helpful? Yes No