TO GET REPORT IN WINDOWS C#

Maneesh A N

int iSalesID ;
            CrystalDecisions.CrystalReports.Engine.ReportDocument rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
            DataSet ds = new DataSet();
            ds = fnExpenseDetailsPrint(iSalesID, AccName, FromDate,ToDate);
            string strReportPath = Application.StartupPath + "\\Reports\\Report2.rpt";
            rpt.Load(strReportPath);
            rpt.SetDataSource(ds.Tables[0]);
            rpt.Refresh();
            crystalReportViewer2.ReportSource = rpt;
            crystalReportViewer2.RefreshReport();
            crystalReportViewer2.ShowCloseButton = true;
            crystalReportViewer2.DisplayGroupTree = false;
            crystalReportViewer2.ShowRefreshButton = true;
            crystalReportViewer2.ShowGroupTreeButton = true;

           crystalReportViewer2.ShowPrintButton = true;

   ERROR
             Error    3    The best overloaded method match for 'Universal.cs.frmExpenseDetailsPrint.fnExpenseDetailsPrint(int, System.DateTime, System.DateTime, string)' has some invalid arguments    D:\New Folder\NAHUL\UNIVERSAL ENTERPRISES\Universal.cs\frmExpenseDetailsPrint.cs    102    18    Universal.cs
Error    4    Argument '2': cannot convert from 'string' to 'System.DateTime'    D:\New Folder\NAHUL\UNIVERSAL ENTERPRISES\Universal.cs\frmExpenseDetailsPrint.cs    102    50    Universal.cs
Error    5    Argument '4': cannot convert from 'System.DateTime' to 'string'    D:\New Folder\NAHUL\UNIVERSAL ENTERPRISES\Universal.cs\frmExpenseDetailsPrint.cs    102    68    Universal.cs

GIVE CODE

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
then you need to set the dateformat for datepicker like below

// Set the Format type and the CustomFormat string.
dateTimePicker1.Format = DateTimePickerFormat.Custom;
dateTimePicker1.CustomFormat = "dd/MM/yyyy";

Regards,
Iftikar
0
Maneesh A N13y ago
ERROR
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

FROM DATE 01/JAN/0001
TO DATE 01/JAN/0001.THIS ARE GETTING
I MADE CORRECT DATE FORMAT IN MY PC AS dd/MMM/yyyy
0
Iftikar Hussain13y ago
are you using your local sql server? if yes, can you check your datetime format of your local pc (under control panel->Regional and Language Option)

Regards,
Iftikar
0
Maneesh A N13y ago
MS SQL 2005..REGIONAL SETTING MEANS?I THINK DATE FORMAT IS WRONG IN MY PC?
0
Iftikar Hussain13y ago
Which database you are using? Is it your local database server or different one? I think the regional setting is mismatched
0
Maneesh A N13y ago
FROM DATE 08/01/2013
TO Date 08/27/2013 .this not insert.taking date from datetime picker
0
Iftikar Hussain13y ago
What is the value you have passed for FromDate and ToDate
0
Maneesh A N13y ago
not getting any values in from date ,to date,name,salesID

DataSet ds = new DataSet();
               ds.Tables.Clear();
               SqlDataAdapter sda = new SqlDataAdapter();
               sda.SelectCommand = new SqlCommand("prctblExpenseMasterDetailsView", ClsConnect.conSql);
               sda.SelectCommand.CommandType = CommandType.StoredProcedure;
               sda.SelectCommand.Parameters.AddWithValue("@iSalesID", iSalesID);
               sda.SelectCommand.Parameters.AddWithValue("@vAccName", AccName);
               sda.SelectCommand.Parameters.AddWithValue("@FromDate", FromDate);
               sda.SelectCommand.Parameters.AddWithValue("@ToDate", ToDate);
               ClsConnect.conSql.Open();
               sda.Fill(ds);
               ClsConnect.conSql.Close();
               return ds;

ERROR

         SQLDATETIME OVERFLOW
0
Iftikar Hussain13y ago
Hi,
Change the below code from

ds = fnExpenseDetailsPrint(iSalesID, AccName, FromDate,ToDate);
to
ds = fnExpenseDetailsPrint(iSalesID, FromDate,ToDate,AccName);

Regards,
Iftikar
0