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 $1.00 from Supplier A, and the cheapest price for 200 is $2.00 from Supplier B, I want to see a blended price of $1.10 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: writing matters, writing groups, writing elements, version one, values of report writing, using re, using in writing, the writing elements, the formula for writing a report, terminal supply, sql price, sql create table price, report writing companies, product supplier database, needs of a suppliers, ms companies, formula writing, elements of writing, d&b supply, c# report, cheapest suppliers, report builder, what is ms sql, report example, supplier source

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

Proje NO: #731706



Please check PM.

%selectedBids___i_period_sub_7% gün içinde 50%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(6 Değerlendirme)

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


SQL Reporting expert with over 10 years programing experience

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

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

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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 Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I am working in BI/DW from last 4 years

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde99%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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 %bids___i_period_sub_35% gün içinde131%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)