Talk with the Author
 Crystal Reports Forum : General Information : Talk with the Author
Message Icon Topic: error in viewing report Post Reply Post New Topic
Author Message
fanan
Newbie
Newbie
Avatar

Joined: 02 Jan 2011
Location: Egypt
Online Status: Offline
Posts: 28
Quote fanan Replybullet Topic: error in viewing report
    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

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.