Authoring environment
vs2013,sqlserver2012
Since we installed 2013 no Crystal report, so we need to manually download and install
To Http://www.aspsnippets.com/Articles/Download-Crystal-Reports-for-Visual-Studio-2013.aspx
Then we'll write our Crystal Report, and before we write it we need to understand that there are two ways of crystal reporting
1.pull Pull
Pull means to connect to the database and then return the data when you use it.
2.push push
Push means to save locally, to use when the local push to the Crystal Report engine
In order to write a crystal report, we also need to prepare the database data
UseMasterGoif exists(Select * fromsys.databaseswhereName='Demo') Drop DatabaseDemoCreate DatabaseDemoGo UseDemoGoCreate TableDept (IDint Identity(1,1)Primary Key, DeptIDnvarchar(Ten), Deptnamenvarchar(Ten))GoCreate TableUserInfo (IDint Identity(1,1)Primary Key, UserNamenvarchar(Ten), SalaryDecimal(Ten,2), Genderbit, DeptIDint Foreign Key ReferencesDept (ID))GoInsert intoDeptValues('1001','Personnel'),('1002','Finance Department'),('1003','Development Department')Insert intoUserInfoValues('Xiao Wang', the,0,1),('Xiao Li', -,0,2),('Side Dishes', the,1,3),('Xiao Fang',3500,1,1)GoView Code
And then we're going to write the first and the simplest way, basically without writing the code.
1. Open vs2013, create an empty Web project
2. Create a folder to manage our Crystal Reports
3. Then we right-click the new project to create a crystal report
And then there's the wizard.
Then follow the wizard.
Then click Done and the following page will appear
Now we can click on the main report preview to see the data.
Then we look at the page now!!
And then we can see it in the Web page.
Workaround:
Locate the corresponding files in the directory under the IIS deployment and copy them to the Web application
For convenience I have been uploaded to the Baidu cloud Http://pan.baidu.com/s/1dF3hZkH
Using Crystal Reports in ASP.---Using the wizard