I am new to Sql and looking for some help with this error. Any advice would be apreci

[Sh0eshineboy]

System.Data.SqlClient.SqlException: Divide by zero error encountered
[SqlException: Divide by zero error encountered.]
System.Data.SqlClient.SqlDataReader.Read() +176
System.Data.Common.DbDataAdapter.FillLoadDataRow(S chemaMapping mapping) +175
System.Data.Common.DbDataAdapter.FillFromReader(Ob ject data, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +260
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +129
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
Rtprs.DataAccessors.ShiftProductivityReportAccesso r.GetData(AbstractConnection& p_theConnection, DataSet& p_theDataSet, DateTime p_theDate, String p_sPackLine, Int32 p_iShiftId) +326
Rtprs.BusinessLogic.BLogic.GetDataForShiftProducti vityReport(DateTime dateTime, String packLine, Int32 shiftID, String p_sSortColumns) +141
Rtprs.ShiftProductivityReport.Init() +76
Rtprs.ShiftProductivityReport.Build(HtmlTextWriter writer, RtprsState sessionState, Int32 sortColumnNumber) +45
Rtprs.ReportView.RenderReport(HtmlTextWriter writer) +199
Rtprs.ReportView.Render(HtmlTextWriter writer) +7
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWrite r writer) +72
System.Web.UI.HtmlControls.HtmlForm.RenderChildren (HtmlTextWriter writer) +44
System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTex tWriter output) +262
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Control.RenderChildren(HtmlTextWrite r writer) +72
System.Web.UI.Control.Render(HtmlTextWriter writer) +7
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
System.Web.UI.Page.ProcessRequestMain() +1926

[LitaOsiris]

I would guess from the first line that you're trying to divide by zero somewhere. The best thing to do is have a check on your dividing number that if it's equal to zero, don't do the division, just insert a zero.