No subreports and I never ever do the page n of m. I'm pretty advanced at Crystal so this is all the more frustrating. It's a simple stored procedure that reads transactions that have been indexed pretty well at this point. I've reduced the number of joins and fields in the stored procedure. It's basically reading transactions, determining if the transaction is a charge, payment, credit or debit and putting the amount in a different field for each, then grouping by the transaction ID that they are all tied to.
In order to populate the provider parameter list, I created a simple command and in Crystal I joined it to the stored procedure. I only use the command to populate the parameter. Is this perhaps a problem? It has worked fine in other situations I'm working with....
IP Logged
