CR 8.5 running reports against SQL2000 databases through ODBC connections.
Reading through the Crystal user guide and The Complete Reference Manual for CR 8.5, I can find information on how to create an array table (why you would want to do this is beyond me!) but is there any way to pull information from that table once it is an array?
Our SIS (Student Information System) uses an array table on the attendance side of the program. Everything is in one huge table. You can run an aggragation that breaks that up into seperate tables, but then we lose the "real time" data since those tables are only updated when someone runs that aggragation.
Does anyone know of any information somewhere that I can read up on about creating a report from an array table or is this just not possible?
Reading through the Crystal user guide and The Complete Reference Manual for CR 8.5, I can find information on how to create an array table (why you would want to do this is beyond me!) but is there any way to pull information from that table once it is an array?
Our SIS (Student Information System) uses an array table on the attendance side of the program. Everything is in one huge table. You can run an aggragation that breaks that up into seperate tables, but then we lose the "real time" data since those tables are only updated when someone runs that aggragation.
Does anyone know of any information somewhere that I can read up on about creating a report from an array table or is this just not possible?