Skip to main content
Rajendra Dewani

Project : Crystal Reports optimising the LTA management report

Written by Rajendra Dewani
Leave a Comment

The project was to optimizing the LTA management report. The scope of this project is to try to use stored procedures and/or views in order to make it quicker and to suggest/implement a different and faster layout for some sub reports.

The report prior to optimization took around 3-4 hours to display records when in after optimization it takes only 10-15 minutes ( on first run) and then approx 5 minutes and the optimized report also is exportable to excel without losing the formatting.

Features

  • Report using Stored procedure
  • Conditional formatting
  • Sub reports

Technologies

  • MS SQL 2005
  • Crystal Reports 10

Client Comments

Rajendra is an excellent coder. He submitted his work always on time. He is a A class “Crystal Reports” magician. He made the impossible to be possible. And we are greatful.

Projects, Reporting,

Project : Crystal Reports Creation

Written by Rajendra Dewani
Leave a Comment

The project was to design and develop three crystal report for a Small company working for Major Telecom EOM provider.

MS SQL 2005 Database, is linked to our Crystal Reports Enterprise environment.

The database was huge in size thus the report to be designed should take care about it and should show result as fast as possible.

Features

  • Report using tables
  • Conditional formatting
  • Sub reports

Technologies

  • MS SQL 2005
  • Crystal Reports 10

Client Comments

Rajandra, was easy to work with, had an professional approach, was quick to understand. Certainly someone to recommend.

Projects, Reporting

Project : Planned Maintenance Management System(PMMS)

Written by Rajendra Dewani
Leave a Comment

This project was to develop a material manager and Planned Maintenance Management System(PMMS) program with administrative privilages

Features

  • Manage Masters (Equipment,Department, Item, Supplier, Company)
  • Purchase Order
  • GRN/MRN Good Receipt Note
  • Stock inward /Outward
  • Auto Workorder generation
  • Workorder managament and tracking
  • Replace part list
  • 14 Reports

Technologies

  • Visual Basic 6
  • MS Access 2000
  • Crystal Reports 8.5

Client Comments

Rajendra is a very interactive coder who go all the way to ensure that the person at the other end gets value for his/her money at any point in time.i recommend him to anyone in need of a coder.

Desktop Application, Projects, Reporting, ,

Project : Reports For Property Management System Enhancements

Written by Rajendra Dewani
Leave a Comment

The Project was to create 4 Crystal report and attach it to the existing application.

Reports

  • Contacts by Project
  • Contacts by Listing Interest
  • Interested by Contacts
  • Internal listing sheet GoldMine (showing property information attached to contact)

Technologies

  • Visual Basic 6
  • Crystal Reports 8.5

Client Comments

Excellent work, as always!

Desktop Application, Projects, Reporting,

Project : TIME KEEPING

Written by Rajendra Dewani
Leave a Comment

The project was to develop an application to record time sheet of the employees for multiple firm/company. Application can manage number of companies and employees working in company. Application can record the time sheet along with the project/task.

Features

  • Manage multiple companies
  • Manage employee information under companies.
  • Manage time sheet
  • Time sheet approval
  • Duplication/Overlapping/Grap detection in time sheet
  • Export reports in multiple format like PDF, XLS, CSV, HTML
  • Manage Project and Task for each companies.
  • Track time sheet against the project and task
  • Print Detail/Summary of the time sheet entered for Company and or employee

Technologies

  • Visual Basic 6
  • MS Access 2000
  • Crystal Reports 8.5

Client Comments

HE IS ONE OF THE BEST CODER I HAVE WORKED WITH IN MY 45 YEARS EMPLOYING CODERS. USE HIM AND YOU WILL BE PLEASED.

Desktop Application, Projects, ,

Project : TAX DATA ENTRY SYSTEM

Written by Rajendra Dewani
Leave a Comment

The project was to develop an application which records/manages information of the customer who has opted for the service with the client to file tax information on their behalf. The application manages, the customer has opted and keeps a track of the forms submitted to the government.

Project_Maintenance Programmer_TAX DATA ENTRY SYSTEM

Project_Maintenance Programmer_TAX DATA ENTRY SYSTEM

Features

  • Manage customer information
  • Manage customer tax forms information.
  • Keep tracking of tax forms submitted

Technologies

  • Visual Basic 6
  • MS Access 2000

Client Comments

THANKS FOR THE CONTINUING WORK. YOU DO VERY WELL.

Desktop Application, Projects, ,

Project : MDB TO TAX FORM AND EFILE

Written by Rajendra Dewani
Leave a Comment

The project was to develop an application with takes MS Access and in Input and will export the information to Text/CSV for Tax form and Efiling Purpose

Features

  • Generate output in Text or CSV in SSVN Format/Efiling Format
  • Logs all the error in a log file
  • Shows record to be exported to be exported.

Technologies

  • Visual Basic 6
  • MS Access 2000

Client Comments

THANK FOR CONTINUED GREAT WORK. I HAVE NEVER WORKED WITH A BETTER CODER AND IN 30 YEARS IN THE INDUSTRY, ONLY 2 HAVE EQUALLED YOU.

Desktop Application, Projects, ,

Project : Finish/Re-write incomplete Order processing

Written by Rajendra Dewani
1 Comment

The project was to develop order processing system from flower trading company.

The list of customer and products are to be fetched from the Accounting system “Sage” using read-only ODBC. The application has to take care of the Adding stock in Single or bluk & deduct the batch/lot wise stock on sales

Application also needs to print Picking report, Shipping Note, Sales Invoice, Stock batch report. These reports needs to exportable in CSV file with one row per Sales invoice for import into Accounting program.

Project_Finish_Re-write incomplete Order processing

Project_Finish_Re-write incomplete Order processing

Features

  • Easy to configure Sage Connection.
  • Manages Vat Taxation per invoice
  • Able to add stock in singles or bluk
  • Export reports in PDF, Excel, Text, CVS, HTML
  • Searching invoice by date,customer & product

Technologies

  • Visual Basic 6
  • MS Access 2000
  • Crystal Reports 8.5

Client Comments

Good skills and communication. Thank you.

BugFix, Database, Desktop Application, Projects, ,

Project : Testing and Bug Fixes for Customer and Supplier Modules

Written by Rajendra Dewani
Leave a Comment

This project was to Test and Bug Fixes for Customer and Supplier Modules.

The Application was almost complete, i need to do functional & usability test. Report all the bug & steps to reproduce in Excel sheet & on approval i need to fix it

Features

  • Customer Module
  • Pending Sales Orders
  • All Sales Orders
  • Confirmed Sales Orders
  • Supplier Module
  • Pending Purchase Orders
  • All Purchase Orders
  • Confirmed Purchase Orders.

Along with the testing I also need to develop two screens

Development

  • Database Connection Manager
  • Report Viewer (Crystal reports).
  • Reports
    • Customer List
    • Customer Summary
    • Supplier List
    • Supplier Summary
    • List PO Placed To Supplier
    • List SO Placed To Customer
    • Pending PO Placed To Supplier
    • Pending SO Placed To Customer

I need Testing done and Excel File with the errors sent to client

Technologies

  • Visual Basic 6
  • MS SQL 2000 / MSDE
  • Crystal Reports 8.5

Client Comments

Completed the work as required. Very Good knowledge and Very Good Skills.

BugFix, Desktop Application, Projects, Testing, ,

Project : Billing Software

Written by Rajendra Dewani
5 Comments

The project was to develop an application which can be used for generate invoices and to manage list of customer, products & taxation.

Project_BillingSoftware

Project_BillingSoftware

Features

  • Manage customer information
  • Manage product information
  • Manage company information along with rate of taxation
  • Manage Invoicing
  • Export Invoice to different format like PDF, Excel, Text,HTML
  • Option to print on pre-printed invoice or standard invoice format
  • Monthly/day wise report for invoice, tax ( Detail/Summary)
  • Backup Database
  • Restore Database

Technologies

  • Visual Basic 6
  • MS Access 2000
  • Crystal Report 8.5
Desktop Application, Projects, Reporting, ,