Crystal Reports use sql query in 8.5

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: use sql query in 8.5

Author	Message
mjawadkhatri Newbie Joined: 09 Sep 2009 Location: Pakistan Online Status: Offline Posts: 14	Topic: use sql query in 8.5 Posted: 04 Jan 2010 at 1:26am
	how to use SQL query in crystal report??
	IP Logged


AdamField Groupie Joined: 04 Jun 2009 Online Status: Offline Posts: 88	Posted: 04 Jan 2010 at 6:07am
	Hey, In the field explorer on the right side you can select SQL-expressiefield in the XI R2 don't know if that is availeble in the 8.5 :(
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 04 Jan 2010 at 6:55am
	On the Database menu in 8.5, there is an option to view the query (I don't remember exactly what it's called...) In there you can edit the query, including, I believe, entering the entire SQL that you need. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 04 Jan 2010 at 11:23am
	You can do limited editing in the 'Show SQL Query'. I just tried entering my own SQL query and it defaulted back to what it had before.
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 04 Jan 2010 at 11:55am
	What happens, though, if you have no tables selected and you enter a query? I'm not sure if the QueryBuilder tool was available in 8.5, but you may have to use that instead. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 04 Jan 2010 at 1:10pm
	It will not let you enter a query if you have no fields on the report.
	IP Logged

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