0
I have the following problem, I have a table AVALIAÇÃO and another PACIENTE. I need to generate a whole list of patient evaluations. I already have the query in my datatable that does this, however, I do not know how to display the information of the two tables, since on one side I have all patient information and on the other side I can have several evaluation records, I mean, I will have to use a TABLE for evaluation in the report and other TABLE or TEXTBOX to display patient data.
Query of the EVALUATION datatable:
SELECT avaliacao.*, paciente.* FROM avaliacao a INNER JOIN paciente p ON a.idpaciente = p.id WHERE p.id = @p
you could make two selects, one to bring only the patient data and the other to bring the evaluations of that patient, in which case you would have two Data Sources.
– Geilton Xavier Santos de Jesus
How do I add two data sources to my reportviewer? @Geiltonxavier
– Leomar de Souza
see this link - > http://stackoverflow.com/questions/15826772/using-multiple-datasets-in-rdlc
– Geilton Xavier Santos de Jesus