Report Consolidation Using SSRS Solution

Leading Oil supply & distribution improves order tracking using a single reporting platform

Client has creatively solving energy procurement, supply, and logistics challenges across U.S. and Canada.
Oil Retailing and Distribution

The Client

The Client is a market leader in petroleum marketing & fuel supply. It started in 1957 and has consistently grown over the past 59 years. The Client provides fuel and energy to 27,000 locations for over 3700 commercial customers, 440 school districts, 770 counties, and 590 cities across the United States and Canada.

The Challenge

  • To develop a single Reporting Portal to see all kind of Orders.
  • To migrate all legacy Crystal reports.
  • Develop new reports.

The Solution

JKT provided a SSRS Solution.

  • SSRS Solution to migrate their Legacy Crystal Report and create new SSRS Report and Dashboards.
  • Implement ANA and DLP Logic in our Reporting Solution.
  • SSRS Solution to create different types of reports that includes drill down, drill through and sub reports.
  • SSRS solution to create charts for visualization.
  • SSRS standard and data driven subscriptions to automatically run reports for users.

The Benefits

  • Now Our Client Use Report Portal to access all kind of report to show DEF, LTL and FTL data.
  • SSRS Reports will use ANA Module to handle Report Permission.
  • SSRS Reports will use Data Level Permission.
  • SSRS Charts visualize the data and helps in making Decisions.
  • Through SSRS subscriptions, reports are published on share point site and refreshed based on specific schedule.
  • Through SSRS subscriptions, reports are sent via email to users at specific schedule.
  • Easier Integration to the web.