Crystal Reports Sub Queries

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

Topic: Sub Queries

Author	Message
vijayk Groupie Joined: 14 Mar 2007 Location: United States Online Status: Offline Posts: 53	Topic: Sub Queries Posted: 29 Mar 2007 at 1:01pm
	I am expereinced BzO user & new to crytsal. How can we create sub queries in Crystal..? Thanks Vijay
	IP Logged

dhakshu Newbie Joined: 01 Mar 2007 Location: Singapore Online Status: Offline Posts: 21	Posted: 30 Mar 2007 at 1:01am
	Hi Vijay! Create a view to include sub queries and attach it to crystal report using database expert. to create a view use: CREATE VIEW view_name AS SELECT ..(your select statment) Hope this helps! Regards, Dhakshesh
	Dhakshu
	IP Logged

vijayk Groupie Joined: 14 Mar 2007 Location: United States Online Status: Offline Posts: 53	Posted: 07 Apr 2007 at 10:46pm
	Thanks..! I have another question..Can we reference parameter fields in SQL expression..? Thanks Vijay
	IP Logged

dhakshu Newbie Joined: 01 Mar 2007 Location: Singapore Online Status: Offline Posts: 21	Posted: 08 Apr 2007 at 6:34pm
	Hi! You can use parameters in sql expression like this --> select * from tablename where columnname= '{?param}' Here param is the parameter Enclose the parameter within quotes if it is a string Regards, Dhakshesh Edited by dhakshu - 08 Apr 2007 at 6:48pm
	Dhakshu
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 09 Apr 2007 at 10:56am
	If you can't get a view created on your database, you might also be able to use the CommandText feature to set the SQL for your report. It's not available for all databases. To find out if you can use it, connect to your database in Crystal. If you have 'Add Command' under the database name, you can use CommandText. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	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.015 seconds.