Set up Crystal to use ADO report w/ count field

[glschill]

I am trying to set up my Crystal report to accept an ADO recordset, but the recordset is grouped to obtain the count of certain records. Since this new count field is not a part of the Oracle DB that my original report is structured on, I'm getting an error because it doesn't recognize the field. Does anyone know how to set up the Crystal report to accept the count field?

 

[olichap]

Have you considered doing the count in your report? I've found that when dealing with rather involved record groupings, assuming I'm sending them to report format, it's easier to do this through Crystal. You should be able to get your count through CR as well. You also may find that it runs faster when you don't have to do complex groupings on your database server.

How are you getting the recordset; do you create it through another app (VB?) or strictly using CR? Is your recordset executing a stored proc or sql string (shouldn'g make a difference but might)?