Search results for query: *

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...

Hi, I opened a .csv file in excel a couple days ago and each field appeared in its own column (good). I re-opened the same file again, and now all the values are smooshed into the first cell of each row (bad). Is there any way I can revert the file back to the way it was when I first opened...

I found there is an extra field in the table that the view is based on. Thanks very much, LB!

I think the difference in the number of rows is due to some records being repeated... Would the use of Left Outer Join make repeats possible? Thanks, TY

I ran the query replacing the old FROM clause with the clause you suggested (Thanks!) I got the same number of rows as the newer query (1019 rows) Thank you. TY

Thanks LB, The first (older) query returned 969 rows. The newer one returned 1019 rows. I'm going to try running the query with your FROM clause. TY

Hi, We have migrated to a new version of an application that integrates with Crystal Reports 9.0. I'm trying to update the reports and replace an old database field with a different one. I notice that when I compare the old and new queries on my database, the number of returned rows is...

Hi Ian, I am offsite today, and can't get the SQL right now. I will re-post with the SQL as soon as I can. Thanks, Teresa

Thanks IanWaterman, In at least one case, simply restoring the link did not appear to fix the problem. The report is considerably slower and the number of records keeps inflating. It takes so long to load, I actually have to stop the report! I have not had the chance to check all fields in...

Hello: I am working with Reports created in version 8.5, but trying the save them in version 9.0 - to make them available through an external application. When I open the old report using 9.0, links between tables have been lost. Has anyone else encountered this problem? And if so, is there...

Hi there, I have a prompt for user names, but it does not seem to show new users that I add to my database. Only pre-existing users (when I created the parameters) appear in the pick list. I'm using version 9 and can't figure this out. Any help would be greatly appreciated. Thanks, Teresa