Master Report with subreport not working

[germangabrielwle]

Hi, I'm new here and new using Stimulsoft reporter por C#,

I have a question y want to make a report with subreports multiple times, but I'm using a Dataset/DataTables for the Data Source, and then I created two tables
with the columns I need to make my report.



And this is the way I created the relation between tables


and then this happens when I sent the DataSet


And this is my SQL Query

Code: Select all

SELECT DISTINCT t1.planta_nombre as \"Planta\", t1.folio_lineup as \"Folio\", t2.folio_lineup, t1.num_rpo as \"RPO\", t1.producto_nombre as \"Modelo\", t1.linea_nombre as \"Linea\", t1.turno as \"Turno\", t1.fecha_lineup as \"Fecha\", t2.num_empleado as \"Num. Emp.\", concat(t2.nom_empleado, concat(' ', t2.apellido_empleado)) as \"Nombre\", t2.operacion_nombre as \"Operación\", t2.nombre_nivel_empleado as \"Nivel Emp.\", t6.nombre as \"Nivel Req.\", t2.cumple_certificacion as \"Cumple Nivel\",t2.is_transferencia as \"Transferencia\", t7.nombre as \"Linea Emp.\" FROM line_up t1 " +
                "inner join detalle_lineup t2 on t2.folio_lineup = t1.folio_lineup " + 
            " inner join nivel_entrenamiento t6 on nivel_requerido = idnivel " +
            " inner join lineas t7 on t7.idLinea = t2.linea_actual 

[Lech Kulikowski]

Hello,

Please send us a sample report with test data for analysis.

Thank you.