Crystal report in VS 13

scropio gurl

I have web static webmethod i.e

[WebMethod]
public static string search_data(DateTime fromdate, DateTime todate, string region)
{
try
{
string result = "";
Ts1 td = new T1();
DateTime frDate = new DateTime(fromdate.Year, fromdate.Month, fromdate.Day, 0, 0, 0);
DateTime to_Date = new DateTime(todate.Year, todate.Month, todate.Day, 23, 59, 59);
List dq = td.griddataresult(frDate, to_Date, region).ToList();
DataTable dt = new DataTable();
dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("OwnerName", typeof(string));
dt.Columns.Add("RegNo", typeof(string));
foreach (var c in dq)
{
dt.Rows.Add(c.ID, c.OwnerName, c.RegNo);
}
result = DataSetToJSON(dt);
return result;
}
catch (Exception)
{
throw new Exception();
}

i call this static web method in jquery and i populate table with the help of jquery like this

var final = JSON.parse(result.d).response;
console.log(JSON.parse(result.d).response);
$("#tabledata").empty();
if (final.length > 0) {
$("#tabledata").append(
"IDOwnerRegNo");
for (var i = 0; i < final.length; i++) {
if (final[i] !== null) {
$("#tabledata").append("" +
final[i][0] + " " +
final[i][1] + " " +
final[i][2] + " ");
}
}
$("#tabledata tr:first").addClass('GridviewScrollHeader');
$("#tabledata tr").addClass('GridviewScrollItem');
$("#tabledata").addClass('GridviewScrollPager');
}
else {
$("#tabledata").hide();
$("#<%=Label5.ClientID%>").text("No data");
}
},

Data is successfully display in table . In web form page there is one drop-down and two date-picker (from date & to date) according to selection of these values table data is display is tablenow i want to create crystal report i want when i click on export button then table data ,drop down value & date-picker value will be display in report

how i display region, from date, to date value and table data in crystal report how i do this

2 Replies

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

scropio gurl10y ago
@
Karthik Elumalai
now i try this
now i add this in webform
protectedvoidButton5_Click(objectsender,EventArgse)
{
DataTabledt=Session["datagrid"]asDataTable;
ReportDocumentcrystalReport=newReportDocument();
//crystalReport.SetParameterValue("fromdate",fromdate);
//crystalReport.SetParameterValue("todate",todate);
//crystalReport.SetParameterValue("region",region);
BindReport(crystalReport);
ExportFormatTypeft=ExportFormatType.NoFormat;
ft=ExportFormatType.PortableDocFormat;
}
privatevoidBindReport(ReportDocumentcrystalReport)
{
TrackDataEntities1t=newTrackDataEntities1();
crystalReport.Load(Server.MapPath("data.rpt"));
//griddataresult_Resultdsc=t.griddataresult(fromdate,todate,region);
//crystalReport.SetDataSource(dsc);
CrystalReportViewer1.ReportSource=crystalReport;
}
HTML
<asp:DropDownListID="regiond"runat="server"AutoPostBack="True"onselectedindexchanged="regiond_SelectedIndexChanged">
</asp:DropDownList>
<inputID="fromdate"value="dd/mm/yyyy"runat="server"clientidmode="static"/>
<inputID="todate"value="dd/mm/yyyy"runat="server"clientidmode="static"/
this show nothing in report check this image
as you see there is table display with data now i want to display that table in report also from date and to date and region value in report
Karthik Elumalai10y ago
Hi Scropio gurl,
Hope that below links will be surely useful for you.
http://www.aspdotnet-suresh.com/2014/12/crystal-reports-example-in-aspnet-using-dataset-datatable-in-csharp.html
One more reference , Below link done same using sql server table directly
http://www.c-sharpcorner.com/UploadFile/rahul4_saxena/create-crystal-report-in-Asp-Net/?
kindly let me know your feedback or thoughts
thanks
karthik