If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#31
|
|||
|
|||
Nurut and Bidang Pelayanan
I have created a demo mdb of this concept. You can download it from
http://www.access.hookom.net/samples/memberships.zip. It has some different form, control, table, and field names but you should be able to convert. -- Duane Hookom Microsoft Access MVP "Frank Situmorang" wrote: In the Mainreport query are only 2 fields, i.e : Nurut(Sequence number of the Position) and Bidang Pelayanan ( Posisiton Description), so we can not link main report with the child report. If what you meant is to type 2009, 2008, 2007, accros the detail of the main report, this is not dynamic anymore?, because I have upt 11 years now in my database. Thanks for your advice. Frank Duane Hookom wrote: The subreport should not have any text boxes with Control Sources like=Forms! 01-Dec-09 The subreport should not have any text boxes with Control Sources like =Forms!frm... You were suppose to substitute your actual form and control name which would be [Forms]![frmTahundipilih]![cboEndYear] Both of your report querys have a criteria that limits them to a single year. Try a main report query of my suggestion earlier. There should be no year or name fields in this query. SELECT PelayanJemaat.Nurut, PelayanJemaat.BidangPelayanan FROM PelayanJemaat GROUP BY PelayanJemaat.Nurut, PelayanJemaat.BidangPelayanan The subreport query should be: SELECT PelayanJemaat.Nurut, PelayanJemaat.BidangPelayanan, NamaPel, TahunPel FROM PelayanJemaat WHERE [TahunPel] Between Forms!frmTahundipilih!cboEndYear- 4 AND Forms!frmTahundipilih!cboEndYear; You should have the 5 text boxes that would display the 5 years across the top of the detail section in the main report. Below each of these should be a copy of the subreport. You use the link master/child properties to filter each subreport to the appropriate fields. These fields will include the text boxes displaying the years as part of the Link Master. The link child field that links with the text boxes is the TahunPel which I assume is a field storing the year like 2009, 2008, 2007,... -- Duane Hookom Microsoft Access MVP "Frank Situmorang" wrote: Previous Posts In This Thread: Submitted via EggHeadCafe - Software Developer Portal of Choice Power of Reflection: Creating an Object Factory http://www.eggheadcafe.com/tutorials...tion-crea.aspx . |
#32
|
|||
|
|||
Nurut and Bidang Pelayanan
I have created a demo mdb of this concept. You can download it from
http://www.access.hookom.net/samples/memberships.zip. It has some different form, control, table, and field names but you should be able to convert. -- Duane Hookom Microsoft Access MVP "Frank Situmorang" wrote: In the Mainreport query are only 2 fields, i.e : Nurut(Sequence number of the Position) and Bidang Pelayanan ( Posisiton Description), so we can not link main report with the child report. If what you meant is to type 2009, 2008, 2007, accros the detail of the main report, this is not dynamic anymore?, because I have upt 11 years now in my database. Thanks for your advice. Frank Duane Hookom wrote: The subreport should not have any text boxes with Control Sources like=Forms! 01-Dec-09 The subreport should not have any text boxes with Control Sources like =Forms!frm... You were suppose to substitute your actual form and control name which would be [Forms]![frmTahundipilih]![cboEndYear] Both of your report querys have a criteria that limits them to a single year. Try a main report query of my suggestion earlier. There should be no year or name fields in this query. SELECT PelayanJemaat.Nurut, PelayanJemaat.BidangPelayanan FROM PelayanJemaat GROUP BY PelayanJemaat.Nurut, PelayanJemaat.BidangPelayanan The subreport query should be: SELECT PelayanJemaat.Nurut, PelayanJemaat.BidangPelayanan, NamaPel, TahunPel FROM PelayanJemaat WHERE [TahunPel] Between Forms!frmTahundipilih!cboEndYear- 4 AND Forms!frmTahundipilih!cboEndYear; You should have the 5 text boxes that would display the 5 years across the top of the detail section in the main report. Below each of these should be a copy of the subreport. You use the link master/child properties to filter each subreport to the appropriate fields. These fields will include the text boxes displaying the years as part of the Link Master. The link child field that links with the text boxes is the TahunPel which I assume is a field storing the year like 2009, 2008, 2007,... -- Duane Hookom Microsoft Access MVP "Frank Situmorang" wrote: Previous Posts In This Thread: Submitted via EggHeadCafe - Software Developer Portal of Choice Power of Reflection: Creating an Object Factory http://www.eggheadcafe.com/tutorials...tion-crea.aspx . |
#33
|
|||
|
|||
Thanks for your enlighting
PK Duane...thanks very much, I will try to figure it out based on your sample. The big difference with mine, that there are 5 copies of subreport while you prebiously said we only need a subreport means one subreport. Probably my problem also is language understanding English.
I will let you know when it works Thanks in advance Frank Duane Hookom wrote: I have created a demo mdb of this concept. You can download it fromhttp://www. 02-Dec-09 I have created a demo mdb of this concept. You can download it from http://www.access.hookom.net/samples/memberships.zip. It has some different form, control, table, and field names but you should be able to convert. -- Duane Hookom Microsoft Access MVP "Frank Situmorang" wrote: Previous Posts In This Thread: Submitted via EggHeadCafe - Software Developer Portal of Choice A Developer's Guide To SQL Server Profiler http://www.eggheadcafe.com/tutorials...ide-to-sq.aspx |
Thread Tools | |
Display Modes | |
|
|