Error: Column Number Out of Range

[onegurl]

Please help if you can: receiving error "Column Number Out of Range" followed by "database dll error". What does this error mean and why would I get it?

Running a report off of a SQL server stored procedure. The stored proc pulls appropriate data for a representative (4 digit repid) or a territory (2 digit id). I only receive the error when I am running the report for the territory (2 digit id).

To add to the confusion, a similar stored proc and report design is used to run the report for the previous sales year. (Only difference between the two stored procs/reports is the sales year). Additionally various reports including more complicated ones, are run successfully without this error.

my thanks in advance for any help.

 

[IdoMillet]

Try to open the report in Crystal and use the menu option of:
Database, Verify Database
to ensure Crystal and the Stored Procedure are "synchronized".

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[onegurl]

did verify database: stored proc and report are in sync.

additional information: report runs fine when running stored proc for rep '####' (4 digit salesid); column number error occurs when running report for territory '##' (2 digit salesid). Stored proc runs fine for both rep and terr when run in Query Analyzer.

thanks for your input