Hello ,
i'm New to Crystal report. i have 2 tables with primary and foreign key

Customer Details

EID - Primary Key

PurchaseDetails

PNo-Primary Key
PDate,
EID- Foreigh Key
NetAmount

Report Query written in c#

SELECT DISTINCT P.PNo, P.PDate, P.PM, P.DisAmt, P.LT, P.NT, P.EID, P.PTime, C.EName FROM PurchaseDetails AS P INNER JOIN CustomerDetails AS C ON P.EID = C.EID

In Report Automattically linked based key.
 
but report data not showing
can u plz anyone tell me solution for this . its very urgent!
            


Edited by Brinda - 02 Apr 2014 at 1:49am

S i checked in query browser its executed and returned data

This is my report loading code

DataSet dd = null;
dd = getdatasetfromquery("SELECT DISTINCT P.PNo, P.PDate, P.PM, P.DisAmt, P.NT,P.LT,P.EID,C.EName FROM PurchaseDetails AS P INNER JOIN CustomerDetails AS C ON P.EID = C.EID");

 Report_PurchaseAll_View report1 = new Report_PurchaseAll_View();
                                ConnectionInfo crConnectionInfo;
                                Tables crTables;
                                TableLogOnInfo crTableLogOnInfo;
                                crTables = report1.Database.Tables;
                                crConnectionInfo = new ConnectionInfo();
                                crConnectionInfo.ServerName = ValidationT_SQLC.Path;
                                crConnectionInfo.DatabaseName = ValidationT_SQLC.Name;

                                foreach (CrystalDecisions.CrystalReports.Engine.Table aTable in crTables)
                                {
                                    crTableLogOnInfo = aTable.LogOnInfo;
                                    crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
                                    aTable.ApplyLogOnInfo(crTableLogOnInfo);
                                }
                                report1.SetDataSource(dd.Tables[0]);
                                crystalReportViewer1.ReportSource = report1;
                                crystalReportViewer1.Refresh();

 public DataSet getdatasetfromquery(string query)
        {
            DataSet ds = new DataSet();
            cmd = con.CreateCommand();
            cmd.CommandText = query.ToString();
            cmd.CommandType = CommandType.Text;
            da = new SqlCeDataAdapter(cmd);
            da.Fill(ds);
            return ds;
        }