Devam Ediyor

New version of existing report using SQL Report Builder

I have a report in a PowerBuilder application that needs to be re-done (mainly new grouping of elements). Rather than program it in PB, and since the database is in Microsoft SQL 2008, I'd rather have someone use MS Report Builder to create a new report out of the database using the same elements.

Most of the data is in a single table in the database. The table contains ID values for certain elements that can be linked to a master table for names and descriptions (supplier ID goes to supplier table for supplier name, for example).

The original report lays out individual prices for products based on their source and groups them by product. What I need to see is the cheapest combination of these products based on a stored formula (or "recipe").

For example:

Product 100 and 200 have a recipe of 90:10 (90% 100 to 10% 200).

There are several suppliers of each product, each with their own prices.

I want to see the cheapest blended price and the source suppliers.

So, if the cheapest price for 100 is $[url removed, login to view] from Supplier A, and the cheapest price for 200 is $[url removed, login to view] from Supplier B, I want to see a blended price of $[url removed, login to view] and the two supplier names.

To further complicate matters, each supplier may have more than one supply point (terminal) and there can be serveral transportation companies in the mix. So, it's a fun little matrix.

Beceriler: Microsoft, Rapor Yazma, SQL

Daha fazlasını görün: writing matters, writing groups, version one, values report writing, using re, using writing, writing elements, formula writing report, terminal supply, sql price, sql create table price, report writing companies, product supplier database, needs suppliers, ms companies, formula writing, elements writing, cheapest suppliers, report builder, report example, supplier source, sql microsoft, sql database report, sql based, source supplier

İşveren Hakkında:
( 2 değerlendirme ) Apopka, United States

Proje NO: #731706

Seçilen:

hcy0212

Please check PM.

3 gün içinde 50$ USD
(6 Değerlendirme)
4.1

8 freelancer bu iş için ortalamada 133$ teklif veriyor

XCOREDEV

SQL Reporting expert with over 10 years programing experience

in 5 gün içinde50$ USD
(1 Değerlendirme)
0.0
mabja

Expert in Report builder. Can provide POC in 3 working days. See PMB for details.

in 10 gün içinde100$ USD
(0 Değerlendirme)
0.0
techguys4you

Hi, I am software developer with 5+ years of experience in developing web as well as window based application using C# and VB.NET. Also, we have very good experience in latest technologies cloud computing, SSIS Daha fazlası

in 7 gün içinde250$ USD
(0 Değerlendirme)
0.0
nandankurdekar

I am working in BI/DW from last 4 years

in 7 gün içinde200$ USD
(0 Değerlendirme)
0.0
sasinlondon

I am a .net developer and happy to deliver you the solution

1 gün içinde 180$ USD
(0 Değerlendirme)
0.0
gayatrisd

I am having 4.5 yrs exp in Report desinging,SSIS,Bussiness Inteligence,Crytal Reports,ASP.NET,C#,SQLSERVER.Pls send the prototype and requirement docs to start the work.

in 5 gün içinde99$ USD
(0 Değerlendirme)
0.0
tanvir432

Dear sir, I am very much interested about this project all of your terms and conditions. If you will give me a chance, I am confident to perfect delivery of this project. Thank You.

in 4 gün içinde131$ USD
(0 Değerlendirme)
0.0