From and To date for Sales analysis by Invoice report

(0) Share

Report

Posted on by Faqruddin

1,883

Dear all,

I need to show Fromdate and Todate(must Invoice date) for Sales analysis by Invoice report before generate a report. This report is normal query based report and with precision design. Please share some examples for normal Query based report with From date and to date.

Report Path: Sales and Marketing -->Reports-->Statistics-->Invoice-->Sales analysis by Invoice

Thanks

Faqru

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

Verified answer

Vilmos Kintera 46,149 on at

Like (1)

Report

Take a look at this topic, it has been discussed before:

community.dynamics.com/.../159526

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Hi,

In date Criteria mention date like"1/3/2017..5/3/2017", you can see in below screenshot.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi,

If you don't want give date in single field, then you can add same date field in range.

You can change the label for that dates as from date and to date,

Then you can able to see From date and To Date in parameter form,

I think, this is your solution, hope it helps you.

Was this reply helpful? Yes No
Faqruddin 1,883 on at

Like (0)

Report

Hello Suresh,

Thanks. But I need in main dialog box. So I can select fromdate and todate from main dialog box and click ok.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Hi,

If you select the dates in from date and to date, then the date will automatically populate the dates in main dialog box in date field as like "1/3/2017..5/3/2017". You can use like this simply.

Was this reply helpful? Yes No
Faqruddin 1,883 on at

Like (0)

Report

Yes I know that. But I have requirement to display like above screen. Enduser don't wants to use select option from main screen and go to second screen for filter dates. From main screen itself select from date and to date and click ok to get result :-)

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

Your query will be called When you clink on select in below screenshot,

The form "SysOperationTemplateForm" is common for all reports. It is not easy to do that.

Was this reply helpful? Yes No
Faqruddin 1,883 on at

Like (0)

Report

Yes I know that. Do you have any examples for SysOperationTemplateForm customization.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Suresh, you keep responding to topics with non-relevant answers. Kindly stop.

Faqru, I understood your requirements right in the first place, and the answer could be found in the posts I've linked in the other topic. He wanted a range as well, and had to extend the report with a controller class in order to be able to dynamically add other filter criteria to the dialog as per Haythem and Baber's suggestions.

Was this reply helpful? Yes No
Faqruddin 1,883 on at

Like (0)

Report

Thanks for your prompt replies. Finally I reached my requirement as Vilmos suggested above.

Was this reply helpful? Yes No