[Requirement]
I have some task folders in my hand that contain CSV files (or TXT files ). They contain data files and detailed data files for PK trends between two products.
Let's assume the two products are B1 and B2 (Gib)
They are separated by standard tabs. Require automatic/manual import to the database.Support for update records
Build a reporting service to generate a trend chart, a barchart, and a detailed table for users to access.
The relationship between several charts is: Show trend chart, which has a node flag. Based on the current tag, you can drill down to the corresponding barchart. barchart also provides a link. The detailed data table is displayed.
The result is probably as follows:
[Simple Analysis]
Based on the above requirements, we need:
1. Install SQL Server and build a Reporting Service.
2. Create a database and a data table.
3. Import the file to the database.
4. Create a report project.
5. Configure the Reporting Service.
[Design]
Based on the above analysis, I will describe my simple design:
1. Omitted
2. Use entityframework code first to create a database and a data table.
3. Create a CommandLine program to receive the file directory
4. Use entityframework/SQL bulking to import/update data (considering transactions and efficiency)
5. use vs 2008 to create a report project (I use SQL 2008 R2) and vs2008 (I can find the control of reporting reviewer in 2010, but there is no report project, maybe I can have corresponding development tools after installing sql2012. The principle is the same)
6. Configure the Reporting Service.
[Development tools required]
Vs2010, vs2008, sqlserver 2008 r2
In the following article, I will develop this project with you step by step.