Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Question about Data selection

Status
Not open for further replies.

toshii1222

Programmer
Aug 2, 2001
13
US
Hi,

I have 2 tables.

Table 1:

ID ITEM
1 a
2 b
3 c
4 d
5 e

Table 2:

ID QTY
2 1
5 5

How can I show the IDs that don't appear in the Table 2 by using Crystal Report? Is it possible to be done?
 
Try a left join from {table1.ID} to {table2.ID} and then place {table1.ID} in the details section, and for your record select statement use:

isnull({table2.ID})

-LB
 
I have a report that I have a date selection parameter field embedded in the report. It comes up at run time and asks for the parameters but it doesn't change the report unless you use the selection expert. My users are printing this from a menu in mas90 and they can't get to the selection expert. Why doesn't the parameter field alone work?

 
It works.. never thought I could use left join. Thanks a lot :)
 
Kayla,

What does your selection criteria for this field look like?

Is the parameter specific or range? Is it set up with default values? Or a pick list (calendar)? If there are exact values (which come from previous entries), and the report is trying to find a specific date- the date it is looking for might not be valid in the current return values.

What version MAS90 are you on? (We have SQL 3.71).

Sunny
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top