We have many multi-member files on the iSeries that we would like to report against using Crystal Reports. I have created an Alias file name using SQL on the iSeries to reference a single member within a file. The alias file is not showing up in my datasource list in Crytal Reports. My IBM iSeries Access for Windows data source definition is using the "iSeries Access ODBC Driver". Do I need to setup another data source using a different driver to access SQL alias information on the iseries? If so, which driver should I use?
Any ideas would be much appreciated. The Crystal product is new for us and we still have a lot to learn. Thanks!