Encerrado

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

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.

Habilidades: Microsoft SQL Server , Oracle, Elaboração de relatórios, SQL

Ver mais: white writing table, universal data entry, true green, sql data entry form, sharepoint box, sharepoint data entry form, shared data services, reporting services sql, project writing help, oracle sql projects, next page writing services, help report writing, form report writing, data entry builder, data driven design, dashboard page design, 123 design, sql report design problem, oracle sql help, oracle sql aging report, oracle sql age date, convert oracle sql script

Acerca do Empregador:
( 7 comentários ) Greenwood Village, United States

ID do Projeto: #10489834

18 freelancers estão ofertando em média $529 para este trabalho

erinkennedy

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 Mais

$526 USD in 10 dias
(102 Comentários)
6.6
marasinghe82

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 yea Mais

$277 USD in 10 dias
(67 Comentários)
5.6
scorpioangry55

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 dias
(10 Comentários)
4.6
$800 USD in 10 dias
(8 Comentários)
4.4
acronymsolutions

Hi , I am 16+ years experienced Database Programmer at CMMI-5 level company. We are working on : RDBMS :Oracle,MySQL,DB2, MSSQL Server 7.0/2000/2008R2 and Onwards. Database Tools : Database Configuration Assist Mais

$1000 USD in 10 dias
(31 Comentários)
5.6
ashupathania

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 diagram Mais

$350 USD in 3 dias
(20 Comentários)
4.0
prashushinde9

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 Mais

$773 USD in 20 dias
(3 Comentários)
4.3
andreyryazanov

Hello! What you actually need instead of building queries and thinking how to join the data - is to use SQL Server Integration Services ETL tool to move the data and SQL Server Analysis Services tabular mode to buil Mais

$750 USD in 3 dias
(1 Comentário)
3.2
abfreelancec

I am very good to design single tablix report. I am ready to do as per your requirement. Please let me know when will we start.

$250 USD in 9 dias
(0 Comentários)
0.0
praveenravi19

A proposal has not yet been provided

$250 USD in 10 dias
(0 Comentários)
0.0
essayshark

A proposal has not yet been provided

$277 USD in 7 dias
(0 Comentários)
0.0
sooraj13

Hello Sir, We are a Indian development company here. we have checked your posted details here and want more clarification in it, so message us to discuss on it more then we will able to move on it. Thanks

$412 USD in 7 dias
(0 Comentários)
0.0
bizdevct

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 capabilitie Mais

$833 USD in 10 dias
(0 Comentários)
0.0
zungh3t

I have experienced about it

$500 USD in 10 dias
(0 Comentários)
0.0
$555 USD in 10 dias
(0 Comentários)
0.0
ajaysinghi1188

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 yo Mais

$277 USD in 2 dias
(0 Comentários)
0.0
marilynbb

A proposal has not yet been provided

$600 USD in 10 dias
(0 Comentários)
0.0
abstractsoftweb

Hello there, Hope you are doing great..!! Going through your project description we understand that you are looking for an experienced team of professional developers and designers to work on your assignment. We Mais

$250 USD in 10 dias
(0 Comentários)
0.0
ca4fil

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 dias
(0 Comentários)
0.0