protected string GetReport() { string sql = Session["ReportSQL"].ToNonNullString(); string sName = Request.QueryString["Name"] ?? ""; DataTable dt = gData.GetDataTable2(sql); string sCols = Session["ReportColumns"].ToNonNullString(); string[] vCols = sCols.Split(","); string sHTML = "<table class=saved>"; sHTML += GetReportHeader(dt, sCols); int nRowsPerPage = 15; int nRowsConsumed = 0; int nPageNo = (int)GetDouble(Request.QueryString["pag"] ?? ""); int nStartRow = nPageNo * nRowsPerPage; int nEndRow = nStartRow + nRowsPerPage - 1; double nTotalPages = (int)Math.Ceiling((double)(dt.Rows.Count / nRowsPerPage)) + 1; for (int y = nStartRow; y <= nEndRow && y < dt.Rows.Count; y++) { string sRow = "<tr>"; for (int i = 0; i < vCols.Length; i++) { string sValue = dt.Rows[y][vCols[i]].ToNonNullString(); if (sValue.Contains("https://")) { sValue = "<a href='" + sValue + "' target=_blank>View</a>"; } string sMoniker = ""; string sEndMoniker = ""; if (vCols[i] == "TXID") { sMoniker = "<small><nobr>"; sEndMoniker = "</nobr></small>"; } sRow += "<td>" + sMoniker + sValue + sEndMoniker + "</td>"; } sRow += "</tr>"; sHTML += sRow; nRowsConsumed++; if (nRowsConsumed > nRowsPerPage) { break; } } sHTML += "</table>"; string sURL = "Report?name=" + sName; sHTML += UICommon.GetPagControl(sURL, nPageNo, (int)nTotalPages); if (dt.Rows.Count == 0) { sHTML += "<div>You have no sponsored orphans.</div>"; } return(sHTML); }