Failed to Open Rowset error

[TeresaSalesPlus]

Hi,

I have a report for Crystal 9.0 that works on my system (I have the software installed). But, when I make the report available to users who only have the Crystal Viewer, they get an error like:

"failed to open rowset.... The column prefix 'au_sls_terr_d_vw' does not match a table name or alias name used in the query"

But the query is as below:


SELECT ric_comp_list_vw.model_code, ric_comp_list_vw.name, ric_comp_list_vw.ext_cust_num, ric_comp_list_vw.cont_name, ric_comp_list_vw.phone_num, ric_comp_list_vw.addrline_1, ric_comp_list_vw.city, ric_comp_list_vw.post_code, ric_comp_list_vw.ric_lease_exp_dt, ric_comp_list_vw.ric_term_remaining, ric_comp_list_vw.sls_terr_code, ric_comp_list_vw.ric_product_serial, au_model_desc_vw.long_descr, au_domain_desc.long_descr, au_domain_desc.locale_code, ric_comp_list_vw.ric_lease_payment, au_model_desc_vw.locale_code, au_sls_terr_d_vw.long_descr
FROM ((ric_comp_list_vw ric_comp_list_vw INNER JOIN au_model_desc_vw au_model_desc_vw ON ric_comp_list_vw.model_code=au_model_desc_vw.model_code) INNER JOIN au_domain_desc au_domain_desc ON ric_comp_list_vw.sls_terr_code=au_domain_desc.domain_code) INNER JOIN bcrm434.dbo.au_sls_terr_d_vw au_sls_terr_d_vw ON (ric_comp_list_vw.sls_terr_code=au_sls_terr_d_vw.sls_terr_code) AND (au_domain_desc.locale_code=au_sls_terr_d_vw.locale_code)
WHERE au_domain_desc.locale_code=1033 AND ric_comp_list_vw.ric_lease_payment>0 AND ric_comp_list_vw.name LIKE N'%' AND ric_comp_list_vw.ext_cust_num LIKE N'%' AND au_model_desc_vw.long_descr LIKE N'%' AND (ric_comp_list_vw.ric_lease_exp_dt>={ts '2009-04-01 00:00:00'} AND ric_comp_list_vw.ric_lease_exp_dt<{ts '2009-07-15 00:00:00'}) AND au_model_desc_vw.locale_code=1033 AND au_sls_terr_d_vw.long_descr LIKE N'%'

Can anyone give me a clue what is wrong? Thanks,

SP+

 

[Turkbear]

Hi,
How is the report connecting to the database? What viewer is used and how does the user access it? Do the users have the same access rights to the data as you do or are they using some other authentication.

It appears that their 'view' of the data does not include a table ( or view) named
'au_sls_terr_d_vw'




To Paraphrase:"The Help you get is proportional to the Help you give.."