How to get this kind of out put

[chakri]

Hi Folks,

Here is a requirement for my client to have the report in the format attached .and the requirement is as follows.

Could anyone suggest me the best approach for this kind of requirement.

3. Processing options:

Standard Work Hours per Day = Used 8 as by default


4. Tables Used:

F0007, F4801, F31122 and F4812H

F0007.CZMMCU = F4801.WAMCU
F0007.CZYR = Year (F4801.WASTRX)
F0007.CZMT = Month (F4801.WASTRX)

F4801.WADOCO = F31122.WTDOCO
F4801.WADOCO = F4812H.WDDOC



5. Data Selection:

Year = F0007.CZYR (Used Year as: 2007 by default)
Month = F0007.CZMT (Used Month from: 1-12 by default)
BU = F0007.CZMMCU (Used BU: 9855 by default)


6. Data Sequencing:

Year = F0007.CZYR
Month = F0007.CZMT
BU = F0007.CZMMCU

7. Report Template Available: Yes,



8. Requested Report Columns & Specifications:

Header Section:

Report & Version Number [i.e. Batch application ID],
Report Title “Monthwise Labour Revenue Summary” [Bold, Font size 14, Underlined],
Run Date [format dd/mm/yyyy]
Time [hr:mn:ss]

From: Month, Year & BU: User input from data selection values

Detailed Section:

S. No, = Auto generated as per sort order
Month Name = Smart field for the Period No. reflecting the month
No. of Jobs = Count F4801.WADOCO Grouped on Year & Month
No. of Tech. = Count F31122.WTAN8 Grouped by F31122.WTAN8 for Year / month
Working Days = Count No of days F0007.CZTD01 To:
F0007.CZTD31, where: W = Working Days for the month
Available Hours = Total number of technicians * Working Days * PO Value for the month
Utilised Hours = Total of F31122.WTHRW for the month and MCU
% Utilised = Utilised Hours / Available Hours * 100
Idle Hours = Working Hours – Utilised Hours
% Idle = Idle Hours / Available Hours * 100
Labour Revenue = If F812H.WDEXA = Blank, then Sum of F4812H.WDBTOL for the month
Average Rate = Labour Revenue / Utilised Hours


Footer Section: (Summary) Grand Total of :

Total No. of Jobs = Sum of No. of Jobs
Total No. of Technicians = Sum of technicians
Total Working Days = Sum of days
Total Available Hours = Sum of Hours
Total Utilised Hours = Sum of Utilised Hours
Total Idle Hours = Sum of Idle Hours
Total % Utilised = Sum of % Utilised
Total % Idle = Sum of % Idle
Total Labour Revenue = Sum of Labour Revenue
Total Average Rate = Sum of Average rate

Thanks in Advance

Kalyan
8.11 SP1/Oracle 10g/64Bit

 

[Zoltan_Gyimesi]

Hi Kalyan,

Do you ask for how to create this cell grid layout or for the total solution? I just ask, because you inserted the whole specification of your task.

About cell grid:

It requires sometimes much patience to solve it exactly. The method is follows.

#1: Place Report Constant (RC) onto the section and fill it with some space.
#2: Open the properties of the RC, select the Style tab, un-chek No lines option and check Sigle Rectangle.
#3: Place your RC over the report variable (RV)
#4: Repeat th
#5: Here comes the harder work - to make fit everything exactly
You can play with the following to adjust the size horizontaly and verticaly:
- number of spaces in RC
- font size
- font type
- font style
#6: Repeat this for the other sections
#7: To fit ecah section to the oher, you can play with the position of tha layaut on the section. To match the horizontal lines between the sections, place you layout to the most top of the section

Hope this help.

Regards,

Zoltán

 

[Systime Pune]

How to insert Run Date & Time in to the Rept. Hdr.?

Header Section:

Report & Version Number [i.e. Batch application ID],
Report Title “Monthwise Labour Revenue Summary” [Bold, Font size 14, Underlined],
Run Date [format dd/mm/yyyy]
Time [hr:mn:ss]

Can anyone please explain how to insert Run Date & Time in above given format in to the Rept. Hdr.

Thanks.
bsush

 

[JDdev]

Please be more specific wat u want exactly.The data sent by u makes us feel that its just a tech spec.

 

[Adrian_Chimirel]

1. Is it a requirement FOR your client, or FROM your client?
2. Let's suppose I create this report; do I bill YOU, or YOUR client, or BOTH (you for training, and client for report)?
3. It is the FIRST time I see a request like this on the JDEList, but I hope it'll be the last time.

 

[JMR]

Kalyan,

It is not clear whether you are asking for how to make your output look like the document you attached (i.e. with the cell outlining) -OR- whether you are asking for how to go about creating a report based on the specifications you listed.

Please tell me it is just about the cell outlining...If so, Zoltan has provided a means for doing that. I would suggest you tell the requestor that you could create a .csv version that could be loaded to excel and formatted there. The time and cost to try play with getting the cell outlining in RDA is not worth it...IMO.

On the other hand, if you are asking how to create a report based on the given specifications, then you need to pick up a book or get some development training! Maybe you are not a developer, so I don't want to insult you, but the requirement details you were given are A LOT better than most you will ever see. It seems to me every field you need is explained in detail. You will not find many people here that are going to do your work for you. We all have our own jobs and we are all over-worked and under-paid as it is. I don't want to do your job for free while making you look good.

That's just my rant...please disregard the last paragraph if you are only looking for formatting help.