How do I create reports through Crystal Reports using a DataSet that contains more than one Table? With a table I can work normal, but when I insert more than one table the result of the Report is blank. The only thing I did after the connection was to select the Data Field's and paste it into the report.
Follow images:
Also follows my flashy report by MVC:
public ActionResult relatorio_pdf()
{
connectionRateio.ConectarBanco(modelLoginRateio);
DataTable dataTable = new DataTable();
var query = @"SELECT * FROM MYTABLE MT INNER JOIN MYOTHERTABLE MOT ON MT.ID = MOT.ID";
var command = new OracleCommand(query, connectionRateio.connection);
var dataAdapter = new OracleDataAdapter(command);
dataAdapter.Fill(dataTable);
ReportClass rptH = new ReportClass();
rptH.FileName = Server.MapPath("~/Views/Relatorios/relatorio.rpt");
rptH.Load();
rptH.SetDataSource(dataTable);
Stream stream = rptH.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
connectionRateio.FecharConexaoBanco();
return File(stream, "application/pdf");
}