I have created a custom Crystal Report (CR 11). I built an RE query that feeds an RE export. This RE export(Access 2000 database) feeds my Crystal Report. In my Crystal Report I had to attach to the (Access 2000 database) twice to get the data paired up (So, have one table (regular name and an alias tablename). All of this works fine separately. I added the Crystal Report into RE on the Custom Report Screen. I have setup up the export and crystal report files.
When I run it it all works fine (the Export runs and generates all of the records) until RE seems to want to know about the Alias tablename I created in Crystal Reports and stops the whole process with this error.
Table '<alias tablename>' is required by report but not present in the export file.
If I run all the components separately, it all works fine. The problem happens when I add the Crystal Report into Custom Reports.
Any thoughts on a way to get RE to accept this alias tablename....?
Mike, it may be helpful to take a look at BB98520. One possible cause is "The file was exported in Microsoft Access Database File format instead of Blackbaud Report Writer Database File format" so you may want to try changing the export format.