RE:mostrar datos en reporte
gracias y disculpa mi insistencia tienes razon... esta es la programacion la sql y la impresion pdf como hago para hacer en base a esto lo q pregunte antes??..
$SQL = "SELECT ordenes.norden,
cliente.nombre,
ordenes.enviado,
ordenes.fechaorden,
ordenes.fecharequerida,
tipoorden,
(SELECT sum(ordenesdetallado.costo* ordenesdetallado.cant)
FROM ordenesdetallado
WHERE ordenesdetallado.norden = ordenes.norden
AND ordenesdetallado.estado = 3) as monto
FROM ordenes,
ordenesdetallado,
cliente,
tipoorden
WHERE ordenes.norden = ordenesdetallado.norden
AND ordenes.codcliente= cliente.codcliente
AND ordenes.tipoorden = tipoorden.codtipo
AND estado = 3";
if ($_POST['Cliente'] != 'Todos' ) $SQL .= "
AND ordenes.codcliente = '" . $_POST['Cliente'] . "' ";
if ($_POST['Types'] != 'Todos' ) $SQL .= "
AND ordenes.tipoorden ='" . $_POST['Types'] . "' " ;
$SQL .= "
AND ordenes.fechaorden >='" . FormatDateForSQL($_POST['FromDate']) . "'
AND ordenes.fechaorden <='" . FormatDateForSQL($_POST['ToDate']) . "'
GROUP BY ordenes.norden,
cliente.nombre,
ordenes.enviado,
ordenes.fechaorden,
ordenes.fecharequerida,
tipoorden
ORDER BY ordenes.tipoorden, ordenes.norden";
$ErrMsg = _('No items');
$DbgMsg = _('The SQL used to retrieve the search was');
$Result = DB_query($SQL,$db,$ErrMsg,$DbgMsg);
/*PDFStarter.php */
include('includes/PDFStarter.php');
$pdf->addinfo('Title',_('Reporte por Tipo de Pedido'));
$pdf->addinfo('Subject',_('Orders from') . ' ' . $_POST['FromDate'] . ' ' . _('to') . ' ' . $_POST['ToDate']);
$line_height=12;
$PageNumber = 0;
$TotalDiffs = 0;
include ('include/PDFHeader.inc'); //encabezado
$OrderNo =0;
while ($myrow=DB_fetch_array($Result)){
if ($YPos - (2 *$line_height) < $Bottom_Margin){
/*Then set up a new page */
$PageNumber++;
include ('include/PDFHeader.inc'); //encabezado
$OrderNo=0;
} /*end */
if($norden!=0 AND $norden != $myrow['norden']){
$pdf->line($XPos, $YPos,$Page_Width-$Right_Margin, $YPos);
$YPos -= $line_height;
}
if ($myrow['norden']!=$norden ){
$LeftOvers = $pdf->addTextWrap($Left_Margin,$YPos,320,$FontSize,$myrow['nombre'], 'left');
$LeftOvers = $pdf->addTextWrap($Left_Margin+180,$YPos,40,$FontSize,$myrow['norden'], 'left');
$LeftOvers = $pdf->addTextWrap($Left_Margin+230,$YPos,80,$FontSize,$myrow['tipoorden'], 'left');
$LeftOvers = $pdf->addTextWrap($Left_Margin+330,$YPos,100,$FontSize,ConvertSQLDate($myrow['fechaorden']), 'left');
$LeftOvers = $pdf->addTextWrap($Left_Margin+400,$YPos,80,$FontSize,ConvertSQLDate($myrow['fecharequerida']), 'left');
$LeftOvers = $pdf->addTextWrap($Left_Margin+480,$YPos,60,$FontSize,$myrow['monto'], 'right');
$YPos -= ($line_height);
$YPos -= ($line_height);
if ($YPos - (2 *$line_height) < $Bottom_Margin){
/*new page */
$PageNumber++;
include ('includes/PDFHeader.inc');
$norden'=0;
//$pdf->line($Page_Width-$Right_Margin, $YPos+10 ,220, $YPos+10);
} /*end */
// $pdf->line($Page_Width-$Right_Margin, $YPos+10,$Left_Margin, $YPos+10);
} }/* end of while */
}
$buf = $pdf->output();
$len = strlen($buf);
header('Content-type: application/pdf');
header('Content-Length: ' . $len);
header('Content-Disposition: inline; filename=Orden.pdf');
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
$pdf->stream();