Page 1 of 1
Attendance Sheet of selective Number of Sessions.
Posted: Thu Apr 20, 2006 3:21 am
by najm
I have attendance sheet reports which have the Fields S. No, Name and about to 45 Blank Boxes I think every one is familiar with the attendance sheet I display the S. No, Name through table and create up to 45 Manual boxes but some times I want the attendance sheet of 40 Session some time 15 sessions is it possible that I can display the field of a boxes in a parameter then I select the parameter when ever I want the attendance sheet of any number of sessions there fore i am saved to create 5 reports.
Najm
Posted: Fri Apr 21, 2006 1:00 am
by admin
There are two ways to do this,
1- Use conditional formating and hide/display on the basis of parameter passed.
2- Use a temp table and insert values at runtime while using dynamic sql.
Hope it would be helpful.
Posted: Fri Apr 21, 2006 1:26 am
by omerjaved100
By using Matrix Report formating, you can pick as many columns as you want from the database on the bases of parameters.
You should take date period as parameter not the session #s.
Regards,
M.Omer Javed
ERP Technical Consultant
Mob:+923214647529/ +923004479693
Posted: Fri Apr 21, 2006 4:47 am
by najm
I think you did not understand please let me know how can i upload any report or form on this forum.
Najm
Posted: Fri Apr 21, 2006 5:20 am
by admin
Pl send me email so I will upload it.
Posted: Fri Apr 21, 2006 9:20 am
by admin
I have modified your report and sent back to you test it and let me know. The final release I would like to share here with all.