Not a problem at all. It didn't work, but I'm taking a break and going to look at the SQL Reporting side of it for a bit. It has me confused and I need a break!
Thanks for your time!
Paeter most of my issue wasn't coding at all. My database contains both consumed and produced product. I only wanted to add consumed and ignore the produced.
Armed with that information I kicked it's ass and now have it adding what I want.
Appreciate you taking the time to whisper sweet nothings in my ear!
What do you suggest the best way to put this data in to a database so I can use it to compare against another database?
I will need to check for type of wood and thickness and then pull that value to multiply by.
CREATE TABLE wood_costs ( species VARCHAR(30) NOT NULL , thickness TINYINT NOT NULL , cost SMALLINT DEFAULT NULL ); INSERT INTO wood_costs ('Red Oak',3,85); INSERT INTO wood_costs ('Red Oak',4,85); ... INSERT INTO wood_costs ('Hard Maple',7,135); ... INSERT INTO wood_costs ('Other Hardwood',16,285);
<?xml version="1.0" encoding="utf-8"?> <Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition"> <AutoRefresh>0</AutoRefresh> <DataSources> <DataSource Name="KilnData"> <DataSourceReference>KilnData</DataSourceReference> <rd:SecurityType>None</rd:SecurityType> <rd:DataSourceID>0915e801-0c00-4013-a86a-3762972008de</rd:DataSourceID> </DataSource>