Print Page | Close Window

error in viewing report

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13697
Printed Date: 18 May 2024 at 12:43am


Topic: error in viewing report
Posted By: fanan
Subject: error in viewing report
Date Posted: 08 Jul 2011 at 5:33pm
hi there
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


Print Page | Close Window