Hello i got this custom report
Am receptionat marfa de la
[!Nota intrare marfa:1,1,1,1,1,1,1,1,1]
>Denumire Prod.|U/M|ID|[N]Cantitate|[C]Pret fara T.V.A.|[C]T.V.A.|[C]Pret cu T.V.A.|[C]Pret Total cu T.V.A.|[N]T.V.A. (%)
@@inv
and here is my sql
SELECT
/*
MIN(CONVERT(nvarchar,InventoryTransactions.Date,105)) AS DATE,
*/
InventoryItems.Name,
InventoryTransactions.Unit,
InventoryTransactions.InventoryTransactionDocumentId,
convert(decimal(5,0),round(InventoryTransactions.Quantity,0)),
convert(decimal(5,3),round((InventoryTransactions.TotalPrice)/(InventoryTransactions.Quantity),3)) as PretUnitar,
convert(decimal(5,4),round(((InventoryTransactions.TotalPrice)/(InventoryTransactions.Quantity)*InventoryItems.DefaultBaseUnitCost),4)) as TVA,
convert(decimal(5,4),round(((InventoryTransactions.TotalPrice)/(InventoryTransactions.Quantity))+((InventoryTransactions.TotalPrice)/(InventoryTransactions.Quantity)*InventoryItems.DefaultBaseUnitCost),4)) as PretTVA,
convert(decimal(20,2),round(((InventoryTransactions.TotalPrice)+(InventoryTransactions.TotalPrice*InventoryItems.DefaultBaseUnitCost)),3)) as Total,
convert(decimal(5,0),round(InventoryItems.DefaultBaseUnitCost*100,0)) as tviw
FROM InventoryItems
INNER JOIN InventoryTransactions
ON InventoryItems.Id=InventoryTransactions.InventoryItem_Id
WHERE InventoryTransactions.Date > '{Start}' AND InventoryTransactions.Date < '{End}'
/*
'%' + convert(decimal(5,2),round(InventoryItems.DefaultBaseUnitCost*100,2)) as tviw
GROUP BY InventoryItems.Name,InventoryTransactions.Unit,InventoryTransactions.Quantity,InventoryTransactions.TotalPrice
*/
ORDER BY InventoryTransactions.Date
and here is my problem: when selecting date 24-09-2015 to 08-10-2015 the reports works corectly and its displaying me the info that i need
and when i select date between 21-09-2015 to any other date that is grader than 21 it is displaying me this error message
What should be the problem that is causing this ? Please help me