506L_Reporting_Tools_Using_Windows_Programing

 Reporting Tools Using Windows Programming 

  Video Tutorial - 1

Assignment-1

1. What is Crystal Report? What are the basic properties and methods for the Crystal Report? Explain Various Section of Crystal Report.

2. Create CR that display the BUS – PASS for SRK INSTITUE. Make suitable table for the same in Access.

3. Create CR that display the salary slip for the employee of SRK INSTITUTE.

4. Make suitable table for the same in Access.

5. Create CR with the table Employee

(Emp_id,Emp_Name,Emp_Department,Emp_city)

a. Display only those records where city name starts from A.

b. Display only those records where city name contains A.

c. Display only those records where Emp_Deapartment is I.T.

6. Create seprate crystal report for each step.

7. Create CR with the table Student

(Id, Name, Sub1, Sub2, Sub3)

·        Connect database with Visual Studio.

·        Create Report of the table.

·        Insert logo.

·        Also include date and page number at proper place.

·        Calculate Total and percentage of the given marks of subjects.

·        Print the grade according to the percentage ( A: per >= 80 , B: 60 to 80, C:40 to 60, Fail : below 40)

·        Create summary as follows.

·        Display the maximum percentage.

·        Display the total number of students passed in each grade.

·        Display the average percentage.

8. Create CR with the table Employee

9. (Id, Name, Address, Salary, Date of Joining, Age, Contact no,     Dept_Id)

·        Connect database with Visual Studio.

·        Create Report of the table.

·        Insert logo.

·        Also include date and page number at proper place.

·        Calculate tax if salary is greater than 10000 Rs (Tax = 2% of salary) and also find net Salary.

·        Print the name of Department according to dept_id (10 = Finance , 20= Sales, 30= Marketing)

·        Create summary as follows.

·        Display the minimum and maximum salary.

·        Display the most senior and junior employee.

·        Display the youngest person.

10.        Create CR with the table Product

11.        (Id,Name,Unit)

·        Connect database with Visual Studio.

·        Create Report of the table.

·        Insert logo.

·        Also include date and page number at proper place.

·        Calculate Bill according to following condition.

·        The charge of  first 100 units is 2.50 Rs. , for next 200 units charge is  3 Rs. And charge of above 300 units is 5 Rs.

·        Calculate Meter Charge 200 Rs.

·        Calculate tax if bill is greater than 800 Rs. (Tax = 3% of bill)

·        Display final bill amount

·        Create summary as follows.

·        Display the maximum and minimum bill amount.

·        Display the total number of customer.

·        Display the average bill amount.

12.        Create CR that display the data from the table using SQL Query.

13.        Create CR that display the data from the multiple table.

14.        Create CR that display the data Using Database Expert.

15.        Create CR that display the data from the multiple databases.

                                   Reporting Tools Using Windows Programming  

                                                    Ass-2

1). Create CR that displays the id, name, department, and salary.

·         Use the parameter in the CR for the field department.

·         Insert logo for company

·         Display date on the report header and page number in the report footer

·         Display the record in blue if the salary is less than 20000

·         Display only name which starts from B

·         Display only name which first character is A and last character is H.

2). Create CR that displays the student details like id, name, semester, address, phone no, result

·         Use parameter in the CR for field semester.

·         Insert logo for SRK

·         Display the details for group by id.

·         Display the records in red if the marks are less than 40.

·         Display records from another table that is fees_details (id , Fees_Amount) for each id display the amount of fees.

·         Use the appropriate predefined fields for the report.

·         Display records in ascending order of the marks.

3).Create CR with the table Employee

(Emp_id,Emp_Name,Emp_Department,Emp_city)

§  Display only those records where city name starts from A.

§  Display only those records where Emp_Name contains A.

§  Display only those records where Emp_Deapartment is I.T.

§  Use SQL Statement for all above.

4). Create CR with table Student

                               

§  Display students whose marks are more than 40 marks in Blue marks.

§  Calculate the summary information from result display maximum marks from students list also calculate the number of students who are failed in the examination.

§  Display the records where class is TYBCA

§  Create Parameter for the field for the subject

5). Create CR with table Staff

                               

·         Display the fields using Database Expert.

·         Display the records group by Manger, Supervisor.

·         Use Proper Special Fields in the Crystal Report.

·         Display the records in the ascending order of salary.

·         Create Parameter for the field for the field Designation

                                               

6). Create CR with table Teachers with the fields (ID (p.k.), Name of faculty, Subject, Experience)

                                                Create another table subject with fields (Sr.No, subject, Class, ID(f.k.))

               

§  Save 10 teachers detail in the table Teacher

§  Save the details of the subject in the subject table

§  Display the timetable for the class TYBCA  along with subject code and Faculty Name