Thursday, May 29, 2014

Crystal Reports : JOINs Refresher

It isn't often that you'll need to worry about this, but it is something all Crystal Reporters should know. You can change the default table JOINs in Crystal to mimic the other JOINs available within the SQL syntax;

Within the Visual Linking Expert (Database | Visual Linking Expert), we can create JOINS between the tables that make up our report.

For those of us that have more complex needs or a more modular (relational) database (i.e. many tables) may need to use different kinds of JOINS. The "default" JOIN type is INNER.

1. Within the Visual Linking Expert, right click on a "link" (right on the line).
2. Select "Options".
3. At the bottom right of the window, you may select a JOIN type. All the expected types are listed (i.e. LEFT OUTER, RIGHT OUTER, etc).

Note: Changing this will impact your expected recordcounts. It is advisable to be familiar with all the JOIN types before modifying. It's always a good idea to write down how many records are being returned before changing the JOIN. That way, you can really see how the JOIN is impacting the report.

2 comments:

storewars news said...

Nice read! Very informative. Did you know that Unilever calls for business 'mindfulness' on consumption. Full story here: http://bit.ly/S62TPI.

sin wak said...

Seek to study approximately you possibly can around the persons you intend to advertise to help. This will help to popunder appearance what exactly you'll claim in addition to the way you'll glimpse. As soon as Apple company company primary started off, many people intended to possibly be just as IBM in addition to Microsoft. Many people needed to double intended for small business apps. We were looking at stunned whenever they afforded surge to help computer building. This company possesses embraced that progress in addition to mastered to help communicate on to the key current market, in particular because of their Imagine Unique cpm advertising plan. Once you know exactly who you intend to talk with, you’ll really know what dialect many people chat. Take advantage of this verbal exchanges model on your brand in addition to video pattern, towards model of publishing on your advertising. Off-road Dew chose many people are the take in intended for alternate in addition to serious activities aficionados. At this time there pop under ads indicate an adolescent, style of manic strength of which resonates because of their center crowd. Some sort of coherent model ought to be viewed by means of people. A great way to accomplish this simply using a offer alternate software.