on 07-21-2009 12:16 PM
Hi Experts ,
I have a requirement for the report.
The report should display weeks for current month i.e July , which is done. But the question is , based on the current week , I need to display the day say ,in week 42, 13/07/2009 is monday then report should display as 13 july ,2009 ,Monday (based on the week) .
Can anybody guide as in how this can be achieved.
Thanks in advance,
M.S
Hi ,
Question :
The report should display weeks for current month i.e July , which is done. But the question is , based on the current week , I need to display the day say ,in week 42, 13/07/2009 is monday then report should display as 13 july ,2009 ,Monday (based on the week) .
Solution :
In the Query designer , beside the column pane , there is an option called " Display As Hierarchy " tick this option and activate it.
below that option is the expand to level drop down box , you can specify the level. Initially that box contained " month" july as the value , I changed it to zdate (13/07/2009)i.e expand to level zdate and hence the report started displaying as month and then weeks & then the day.
I once again thankyou for your valuable inputs ,
Thanks & Regards,
M.S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Experts ,
I found the resolution to the problem . I thankyou Very much for all your inputs.
Thanks & regards,
M.S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Experts ,
Kindly ignore the above.
Is der any way to attach the document and explain the problem.
plz reply,
Thanks & Regards ,
M.S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Experts,
There is a cumulated amount in the report. I need to display the previous weeks and current week for the cumulated amount . For the current week only ,the cumulated amount should be distributed and displayed day wise.
There is no date input to be given. Can anybody give me input on this.
Kindly help.
Thanks in Advance,
M.S
Edited by: M.S on Jul 22, 2009 7:36 AM
Edited by: M.S on Jul 22, 2009 7:37 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If you have the date as input then you can make use of the function module DATE_COMPUTE_DAY_ENHANCED to return the Weekday.
This can be as a Customer Exit Text variable.
Hope this helps.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gaurav ,
There is a cumulated amount in the report. I need to display the previous weeks and current week for the cumulated amount . For the current week only ,the cumulated amount should be distributed and displayed day wise.
There is no date input to be given.
Kindly help.
Thanks in Advance,
M.S
Edited by: M.S on Jul 21, 2009 2:30 PM
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.