Some of the names in the bottom row per group are not shown

[Frank Situmorang]

Hello Duane,


First fo all, please excuse me for I take a libery to send you directly not
thru news group, that is because I can not see anymore my recent postings. It
seems that I was blocked, I do not know.

Last time you taught me how to make a cross tab with dynamic column heading
by year. I works perfectly as far as I know. However when I noticed for so
the position like deacons who have many persons, some person names are not
shown in the botoom row per group. I looks in the report only part of the
name is shown. For example " John Huss, only shown John Hu.....it looks like
the probem is in the format of the report. But I have tried all and still not
succesful.

Could you please help me?, this is the crosstab query:
PARAMETERS [Forms]![frmTahundipilih]![cboEndYear] Short;
TRANSFORM First(Concatenate("SELECT NamaPel FROM PelayanJemaat WHERE
BidangPelayanan='" & [BidangPelayanan] & "' AND TahunPel =" & [TahunPel] & "
ORDER BY ID_pel",Chr(13) & Chr(10))) AS Expr2
SELECT PelayanJemaat.Nurut, PelayanJemaat.BidangPelayanan
FROM PelayanJemaat
GROUP BY PelayanJemaat.Nurut, PelayanJemaat.BidangPelayanan
PIVOT "Yr" & Forms!frmTahundipilih!cboEndYear-[TahunPel] In
("Yr0","Yr1","Yr2","Yr3","Yr4");


Thanks in advance

Frank,

 

[Dale Fye]

Frank,

My guess is that the text boxes you are using on your report are too narrow
to display the entire name.

 

[Duane Hookom]

I believe I answered this a while back but considering the issues with the
news groups lately, I am not surprised if the answer doesn't show.

A crosstab query is a form of a totals query. Generally totals queries will
not display more than 255 characters in any column. If this is your issue,
you may need to find a different solution. You may be able to use 5 copies of
the same subreport on a main report with a record source that is a simple
group by, not a crosstab.
--
Duane Hookom
Microsoft Access MVP

Frank,

My guess is that the text boxes you are using on your report are too narrow
to display the entire name.

----
HTH
Dale

Hello Duane,


First fo all, please excuse me for I take a libery to send you directly not
thru news group, that is because I can not see anymore my recent postings. It
seems that I was blocked, I do not know.

Last time you taught me how to make a cross tab with dynamic column heading
by year. I works perfectly as far as I know. However when I noticed for so
the position like deacons who have many persons, some person names are not
shown in the botoom row per group. I looks in the report only part of the
name is shown. For example " John Huss, only shown John Hu.....it looks like
the probem is in the format of the report. But I have tried all and still not
succesful.

Could you please help me?, this is the crosstab query:
PARAMETERS [Forms]![frmTahundipilih]![cboEndYear] Short;
TRANSFORM First(Concatenate("SELECT NamaPel FROM PelayanJemaat WHERE
BidangPelayanan='" & [BidangPelayanan] & "' AND TahunPel =" & [TahunPel] & "
ORDER BY ID_pel",Chr(13) & Chr(10))) AS Expr2
SELECT PelayanJemaat.Nurut, PelayanJemaat.BidangPelayanan
FROM PelayanJemaat
GROUP BY PelayanJemaat.Nurut, PelayanJemaat.BidangPelayanan
PIVOT "Yr" & Forms!frmTahundipilih!cboEndYear-[TahunPel] In
("Yr0","Yr1","Yr2","Yr3","Yr4");


Thanks in advance

Frank,