System.Data.SqlClient.SqlException (0x80131904): Divide by zero error encountered. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Synbuf.Component.DAL.DataOperation.GetData(String query) in D:\2. Synbuf\0. My Working\Testing\Strong Tech\Synbuf.Component.DAL\DataOperation.cs:line 55 at Synbuf.Component.DAL.DataAccess.GetData(String query) in D:\2. Synbuf\0. My Working\Testing\Strong Tech\Synbuf.Component.DAL\DataAccess.cs:line 35 at Synbuf.Component.BL.InvoiceBL.getSalesForProfitAndLoss(String From, String To, String Department, String JobId) in D:\StrongTech\Synbuf.Component.BL\InvoiceBL.cs:line 539 at Synbuf.Component.UI.RptProfitAndLoss.loadSales() in D:\StrongTech\Synbuf.Component.UI\Reports\RptProfitAndLoss.aspx.cs:line 56 at Synbuf.Component.UI.RptProfitAndLoss.btnSearch_Click(Object sender, EventArgs e) in D:\StrongTech\Synbuf.Component.UI\Reports\RptProfitAndLoss.aspx.cs:line 80 ClientConnectionId:fe536fcd-73d1-4662-8cf0-8bd72f8f5cda Error Number:8134,State:1,Class:16 STRONG TECH ENGINEERING SERVICES AND RESEARCH(I) PVT LTD
Profit & Loss Report
Report
From To
Summary
Total Sales Total Expense Profit/Loss
_ _ _
Sales
  Expenses