Tuesday 31 December 2013
Precious stone Reports is an effective programming to outline element and intelligent report intended for engineers. It permits to consider, research, investigate and diffuse reports from the web or combine into organization requisitions. The report is created out of an agreeable and ergonomic realistic interface.
Moreover, Crystal Reports is a mainstream Windows-based report author (report era program) that permits a programmer to make reports from a mixture of information sources with at least composed code. Advanced via Seagate Software, Crystal Reports can access information from most generally utilized databases and can incorporate information from different databases inside one report utilizing Open Database Connectivity (ODBC).
Microsoft Visual Studio 2012 is the most recent Integration Development Environment (IDE) from Microsoft. Be that as it may the inquiry emerges. Why would it be advisable for me to switch over to VS 12, when I am really agreeable with VS 2010 or 2008? This is an address that turns out from generally techies. The majority of us get used to an environment and when another one comes we frequently think to switch over to it. The five characteristics that will propel you to switch over to VS 12:
The All new Look and Feel
It is Ready for Windows 8
Overhauled Web Development Environment
It is Cloud Ready and Up for Serious Business
It has an adaptable and Solid ALM
Microsoft Visual Studio 2012 empowers designers to rapidly make joined provisions that convey rich client encounters. Visual Studio conveys developments for engineers in three essential zones:
Quick Application Development
Achievement User Experiences
In this article I need to produce Crystal Report in Visual studio 2012 for Asp.net. Take after the beneath steps:
Took a Dataset, then included a Datatable. Included three segments as of my sql database table: id, pname, cost.
Took a Crystalreport.rpt and Selected Use Report Wizard. Included dataset.
utilizing Crystaldecisions.crystalreports.engine;
utilizing Crystaldecisions.shared;
utilizing System.data;
utilizing System.data.sqlclient;
open incomplete class _default: System.web.ui.page
{
private Sqlconnection cn = new Sqlconnection("user id=sa;password=chiklu;database=srs;server=chiklu-PC");
ensured void Page_load(object sender, Eventargs e)
{
cn.open();
Sqlcommand cmd = new Sqlcommand("select abcd.id,abcd.pname,qwer.price FROM abcd JOIN qwer ON abcd.id=qwer.id",cn);
Sqldataadapter da = new Sqldataadapter(cmd);
Dataset ds = new Dataset();
da.fill(ds);
Reportdocument rpd = new Reportdocument();
rpd.load(server.mappath("crystalreport.rpt"));
rpd.setdatabaselogon("sa","chiklu","chiklu-Pc","srs");
rpd.setdatasource(ds);
Crystalreportviewer1.reportsource = rpd;
cn.close();
}
}
That is steps to produce precious stone report in Visual studio 2012 for Asp.net.
