Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 301 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Get the Quantity of Items by Period
basic0220
Member Posts: 43
Hi, I'm making a Customized report that Filters the sum of Quantity of Specific item by period : Week, Month, Quarter, Year.
and i can't seem to see some sort of guide of how do I store the values of the Date Table to the columns in my report.
*image below
as you can see, I Made a Table which contains the months of the year statically,
but, my report should be populating the table depending on the period in which the user selected.
I declared those months as an array which is specifically handling the Month Period,
and I want my table columns to populate the Columns like in this screenshot.
E.g it's Feb. today, and the report is generated by month,
The Column Should display like this.
If it's in quarter
I'm thinking to store those dates in a variable to make it reflect in the tabledata in my report,
but whenever i try to message the value of period startt, by Period Month in the Request Page,
The message returns no value.
and i can't seem to see some sort of guide of how do I store the values of the Date Table to the columns in my report.
*image below
as you can see, I Made a Table which contains the months of the year statically,
but, my report should be populating the table depending on the period in which the user selected.
I declared those months as an array which is specifically handling the Month Period,
and I want my table columns to populate the Columns like in this screenshot.
E.g it's Feb. today, and the report is generated by month,
The Column Should display like this.
If it's in quarter
I'm thinking to store those dates in a variable to make it reflect in the tabledata in my report,
but whenever i try to message the value of period startt, by Period Month in the Request Page,
The message returns no value.
0
Answers
Please use Date data item, so you can get your period solution.
and do indent to next dataitem from where you are getting your qty.
Use matrix and put date on column group and part value on to row group.
Let me know if you need any help regarding this.
Hi yes, I need further explanation regarding this.
because in my Data Items in the Report Design I didn't include the Date.
this is the Report Design BTW.
No need to take integer part,
Do one thing, Give me your mail id, will send you a report same like this.
i'm sure that report will help you.
I thing sharing mail id is not allowed here.. please delete.
I got a warning before importing the Object.
it says.
"Could not Upgrade RDL on Report 50058 Sales Extraction Period.
Illegal Characters in path"
I still get the same error I tried it in NAV 2017