Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Report Design Post Reply Post New Topic
Author Message
ganesabl
Newbie
Newbie
Avatar

Joined: 09 Nov 2009
Location: United States
Online Status: Offline
Posts: 3
Quote ganesabl Replybullet Topic: Report Design
     Posted: 26 Jan 2010 at 3:07pm
I have a report where i need to add the condition in left outer join

left outer join t1.c1 = t2.c1 and t2.c2 = '100' and t2.c3 = 50

Can someone help me on this.
Please don't say that try to add the query in command, I know that it will work but what i want is how to add this in the design so that the report can be made generic and user will have the capability to modify the where clause.

Thanks in advance

Bala
Bala
IP IP Logged
Jyri
Newbie
Newbie


Joined: 19 Aug 2009
Location: Finland
Online Status: Offline
Posts: 13
Quote Jyri Replybullet Posted: 27 Jan 2010 at 1:54am
Hello,
 
haven't been working with Crystal Reports so much, so maybe I missed the point here totally but isn't this basic Crystal Reports databse table linking and adding some record selections/ or parameters.
 
So you have linked those two databse tables t1 and t2 with left outer join in database expert-->links.
Then you add those two selection criterias to Record Selection Formula Editor t2.c2="100" and t2.c3="50".
Or if you want those criterias to be selectable to your users then make parameters out of both of those(t2.c3 and t2.c2).
 
Again, maybe I missed the point totally cause haven't worked with this program so much.
 
- Jyri
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 27 Jan 2010 at 8:41am
Jyri's comment soulnd correct to me.  Unless I missed something.
IP IP Logged
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