Crystal Reports How to compar data from table to table

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

Topic: How to compar data from table to table

Author	Message
snowens Newbie Joined: 28 Jul 2008 Location: United States Online Status: Offline Posts: 2	Topic: How to compar data from table to table Posted: 28 Jul 2008 at 3:05pm
	I'm new to CR, i'm using XI, I want to compar table A to table B. I want to know what records are in table A but are not in table B. Table examples are either string or numeric data types. Any help is appreaciated.
	CR Newbi
	IP Logged

rahulwalawalkar Senior Member Joined: 08 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 731	Posted: 29 Jul 2008 at 5:38am
	Hi, Check this Link.. http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx Cheers Rahul
	IP Logged

snowens Newbie Joined: 28 Jul 2008 Location: United States Online Status: Offline Posts: 2	Posted: 29 Jul 2008 at 7:22am
	I am not using a SQL table, I am using an old IBM Universe flat database, do you think the SQL command will work in Crystal Reports? snowens
	CR Newbi
	IP Logged

rahulwalawalkar Senior Member Joined: 08 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 731	Posted: 29 Jul 2008 at 7:40am
	Yes Sql Command will work ,need to create command object,may be require some tweaking for sql on what database type you are using. I am not aware of old IBM Universe flat database so can't comment more on that. Cheers Rahul
	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.020 seconds.