Aqui esta un volcado de ejemplo para que utilicen o tomen como ejemplo para este reporte.
# phpMyAdmin MySQL-Dump
# version 2.2.6
#
http://phpwizard.net/phpMyAdmin/
#
http://www.phpmyadmin.net/ (download page)
#
# servidor: 127.0.0.1
# Tiempo de Generacion: 02-12-2003 a les 12:50:55
# Version del Servidor: 3.23.49
# Version del PHP: 4.3.2
# Base De Datos : `indmex`
# --------------------------------------------------------
#
# Estructura de tabla para tabla `contratos`
#
DROP TABLE IF EXISTS contratos;
CREATE TABLE contratos (
id int(11) NOT NULL auto_increment,
contrato int(6) NOT NULL default '0',
cliente varchar(70) NOT NULL default '',
tipo char(1) NOT NULL default '',
serie varchar(6) NOT NULL default '',
modelo varchar(20) NOT NULL default '',
cantidad double NOT NULL default '0',
fechareg date NOT NULL default '0000-00-00',
fechacomp date NOT NULL default '0000-00-00',
importe double NOT NULL default '0',
listamat char(1) NOT NULL default '',
fechalm date NOT NULL default '0000-00-00',
anticipo double NOT NULL default '0',
fechaant date NOT NULL default '0000-00-00',
compras char(1) NOT NULL default '',
fechacompra date NOT NULL default '0000-00-00',
fechaprod date NOT NULL default '0000-00-00',
prod_c char(1) NOT NULL default '',
prod_p char(1) NOT NULL default '',
prod_d char(1) NOT NULL default '',
prod_s char(1) NOT NULL default '',
fechater date NOT NULL default '0000-00-00',
embarcado char(1) NOT NULL default '',
pagado char(1) NOT NULL default '',
terminado char(1) NOT NULL default '',
pedido varchar(25) NOT NULL default '',
descripcion varchar(50) NOT NULL default '',
vendedor varchar(15) NOT NULL default '',
producto int(4) NOT NULL default '0',
oficina int(4) NOT NULL default '0',
PRIMARY KEY (id),
KEY contrato (contrato,cliente,tipo,serie,modelo),
KEY listamat (listamat)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `contratos`
#
INSERT INTO contratos VALUES (1, 467, 'INGRIA. ESPECIALIZADA EN REFRIG., SA CV', 'R', '', 'BOMBA 1.5HP #300210', '1', '2003-11-13', '2003-12-25', '9173.39', '', '0000-00-00', '0', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '0000-00-00', '', '', 'V', 'IERI-138-03', '1BOMBA 1.5HP', 'RAR', 605, 1);
INSERT INTO contratos VALUES (2, 468, 'CANCELADO (FRYVITEC)', 'R', '', 'SELLADOR BUTYLO', '2', '2003-11-13', '2003-11-14', '0', '', '0000-00-00', '0', '0000-00-00', '', '0000-00-00', '2003-11-13', '', '', '', '', '2003-11-14', '', '', 'C', 'S/N', 'SELLADOR BUTYLO', 'FLR', 605, 7);
INSERT INTO contratos VALUES (3, 469, 'CONDOMINIO WORLD TRADE CENTER CD. MEXICO', 'R', '', 'REFAC. VARIAS', '0', '2003-11-13', '2003-12-04', '17302.84', '', '0000-00-00', '0', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '0000-00-00', '', '', 'V', 'S/N', 'REFAC. VARIAS', 'AFG', 605, 2);
INSERT INTO contratos VALUES (4, 470, 'FABRICAS MONTERREY, SA CV', 'R', '', 'BANDA Y POLEA', '0', '2003-11-17', '2003-12-15', '4542.92', '', '0000-00-00', '0', '0000-00-00', '/', '0000-00-00', '0000-00-00', '', '', '', '', '0000-00-00', '', '', 'V', '4500047080', 'BANDA Y POLEA', 'AFG', 605, 2);
INSERT INTO contratos VALUES (5, 471, 'RANCHO EL AGUATOCHE, SA DE CV', 'R', '', 'TORNILLERIA', '0', '2003-11-18', '2003-11-18', '1365', '', '0000-00-00', '0', '2003-11-19', '', '0000-00-00', '2003-11-18', '', '', '', '', '2003-11-18', 'X', '', 'T', '2403', 'TORNILLERIA', 'OFNA', 605, 1);
INSERT INTO contratos VALUES (6, 472, 'MANUFACTURAS ESPECIALIZADAS, SA', 'R', '', 'KG. TUBO COBRE 1/4"', '127', '2003-11-18', '2003-11-19', '20095.35', '', '0000-00-00', '0', '2003-11-19', 'X', '0000-00-00', '2003-11-18', '', '', '', '', '2003-11-19', 'X', '', 'T', 'OC-002731', '641 KG. TUBO COBRE', 'OFNA', 605, 1);
INSERT INTO contratos VALUES (7, 473, 'CIA. CERVECERA DE ZACATECAS, SA CV', 'R', '', 'LAINAS P/ACOPLAM.', '1', '2003-11-18', '2003-12-08', '390.92', '', '0000-00-00', '0', '0000-00-00', '/', '2003-11-24', '2003-11-19', '', '', '', '', '2003-11-26', '', '', 'T', '27703', '1 JG. LAINAS ACOPL.', 'LMS', 605, 3);
INSERT INTO contratos VALUES (8, 474, 'HEAVY DUTY, SA DE CV', 'R', '', 'REFAC. VARIAS', '0', '2003-11-19', '2003-12-31', '9657.6', '', '0000-00-00', '5591.37', '2003-11-20', '', '0000-00-00', '0000-00-00', '', '', '', '', '0000-00-00', '', '', 'V', 'S/N', 'REFAC. VARIAS', 'AFG', 605, 2);
INSERT INTO contratos VALUES (9, 475, 'FRYVITEC, SA DE CV', 'R', '', 'ROLLO SELLADOR', '10', '2003-11-19', '2003-11-20', '2110.1', '', '0000-00-00', '2435', '2003-11-19', '', '0000-00-00', '2003-11-19', '', '', '', '', '2003-11-20', 'X', 'X', 'T', '76-03', '10 ROLLO SELLADOR BUTYLO', 'FLR', 605, 7);
INSERT INTO contratos VALUES (10, 476, 'SERVICIOS BTF, SA CV', 'R', '', 'REFAC. VARIAS', '0', '2003-11-19', '2003-12-10', '2114.54', '', '0000-00-00', '0', '0000-00-00', '', '0000-00-00', '2003-11-19', '', '', '', '', '2003-11-20', '', '', 'T', 'S/N', 'REFAC. VARIAS', 'RAR', 605, 1);
INSERT INTO contratos VALUES (11, 477, 'GRUPO I.QU.A., SA DE CV', 'R', '', 'RELLENO Y BANDAS', '0', '2003-11-19', '2003-12-24', '115056.09', '', '0000-00-00', '57808.8', '2003-11-24', '', '0000-00-00', '2003-11-25', '', '', '', '', '0000-00-00', '', '', 'V', '181 / 182', 'RELLENO Y BANDAS', 'RAR', 605, 1);
INSERT INTO contratos VALUES (12, 478, 'PROCITRUS, SA DE CV', 'R', '', '2 VENT. #250092', '2', '2003-11-19', '2003-11-20', '1710.29', '', '0000-00-00', '2008.31', '2003-11-20', 'X', '0000-00-00', '2003-11-19', '', '', '', '', '2003-11-20', 'X', '', 'T', 'S/N', '2 VENT. #250092', 'RAR', 605, 1);
INSERT INTO contratos VALUES (13, 3703, 'EXISTENCIA ALMACEN', 'T', 'FXV', '1-FXV-422', '1', '2002-05-06', '0000-00-00', '0', '', '0000-00-00', '0', '0000-00-00', '', '0000-00-00', '2003-05-02', '', '', '', '', '0000-00-00', '', '', 'V', '', '1-FXV-422', '', 601, 1);
INSERT INTO contratos VALUES (14, 3818, 'INGROS. EN REFRIGERACION, SA CV', 'T', 'VC1', 'VC1-30', '1', '2003-10-14', '2003-12-09', '48304.2', 'X', '2003-11-07', '29102.93', '2003-10-29', '/', '2003-11-24', '2003-10-29', '', '', '', '', '0000-00-00', '', '', 'V', '', '', 'LMS', 603, 3);
INSERT INTO contratos VALUES (15, 3819, 'AQUASISTEMAS INTEGRALES, SA DE CV', 'T', 'FXT', 'FXT-142', '1', '2003-10-16', '2003-12-11', '51335', 'X', '2003-10-24', '31411.41', '2003-10-27', '/', '2003-10-23', '2003-10-21', 'X', 'X', '', '', '0000-00-00', '', '', 'V', 'AQS-1101', '', '669', 601, 5);
INSERT INTO contratos VALUES (16, 3820, 'ALTOPRO, SA DE CV', 'T', '33000', '33646', '1', '2003-10-29', '2003-12-26', '271074', 'X', '2003-11-06', '164374.25', '2003-10-31', '/', '2003-11-24', '2003-10-31', '', '', '', '', '0000-00-00', '', '', 'V', 'B32451', '', '639', 601, 2);
INSERT INTO contratos VALUES (17, 3821, 'MAYEKAWA DE MEXICO, SA DE CV', 'T', 'VC2', 'VC2-420', '1', '2003-10-22', '2003-12-17', '278705.8', 'X', '2003-11-10', '100741.71', '2003-11-07', '/', '2003-11-24', '2003-11-07', '', '', '', '', '0000-00-00', '', '', 'V', '10359', '', '671', 603, 7);
INSERT INTO contratos VALUES (18, 3822, 'PACSA SUMINISTROS Y APLICACIONES, SA DE CV', 'T', 'IL', 'IL-56-7-P3', '2', '2003-10-22', '2003-12-18', '190546', 'X', '2003-10-29', '100000', '2003-10-23', '/', '2003-11-24', '2003-10-28', '/', '', '', '', '0000-00-00', '', '', 'V', '1290', '', '650', 601, 2);
INSERT INTO contratos VALUES (19, 3823, 'JABIL GLOBAL SERVICES', 'T', 'JE', 'JE-31055', '1', '2003-10-30', '2003-12-25', '617780.8', 'X', '2003-11-14', '355223.96', '2003-11-11', '/', '0000-00-00', '2003-11-11', '', '', '', '', '0000-00-00', '', '', 'V', '22AS03424B', '1 JE-31055', '280', 601, 1);
INSERT INTO contratos VALUES (20, 3824, 'ALTOPRO, SA DE CV', 'T', 'VTL', 'VTL-079-K', '1', '2003-11-13', '2004-01-22', '76807.71', 'X', '2003-11-19', '43705.13', '2003-11-13', '/', '0000-00-00', '2003-11-13', '', '', '', '', '0000-00-00', '', '', 'V', 'B32788', '1 VTL-079-K', 'AFG', 601, 2);
INSERT INTO contratos VALUES (21, 3825, 'EATON CONTROLS, S DE RL DE CV', 'T', '33000', '33568', '2', '2003-11-05', '2004-01-02', '489277.12', 'X', '2003-11-12', '278352.75', '2003-11-14', '/', '2003-11-24', '2003-11-12', '', '', '', '', '0000-00-00', '', '', 'V', '5070-000988-00', '2 33568', 'RSG', 601, 1);
INSERT INTO contratos VALUES (22, 3826, 'INGROS. EN REFRIGERACION, SA CV', 'T', 'VC1', 'VC1-46', '1', '2003-11-05', '2003-12-31', '58771.89', 'X', '2003-11-10', '33442.38', '2003-11-10', '/', '2003-11-24', '2003-11-05', '', '', '', '', '0000-00-00', '', 'X', 'V', '364-2003', '1 VC1-46', 'LMS', 603, 1);
INSERT INTO contratos VALUES (23, 3827, 'PACE INDUSTRIES DE MEXICO, SA DE CV', 'T', 'FXT', 'FXT-87', '1', '2003-11-11', '2004-01-20', '51419.85', 'X', '2003-11-25', '29173.47', '2003-11-13', '/', '0000-00-00', '2003-11-13', '', '', '', '', '0000-00-00', '', '', 'V', '2028759', '1 FXT-87', 'GGA', 601, 1);
INSERT INTO contratos VALUES (24, 40798, 'CARRIER MEXICO, S.A. DE C.V.', 'M', '39L', '39LD35', '2', '2003-01-10', '0000-00-00', '7294', '', '0000-00-00', '0', '2020-00-01', '', '0000-00-00', '2020-00-01', '', '', '', '', '0000-00-00', '', '', 'T', '802297', '', '', 601, 1);
INSERT INTO contratos VALUES (25, 41110, 'CARRIER MEXICO, SA DE CV', 'M', '39N', '39NF50', '2', '2003-11-12', '2003-12-24', '161389.49', 'X', '2003-11-14', '0', '0000-00-00', '/', '2003-11-20', '2003-11-17', '', '', '', '', '0000-00-00', '', '', 'V', '803088', '2 39NF50', 'CARRIER', 613, 1);
INSERT INTO contratos VALUES (26, 41111, 'CARRIER MEXICO, SA DE CV', 'M', '39N', '39NF11', '1', '2003-11-18', '2003-12-30', '24144.01', 'X', '2003-11-20', '0', '0000-00-00', '/', '2003-11-26', '2003-11-18', '', '', '', '', '0000-00-00', '', '', 'V', '803105', '1 39NF11', 'CARRIER', 613, 1);