i make an inventory app
it has transfering products between stores
when i make a report on transfers this is the select statement of the report
in main report viewer without debugging it run when i run the program it raise an error "unable to find the report in the manifest resources please build the project and try again" of course i rebuild it many times and try to change the select statement but the same
SELECT
distinct Products.ProName, ProductTransfer.ProductQuantity,
(SELECT StoreName
FROM Stores
WHERE (StoreID = ProductTransfer.FromStoreID)) AS [ ],
(SELECT StoreName
FROM Stores
WHERE (StoreID = ProductTransfer.ToStoreID)) AS [ ], ProductTransfer.TransferDate, Users.UserName
FROM
ProductTransfer INNER JOIN
Products
ON ProductTransfer.ProID = Products.ProID INNER JOIN
Users
ON ProductTransfer.UserID = Users.UserID