A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report using cross tab



 
 
Thread Tools Display Modes
  #31  
Old December 2nd, 2009, 04:38 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old December 2nd, 2009, 04:38 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default 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  
Old December 3rd, 2009, 06:44 AM posted to microsoft.public.access.reports
Frank Situmorang[_4_]
external usenet poster
 
Posts: 24
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:27 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.