Ok, Strange one.
I installed my app (32bit) on windows server 2008 R2 (x64) with
SQL_2005_Native Client (64bit) and Crystal Reports 13.0.1 (x64).
Everything appears to work correctly. EXCEPT;
When I run a report that pulls from a stored procedure with 36 or more
columns in the result set. The crystal report does not show the last
column it will show it as or sometimes wont show it. If I add a 'blank' column past the last one in the stored procedure then everything in the report displays as expected, obviously not ideal.
If I test the app on my development machine (Visual Studio 2010), or a fully (x86) windows 7
installation these issues do not occur.
Does anyone have any ideas?