hola cluster gracias por tu ayuda he hecho lo me digiste utilizando multicell, pero no me sale bien sigue igual los textos se me salen del area de la celda, mira este el código
Código PHP:
$conex=mysql_connect("localhost", "root", "");
$conectarse= mysql_select_db("kansei", $conex);
//if (!isset($_REQUEST["id_matriz"])) { $id_matriz=45;}
$sql = "SELECT rt.descripcion, rt.id_rtecnico".
" FROM rtecnico rt, matriz m".
" WHERE m.id_matriz=rt.id_matriz AND m.id_matriz=$id_matriz";
$sql2 = "SELECT rc.descripcion, rc.importancia, rc.id_rcliente".
" FROM rcliente rc, matriz m".
" WHERE rc.id_matriz=m.id_matriz AND m.id_matriz=$id_matriz";
$query = mysql_query($sql);
$query2 = mysql_query($sql2);
$num = mysql_num_rows($query);
$num2 = mysql_num_rows($query2);
require('fpdf.php');
require('rotation.php');
class PDF extends PDF_Rotate
{
function RotatedText($x,$y,$txt,$angle)
{
//Text rotated around its origin
$this->Rotate($angle,$x,$y);
$this->Text($x,$y,$txt);
$this->Rotate(0);
}
}
$pdf=new PDF('L','cm','Letter');
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Arial','',8);
$pdf->SetDrawColor(102,153,204);
$pdf->SetLineWidth(.0);
$pdf->Ln(2);
$pdf->Cell(2)
$pdf->Multicell(2,8,'',1,'J',0);
//$pdf->Multicell(2,1,'Prioridad',1,0,'C');
$pdf->RotatedText(100,60,'Prioridad',90);
if ($num > 0)
{
$i=0;
while ($row = mysql_fetch_array($query))
{
$pdf->Multicell(4,8,$row["descripcion"],1,'J',0);
$rt[$i] = $row[1];
$i++;
}
$pdf->SetFont('','B');
$pdf->Cell(2)
$pdf->Multicell(3,1,'V. Cliente',1,'J', 0);
$pdf->Multicell(3,1,'V. Comp.',1,'J', 0);
$pdf->SetFont('Arial','',8);
if($num2 > 0) {
while ($row2 = mysql_fetch_array($query2))
{
//$pdf->Multicell(2,1,$row2["descripcion"],1,0,'C');
$pdf->Cell(2)
$pdf->MultiCell(2,8,$row2['descripcion'],0,'J',0);
$pdf->Multicell(2,8,$row2["importancia"],0,'J',0);
foreach($rt as $newrt)
{
$sql3 = "SELECT rtrc.valor".
" FROM rtecnico_rcliente rtrc".
" WHERE rtrc.id_rtecnico='$newrt' AND rtrc.id_rcliente='".$row2["id_rcliente"]."'
AND rtrc.id_matriz=$id_matriz";
$query3 = mysql_query($sql3);
$row3 = mysql_fetch_array($query3);
if($row3["valor"]=="")
{
$pdf->Cell(2)
$pdf->Multicell(4,1,"-",1,'J',0);
}else
{
$pdf->Cell(2)
$pdf->Multicell(4,1,$row3["valor"],1,'J',0);
}
}
$sql4 = "SELECT rc.vlr_cliente, rc.vlr_competidor".
" FROM rcliente rc".
" WHERE rc.id_rcliente='".$row2["id_rcliente"]."' AND rc.id_matriz=$id_matriz";
$query4 = mysql_query($sql4);
while($row4 = mysql_fetch_array($query4))
{
if($row4["vlr_cliente"]==""){
$pdf->Cell(2)
$pdf->Multicell(3,1,"ss",1,'J',0);
}else{
$pdf->Cell(2)
$pdf->Multicell(3,1,$row4["vlr_cliente"],1,'J',0);
}
if($row4["vlr_competidor"]==""){
$pdf->Cell(2)
$pdf->Multicell(3,1,"-",1,'J',0);
}else{
$pdf->Cell(2)
$pdf->Multicell(3,1,$row4["vlr_competidor"],1,'J',0);
}
}
}
}
$titulos = array("Situación Empresa", "Situación Empresa Competidora", "Benchmark");
$campos = array("sit_empresa", "sit_competencia", "benchmark");
for($t=0;$t<count($titulos);$t++)
{
$pdf->Multicell(4,1,$titulos[$t],1,'J',0);
foreach($rt as $newrt)
{
$sql5 = "SELECT rt.".$campos[$t].
" FROM rtecnico rt".
" WHERE rt.id_rtecnico='$newrt' and rt.id_matriz='$id_matriz'";
$query5 = mysql_query($sql5);
$num5 = mysql_num_rows($query5);
if($num5>0)
{
while($row = mysql_fetch_array($query5))
{
$pdf->Cell(2)
$pdf->Cell(4,1,$row[0],1,'J',0);
}
}
}
$pdf->Cell(2)
$pdf->Multicell(3,1,'',1,'J',0);
$pdf->Multicell(3,1,'',1,'J',0);
}
}
$pdf->Output();
podrias decirme si depronto tengo mal usado el multicell por fa.