This is my first post here as I'm a new member.  I was wondering if anyone has seen this problem or knows of a solution. 

 

I am modifying an existing ASP.NET application that uses CR for the reporting functions.  I need to add a lookup table to several reports to pull descriptions for various fields like commodity type, buyer name, etc.  I have added the lookup table using the database expert and get the data I expect.  However, the lookup table hase a cytp field that tells me what to look for.  That is 'C' is commodity, 'B' is buyer.  So I thought I could qualify the query using the select expert for ctyp = 'B'  (I only want buyers on the report).  When I run the report I see all lookup table records regardless of the ctyp setting.  The SQL is here:

 

 SELECT "report_work_tbl"."whos", "report_work_tbl"."ebas", "report_work_tbl"."eact", "report_work_tbl"."buyr", "lookup_tbl"."ctyp", "lookup_tbl"."desc"
 FROM   "MCGSourcing"."dbo"."report_work_tbl" "report_work_tbl" INNER JOIN "MCGSourcing"."dbo"."lookup_tbl" "lookup_tbl" ON ("report_work_tbl"."whos"="lookup_tbl"."whos") AND ("report_work_tbl"."buyr"="lookup_tbl"."keyv")
 WHERE  "lookup_tbl"."ctyp"='B'
 ORDER BY "report_work_tbl"."whos", "report_work_tbl"."buyr"

 

Is there any know problem with the Select Expert in .NET?

 

Thanks

Greg in PA

We must all hang together, or assuredly we shall all hang separately.