Hi,

I need your help and suggestion in customize session (update session). That is I have the data as below:
(1) Item code
(2) Revision No.
(3) Week
(4) Quantity (500pcs)

Eg: (1) Item Code : 123-123
(2) Revision No. : Rev1
(3) Week : week 31,2015; week 34,2015; week 1,2016
(4) Quantity : 20pcs, 400pcs, 80pcs

(1) Item Code : 123-123
(2) Revision No. : Rev2
(3) Week : week 31,2015; week 34,2015; week 50,2015; week 1,2016
(4) Quantity : 100pcs, 200pcs, 150pcs, 50pcs

(1) Item Code : 123-123
(2) Revision No. : Rev3
(3) Week : week 31,2015; week 34,2015; week 1,2015; week 5,2016
(4) Quantity : 200pcs, 150pcs, 60pcs, 90pcs

When update, I want to show a session layout as below:
---------------------------------------------------------------------------------------------------------
| | Wk31,2015 | Wk34,2015 | Wk50, 2015 | Wk1,2016 | Wk5,2016 | ....|
----------------------------------------------------------------------------------------------------------
| REV1 | 20pcs | 400pcs | 0pcs | 80pcs | 0pcs | ....|
| REV2 | 100pcs | 200pcs | 150pcs | 50pcs | 0pcs | ....|
| REV3 | 200pcs | 150pcs | 0pcs | 60pcs | 90pcs | ....|
| . | . | . | . | . | . | ....|
| . | . | . | . | . | . | ....|
| . | . | . | . | . | . | ....|
----------------------------------------------------------------------------------------------------------

Is it possible can make session like that? And how can i keep the data in table to display? Please advise. Thanks.

Hi,

You need to have an update session to update the data into a customized table.

Now, in the customized table, you need Week Number field and Year Field.

The basic thing here is to design your table in such a way that its easy to display the data as you need.

Customizing the session is the next part.

1st you need to decide on no. weeks you want to show on session , for example.. next 10 weeks from current week .

if you are ok with n - weeks , you should have a temp table with to hold n quantities + the key fields.

what bhushan said can be combined in a single session , you can create a maintain session on temp table and on before.prorgam you can clear the temp table and reinsert the data and fill in the quantity values (as per your logic).
you can always change the form labels in the program.

Hi,

You need to have an update session to update the data into a customized table.

Now, in the customized table, you need Week Number field and Year Field.

The basic thing here is to design your table in such a way that its easy to display the data as you need.

Customizing the session is the next part.

Hi, thanks for your reply.

I can update the data into table, but when display in the session got a problem. It cannot display the data as user requested. Please refer my attached file more details.

My table data as below:

1) Item*
2) Total Qty
3) Revision*
4) Week
5) Year
6) Week Description*
7) Quantity

Noted: * is indices key

Please advise. Thanks.

1st you need to decide on no. weeks you want to show on session , for example.. next 10 weeks from current week .

if you are ok with n - weeks , you should have a temp table with to hold n quantities + the key fields.

what bhushan said can be combined in a single session , you can create a maintain session on temp table and on before.prorgam you can clear the temp table and reinsert the data and fill in the quantity values (as per your logic).
you can always change the form labels in the program.

Hi,

Thanks for your reply. I cannot fix the week because user can key in more than one year for the planned delivery date. If I fix the week, then the table will have a lot fields. Please advise. Thanks.

Hi,

As Vamsi suggested, you need to decide the number of Weeks you need to show on your session. It can't be X weeks. AFAIK, there is no way to add data dynamically to the session.

Another way is to create a window and add data as per your requirement using dialog.* function.

But again that will make things complicated to program.

Lookng at your table definition, I think you will need to tweak it. Instead of Week as single field, you might need to add Week 1, Week 2, Week 3 and fill the data accordingly with Week 1 Quantity, Week 2 Quantity ...

This will make things easy to show.

The last option is to have Week Description as Vew field.

Hi,

As Vamsi suggested, you need to decide the number of Weeks you need to show on your session. It can't be X weeks. AFAIK, there is no way to add data dynamically to the session.

Another way is to create a window and add data as per your requirement using dialog.* function.

But again that will make things complicated to program.

Lookng at your table definition, I think you will need to tweak it. Instead of Week as single field, you might need to add Week 1, Week 2, Week 3 and fill the data accordingly with Week 1 Quantity, Week 2 Quantity ...

This will make things easy to show.

The last option is to have Week Description as Vew field.

Hi,

Thanks for your reply and suggestion. I will try it. Thanks for your help. ^^

if the user want ... X no. of week then it should be .. report rather than .. session ..

;)

hi,
You can user PL/SQL and get that such report with report builder.