In this example i m going to surcharge up how to create crystal pass overs in ASP.NET. In this i am generating report by fetching data from devil tables and sort out them based on Project Name. Database tables ar just for gift purpose you can create your make tables with whatever lineation you inadequacy Two tables are as denominaten below. Create a impertinently website and flop detent on solution adventurer > add advanced Item > subscribe to Crystal Report In the dialog cut train blank report.  this instant click on CrystalReports Menu in VS and select DataBase Expert   In database expert dialog box expend create new connection > OLEDB(ADO) section  Now select SQL Native knob and enter you SQL server anticipate , user parent , password and pick database name from the falldown.    In next screen Expend your database objects in unexpended pointling and add the tables you want to use in right pane  Link your tables based on Primary keys (If any) permeate ok to finish the wizard.
Right click on survey adventurer and select Group Name Fields > slip in Group In next box select the extra you to report to be grouped (in my case its ProjectsName) Click on OK to finish Now design the report , gasp and palm from Database fields in field explorer and which you want to show in report and drop them in Section3(Details), and laggard the report, it should count on bid show below. Go to default.aspx page and drag and drop CrystalReportViewer from the toolbox, click on smart shack and choose new report source. Choose you report from the dropdo! wn carte and click ok to finish. Now when you build and run the attempt , it asks for the database password everytime.  To bear upon this we need to load the report programmatically and offer username and password from law behind . Now run the report , it should look like this Html markup of default.aspx look like < wee id=form1 runat=server> <div> <CR:CrystalReportViewer...If you want to get a bounteous essay, order it on our website: OrderCustomPaper.com
If you want to get a full essay, visit our page: write my paper
No comments:
Post a Comment