3 November 2005
Crystal Reports bug: tables from multiple databases can only have one link
Using Crystal Reports prior to version 10, tables from different databases cannot be linked using more than one column. So, if two tables are joined by the columns id1 and id2, you can only specify a link for one of those columns. More than one join will display a message box with the error "Invalid file link. Not all fields in same index expression."
References:
- This Crystal Reports knowledge base article says it's a problem found in CR7 but present in all versions.
- This Google cache of an Experts Exchange article provides a workaround (although that did not work for me in CR8.5). (Experts Exchange locks their content, but can be accessed from Google's cache.)
- This USENET thread says that it's fixed in CR10.
I tested using the demo version of CR11, and could successfully link multiple fields.
[ posted by sstrader on
3 November 2005 at 3:12:59 PM in Programming
]
- Techniques after using Swift for a month posted by sstrader on 26 August 2015 at 11:41:51 PM
- Some thoughts on Ruby after finishing a week (minus one day) of training posted by sstrader on 15 December 2011 at 8:59:30 PM
- Links on the singleton pattern posted by sstrader on 9 December 2011 at 9:19:50 AM
- Phonebot posted by sstrader on 29 October 2011 at 6:37:05 PM
- The labeled break in Java posted by sstrader on 4 September 2011 at 11:27:56 AM
Related entries
Other entries categorized in Programming: