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").
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.
8 freelancers are bidding on average $133 for this job
I am having 4.5 yrs exp in Report desinging,SSIS,Bussiness Inteligence,Crytal Reports,ASP.NET,C#,[url removed, login to view] send the prototype and requirement docs to start the work.
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.