Find Jobs
Hire Freelancers

Help design an SSRS report aggregating from 2 Oracle and 1 SQL datasource

$250-750 USD

Closed
Posted almost 8 years ago

$250-750 USD

Paid on delivery
We have a SQL Server Reporting Services report built with SQL Server Report Builder, pulling information in from four data sources - an Oracle financial database (3-5 fields), an Oracle projects database (8 or 9 fields), a SharePoint list driven by a SharePoint entry form, and a SQL Server-based Project Server database. The SQL Server (Project Server) database contains a Projects table and a Tasks table (connected by a Project ID). We need to match a Project Server project ID to a universal project ID contained in the Projects table. Then query all tasks matching that Project Server project ID, filtering for just those tasks that are flagged to be included in the report and have been scheduled for completion in the past or the next thirty days. These tasks will then be displayed in a single tablix on the report. The SQL Server (Project Server) projects database also contains five fields driving the color formatting of a five boxes (denoting five phases of a project). If a phase field reads 100% (Complete), a box (denoting that phase) on the report will render green. If it reads 0% (Not Started), the box stays white. If it reads between 0 and 100%, the box renders a light green. The Oracle projects database will drive three single expression fields on the report, with the five remaining fields each driving the color formatting of a single box. If a field is flagged true, a box will render blue. If false, the box stays white. Three or four single expression fields are populated from the Oracle financial database. All data sources report on a single-page, fairly simple, SSRS dashboard. The SQL queries for the two Oracle databases have pretty-much been written. The queries for the MS SQL (Project Server) database still need to be written. And the conditionally-formatted colored boxes need to be designed for the report. The work takes place behind a firewall, so we'll need to do that through a shared screen. There may be a couple of other things, as well. Thanks.
Project ID: 10489834

About the project

16 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average $532 USD for this job
User Avatar
Hi, I would like to use my experience to serve you better. You can trust my sincere indulgence both in quality and time frame. If you will give me a chance, I will ensure that you're satisfied. I'm really interested in the project since it's my area of expertise. I'm sure we can work together. I have read and understood the project guideline. Please check my completed projects & samples at: https://www.freelancer.com/u/erinkennedy.html. Thanks
$526 USD in 10 days
4.7 (144 reviews)
6.9
6.9
User Avatar
Dear Sir, Thanks for the interesting project . I have all the required skills as you required SSRS,SharePoint,Oracle,MS SQL and I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last nine years I involved many project in ETL, data warehousing, BI reporting and six years of application development experience. I would highly appreciate if you assign this job to me and also I'm Microsoft Certified Technology Specialist (MCTS) for Microsoft SQL Server 2008 for Business Intelligence Development and Maintenance & Microsoft Office SharePoint Server Application Development. Please reply me for further details Best Regards, Jinesh
$277 USD in 10 days
4.9 (73 reviews)
5.7
5.7
User Avatar
I have 5 + years of experience in MSBI Technology (SQL Server 2008/2012, SSIS, SSRS, and SSAS) Worked with the reputed clients like Microsoft, HCL, and Dicks Sporting Goods etc. Worked on various types of ER diagrams, Data flow Diagrams, Relational Models Etc. Expert in creating Sql queries ,Dynamic T-sql,functions,triggers,indexes,Procedures,cte,temp tables and sub queries . Expert in creating SSIS package, configuration, Deployment and Scheduling and extracting the data from different sources like SharePoint lists, excel files, csv files, Data feed store, MySQL database, sql databases etc. Expert in creating different ssrs reports like drill through, drill down, parameterized, table, matrix,Chart,Line,Stacked columns, Map ,Document type etc. SSRS reports integration with SharePoint and windows applications. Fetching the data from multidimensional cube, tabular cubes with the help of MDX queries and creating SSRS reports. Expert in handling the huge databases (in TB) and performance optimization of the legacy codes. I can assure you that if you work with me once, you will always work with me for these kind of projects.
$350 USD in 3 days
4.8 (30 reviews)
5.1
5.1
User Avatar
You can contact with me at any moment to discuss your task. You can contact with me at any moment to discuss your task.
$750 USD in 10 days
4.9 (10 reviews)
4.5
4.5
User Avatar
Hello, I understood the initial scope of this project. Although i want to discuss further this job in order to prepare the final concept for this project. After Complete discussion over the call or in chat, i will prepare following things for you - Technical Project Proposal - Flow chart for this Project - Execution plan (Step by step procedure with explanation how and at what that we are going to execute a particular task)
$773 USD in 20 days
4.4 (3 reviews)
4.2
4.2
User Avatar
A proposal has not yet been provided
$600 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have been doing SSRS work from last 5 years. I am very very experienced when it comes to SQL, Oracle and SSRS. Please give me a chance to work with you on this project. I guarantee you I won't disappoint you. Thanks, Ajay +91-8826155288
$277 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I have extensive experience designing ssrs reports. And I am available immediately to work on this project. Please lets chat to discuss further. Thanks.
$500 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have experienced about it
$500 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am sorry if i am bidding it for a little bit high, but we can do this. We have the capability of developing SSRS reports and using them in our applications. If you initiate a discussion can share our capabilities and other important information regarding the project delivery. Thanks & Regards BizDevCt
$833 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$277 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$250 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Pueblo, United States
5.0
7
Member since Feb 12, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.