Search results for query: *

I am trying to use a SQL stored procedure as a data source for Crystal 8.5. After I mark Stored Procedures in the Options screen, then try to select the database through the ODBC, Crystal crashes. What am I doing wrong?

LBASS, The maximum subtotal seems to work. Now, how would I come up with a Grand total if I had a report with multiple cruises? SL

Thank you for all the comments. Yes, dgillz, this is a one to many relationship issue between 2 tables. lbass, I will try maximum in running total (instead of sum which is what I used befored)and let you know how it turns out. SL

synapsevampire: Thanks for the tip. I am working with Crystal 9.0. The database is a SQL database with a OLE data connection. The data example is above, however, the Total line is what I am looking to achieve-- and have not been able to do. (Ex. with the data set above, I get a total for...

I have a report that has the following data columns: Doc Cruise Item No. Cruise Airfare Cruise Airfare No. No. Revenue Revenue Commiss* Commiss* 1 ABC Cruise $10,000 $120 1 ABC Upgrade $2,000 $120 1 ABC...

Thanks for your help!

I am trying create a parameter in Crystal based on the dates on SOP10106.USRDAT02. When I go to set default values, the field is not available. How can I do this?

I am trying to total only the first record in a group in Crystal 9.0. What is the best way to do this?