I have a database which shows students list, with marks and pass %. I want to create a report based on this on another sheet. Whenever I update the source file, I need automatic updation in the destination file
An expert who has achieved level 3 by getting 1000 points
An expert that got 5 achievements.
An expert who has achieved Level 3.
An expert that has over 500 points.
Re: Creating a report
I assume you are using excel? to get the new sheet auto update try this formula =sheet1!C5 into the new cell in new sheet (eg. sheet2)
whenever you update sheet one cell C5 it will automatically appear in new sheet...
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
You can open the Crystal Report (should be installed with Visual Studio first) after you designed your database, then you have to connect the Crystal Report to the right database (the one which you store financial information in your case), then you can create your report easily by putting the desired variables and designs. Then you have to call for that report with a code within visual basic.
you can create static data base in Excel works heet and link each cell to another sheet.
or you can create a dynamic data base in access. you need a MS access book. there are lots link you need to understand in order to have a working data base.