Crystal Reports WHERE clause not recognized in Formula Field.

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: WHERE clause not recognized in Formula Field.
	<< Prev Page of 2

Author	Message
Gnibmilc Newbie Joined: 26 Sep 2011 Online Status: Offline Posts: 8	Posted: 26 Sep 2011 at 10:40am
	Thank you so much for your help I will definitely try this and see if it will work. However, in other situations I would like to be able to use my WHERE statement, do you have any idea why Crystal 2008 is not recognizing it?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 26 Sep 2011 at 10:55am
	the 'where clause' for selecting records is defined by what you put in the select statement. If you go to Database > Show SQL Query, you will the select, join and where parts of the SQL that defines the data in the report.
	IP Logged

Gnibmilc Newbie Joined: 26 Sep 2011 Online Status: Offline Posts: 8	Posted: 26 Sep 2011 at 11:16am
	THANK YOU SO MUCH!!! After 2 weeks of research I have finally gotten my report working!!!
	IP Logged

<< Prev Page of 2

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.