Showing posts with label Crystal 9. Show all posts
Showing posts with label Crystal 9. Show all posts
Wednesday, December 3, 2008
Change Where statment for report
Right-click on report designer
>>select reports menu
>>>> Selection Formula
>>>>>>Row
In designer type of select criteria
>>select reports menu
>>>> Selection Formula
>>>>>>Row
In designer type of select criteria
Add new table to report schema
use Database Export, browse to new table and click move to right
Click links table and correct table for new table
Click links table and correct table for new table
Crystal Reports sucks
For VSS.NET 2003 and crystal 9
You must apply SP1, SP2, SP3 to fix a host of issues including table alias not handled properly when crystal renders its internal report query.
Also: If table schema has changed for an existing report, connect to database with current schema and use database expert to sync cached schema in report to actual schema.
Why anyone stills uses this product is beyond me? At least editor ingration into VSS.NET makes it 2% less painful.
Crystal 9 will connect to SQL Server 2008 database.
You must apply SP1, SP2, SP3 to fix a host of issues including table alias not handled properly when crystal renders its internal report query.
Also: If table schema has changed for an existing report, connect to database with current schema and use database expert to sync cached schema in report to actual schema.
Why anyone stills uses this product is beyond me? At least editor ingration into VSS.NET makes it 2% less painful.
Crystal 9 will connect to SQL Server 2008 database.
Subscribe to:
Posts (Atom)