Recent content by HoosHot

hi all, i wanted to thank everyone for their help. unfortunately, no matter how many times i tried, your suggested null logic does not bring back the desired number of rows. i ended up creating a view (with the outer join logic) and including that view in the crw to make it work. thanks...

ok, how about this? create table z_employee (name varchar2(10)) create table z_employee_skill (name varchar2(10) , skill varchar2(10)) insert into z_employee values ('jane') insert into z_employee values ('joe') insert into z_employee_skill values ('jane', 'programmer') insert into...

i tried pandpp's (TABLE2."COL3" = abc OR TABLE2."COL3" IS NULL) and synapsevampire's isnull({TABLE2.COL3}) or {TABLE2.COL3} = "abc" and the generated sql (from database / show sql query)is: (TABLE2."COL3" IS NULL OR TABLE2."COL3" = abc OR )...

correction: outer join result: table1.col1 table1.col2 table2.col1 table2.col2 table2.col3 a b a b abc e f <null> <null> <null> your suggestion result: table1.col1 table1.col2 table2.col1 table2.col2 table2.col3 a...

actually, if i'm not mistaken (and i ran this in sql to test it out), an outer join: TABLE2.&quot;COL3&quot;(+) = abc is not equivalent to: (TABLE2.&quot;COL3&quot; = abc OR TABLE2.&quot;COL3&quot; IS NULL) an outer join says give me back results even if no rows exist in table2. with your...

current sql: SELECT TABLE1.&quot;COL1&quot;, TABLE1.&quot;COL2&quot;, TABLE2.&quot;COL1&quot;, TABLE2.&quot;COL2&quot;, TABLE2.&quot;COL3&quot; FROM &quot;OWNER&quot;.&quot;TABLE1&quot; TABLE1, &quot;OWNER&quot;.&quot;TABLE2&quot; TABLE2 WHERE TABLE1.&quot;COL1&quot; =...

hi, in Database/Visual Link Expert, i do have table1 and table2 as left outer join. that's how i'm already able to get: WHERE TABLE1.&quot;COL1&quot; = TABLE2.&quot;COL1&quot;(+) AND TABLE1.&quot;COL2&quot; = TABLE2.&quot;COL2&quot;(+) notice, now, i'm doing the record select expert...

product 8.0.1.0 crw32 8.0.0.441

hi, i have an outer join in my report. for example: WHERE TABLE1.&quot;COL1&quot; = TABLE2.&quot;COL1&quot;(+) AND TABLE1.&quot;COL2&quot; = TABLE2.&quot;COL2&quot;(+) and, i'm using the select expert to add these to my where clause: {TABLE2.COL3} = abc however, when doing an...

there is not a maximum number of possible tiers (hence, the vertical table as opposed to a horizontal table). database is oracle 8i so yes, it supports stored procedures. i've never used stored procedures as the basis of my crystal reports - i've only used simple table joins and selects. thanks.

Hi, I have 3 tables: Trans_tbl xid data1 data2 1 abc def 1 ghi klm 2 nop qrs Amount_tbl xid amt1 amt2 1 10 20 2 30 40 Summary_tbl xid tier mins fee 1 1 14 1 1 2 15 7 1 3 12 9 2 1 9 4 2 2 7 3 Prior to adding Summary_tbl to my report, I...

Thanks, Naith. I had to change around the logic just a tiny bit. This works: Parent = Child And DistinctCount({Child},{Parent}) = 1 You are my hero! Thanks a bunch :-)

Hi, Naith, I see what you are trying to do. However, it does not work because I have many rows of each parent/child. Let me show you more data so it's more representative of my real data. parent child amount ------ ----- ------ 10 10 1 10 10 2 10 10 3 20 20 1 20...

Hi, By parent/child, I mean something hierachical like account and sub-account. I have data like the following. When parent and child are the same and you don't see any other rows, it means this parent basically does not have children. Parent and child are key/id columns. Amount is just a...

i'm using powerdesinger 7.5. i'm generating ddl for mysql 3.22. under the &quot;generate database&quot; option, in the &quot;keys & indexes&quot; tab, i have &quot;create foreign key&quot; option checked. it doesn't seem to generate any foreign key ddl for me. when i change the database to...