Welcome to Forums Sign in | Join | Help | Forums
in Search





Make the world a better place.

Custom Crystal Report Problem...

Last post 12-11-2008 4:28 PM by Sarah McBride. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 12-10-2008 4:55 PM

    • Mike Coleman
    • Not Ranked
    • Posts 2
    • Organization: Oklahoma State University Foundation

    Custom Crystal Report Problem...

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

     

  • 12-11-2008 4:28 PM In reply to

    • Sarah McBride
    • Top 50 Contributor
    • User Since: 2005
    • Posts 108
    • Organization: Blackbaud Test Site 2
    • Products:  The Education Edge, The Raiser's Edge

    Re: Custom Crystal Report Problem...

    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.

    Sarah McBride
Page 1 of 1 (2 items)