Incomplete result set returned by record select - Crystal XI, MS SQL stored procedure
- From: steven.tadlock@xxxxxxxxx
- Date: Mon, 23 Jul 2007 07:35:08 -0700
I've got a stored procedure written in T-SQL. When I use Query
Analyzer to call the stored procedure, all records are returned that
I'm expecting. Same if I just copy the code from the sp directly into
query analyzer. So, the sp would seem to be working properly.
My Crystal XI report hooks into the sp using a MS SQL ODBC driver. The
db connection works correctly and permissions are not an issue (logged
on as sa) I have a cascading record selection in the report that uses
prompt parameters. That functions fine, the prompts seem to work OK, I
can select most records.
Here's my problem: the first record selection prompts for a person's
last name. It's a drop-down, you click the drop-down, you see a list
of names, in alphabetical order (just as the sp creates it).
But the list only goes up to S. There are no records for T through Z.
Remember, the sp executes properly within Query Analyzer and does
return all records, A to Z. Just not the Crystal report.
This was working fine on Friday. I don't know if my server was out
drinking all weekend, maybe picked up a cute little laptop at a trance
club, did some X and is now hung over and just doesn't feel like
cooperating with non-native applications but I'm mighty puzzled as to
why it decided to stop working today.
I've manually executed the sp several times, even scheduled it run
every 10 minutes, I just don't know what else to try.
Anyone got any clues, 'cause I'd like to buy one, please!
Thank you.
Steven Tadlock
.
- Follow-Ups:
- Prev by Date: system.exception while accessing the crystal reports
- Next by Date: Query egine error
- Previous by thread: system.exception while accessing the crystal reports
- Next by thread: Re: Incomplete result set returned by record select - Crystal XI, MS SQL stored procedure
- Index(es):
Relevant Pages
|
