Print Page | Close Window

Report Commands

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9871
Printed Date: 06 May 2024 at 6:04am


Topic: Report Commands
Posted By: achartrand
Subject: Report Commands
Date Posted: 30 Apr 2010 at 5:04am
I have a view that returns a repID (RequestedByRep), what I want to do is create a command that will run and return the rep's Name from the reps table.
 
 
SELECT {tblReps.RepName}
FROM tblReps
WHERE {tblReps.RepNumber} = {tvwr_PurchaseOrder.RequestedByRep}
 
When I run this it says: Error - Description syntax error. What am I doing wrong?


Replies:
Posted By: lockwelle
Date Posted: 30 Apr 2010 at 7:31am
you need to access the view in your from statement...CR sees the where clause but doesn't know what tvwr... is.
 
HTH


Print Page | Close Window