Report and Input Schedule in Same Sheet...

[Former Member]

Hi All,

I need to create a Input Schedule which contains a Report in it.

The Scenario is, if am going to enter data for April 2009 the Report should show the values of March 2009.

I some how created a report and Input schedule in same sheet but the report is getting changed according to the Current View selected for Input Schedule.

Please help me out in solving this issue.

Thanks in Advance,

Regards,

G.Vijaya Kumar.

[Former Member]

Vijay,

you can achieve this with a single evdre saved as an Input schedule...

couple of pointers

1)if you do not want to have the col names changing with a change in current view......put a NOEXPAND for the TIme dimension in the expansion range(where you have SELF,DEP etc)

2)for the report part....use getonlyrange to have it pulled from the DB instead of user entering data...

go to helpsite for the exact usage of NOEXPAND and GetOnlyRange..play around enough...i'm sure you'll figure it out!!!!

hope it helps....

[Former Member]

Hi All,

I got the previous month value using the EVTIM function.

Thanks For Reply.

Regards,

G.Vijaya Kumar