sql server - Crystal Reports does not put linked view into FROM clause causing "The multi-part identifier xxx could not be bound" -

i've stuck crystal reports 2008 (12.0.0.683) project.

i have added 1 more view in database expert existing (working) report. it's (the view) linked main table. it's linked left outer join (not enforced, =).

on runtime sends query sql server column additional view put select clause view name not put clause. causes "the multi-part identifier xxx not bound" error. understend error cannot force cr use view in clause. not think there special view (more views linked in report).

did face similar problem? please give tips. in advance!

ps. query goes sql server (seen sql profiler) like:

select   newview.col1,   newview.col2,   maintable.col1,   maintable.col2,   subtable.col1,   subtable.col2 -- no [newview] anywhere in clase   maintable   inner join   subtable   on (.. = ..)   .. = ..  

finally i've found solution. there "show sql query.." in crystal reports apps. in query view i've found 1 of tables taken database (test db instead of production one). table not view having problem access. , 1 more: database expert showing in properties tables comes 1 db.

after manage set location of table taken same db - problem accessing view fixed - name in clause now.

shame on crystal reports, shame on you..