Hello, I am writing to ask for help from the community because I know that here I will certainly find the solution to my problem. I have been looking for several days without success. I am a novice in vb.net programming
I would like to display data in a rdlc report matrix, but all the data do not appear.
I have three tables in my project:
tbEleve
tbNotes
tbMaterials
I attach these three tables with the following query:
SELECT DISTINCT tbEleve.Matricule, tbEleve.Nom, tbMatieres.Matiere, tbNotes.NoteEleve, tbMatieres.Coef
FROM ((tbEleve INNER JOIN
tbMatieres ON tbEleve.ID_Classe = tbMatieres.ID_Classe) INNER JOIN
tbNotes ON tbMatieres.ID_Matiere = tbNotes.ID_Matiere AND tbEleve.Matricule = tbNotes.MatriculeEleve)
UNION ALL
SELECT tbEleve_1.Matricule, tbEleve_1.Nom, tbMatieres_1.Matiere, tbEleve_1.ID_Notes, tbMatieres_1.Coef
FROM (tbEleve tbEleve_1 INNER JOIN
tbMatieres tbMatieres_1 ON tbEleve_1.ID_Classe = tbMatieres_1.ID_Classe)
which gives me the following result in the query generator:
In short, my matrix does not display all the data of my data adapter.
What I have tried:
I have attached my tables with the following sql query
SELECT DISTINCT tbEleve.Matricule, tbEleve.Nom, tbMatieres.Matiere, tbNotes.NoteEleve, tbMatieres.Coef
FROM ((tbEleve INNER JOIN
tbMatieres ON tbEleve.ID_Classe = tbMatieres.ID_Classe) INNER JOIN
tbNotes ON tbMatieres.ID_Matiere = tbNotes.ID_Matiere AND tbEleve.Matricule = tbNotes.MatriculeEleve)
UNION ALL
SELECT tbEleve_1.Matricule, tbEleve_1.Nom, tbMatieres_1.Matiere, tbEleve_1.ID_Notes, tbMatieres_1.Coef
FROM (tbEleve tbEleve_1 INNER JOIN
tbMatieres tbMatieres_1 ON tbEleve_1.ID_Classe = tbMatieres_1.ID_Classe)
I use an access database