Skip to Content
0
Former Member
Feb 18, 2011 at 07:08 AM

Need suggestion for designing a BEx report

28 Views

Hi,

I need suggestions for designing a BEx report.

Iu2019ve a DSO with below structure:

1. Functional Location u2013 Key

2. Maintenance Plan u2013 Key

3. Maintenance Item u2013 Key

4. Call # - Key

5. Cycle u2013 Data Field

6. Planned Date u2013 Data Field

7. Completion Date u2013 Data Field

This DSO contains data like:

Functional -


Plan --- Item -


Call# --- Cycle -


Planned Dt -


Completion Dt

Location

11177 -


134 -


20 -


1 -


T1 -


02-Jan-2011 -


10-Jan-2011

11177 -


134 -


20 -


2 -


T2 -


15-Feb-2011 -


11177 -


134 -


20 -


3 -


T1 -


15-Mar-2011 -


11177 -


134 -


20 -


4 -


M1 -


30-Mar-2011 -


25000 -


170 -


145 -


1 -


T1 -


19-Jan-2011 -


19-Jan-2011

25000 -


134 -


145 -


2 -


T2 -


20-Feb-2011 -


25-Feb-2011

25000 -


134 -


145 -


3 -


T1 -


14-Mar-2011 -


Now Iu2019ve to create a report which will be executed at the end of every month and should display the list of Functional Locations whose Cycles were planned in that particular month, along with the last completed Cycle/Date.

Thus based upon above data, if I execute report at the end of (say) March then report must display:

Functional --- Curr. Cycle --- Planned Date --- Prev. completed Cycle --- Prev Completed Date

Location

11177 -


T1 -


-


-


-


15-Mar-2011 -


--- T1 -


-


-


-


-


-- 10-Jan-2011

11177 -


M1 -


-


-


-


30-Mar-2011 -


--- T1 -


-


-


-


-


-- 10-Jan-2011

25000 -


T1 -


-


-


-


14-Mar-2011 -


--- T2 -


-


-


-


-


-- 25-Feb-2011

Any idea how can I display Previous Completed Cycle and Completion Date (i.e. the last two columns)?

Regards,

Vikrant.