Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameter on sub report not being sent to SQL SP
Message
From
12/05/2005 08:40:11
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Title:
Parameter on sub report not being sent to SQL SP
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01013340
Message ID:
01013340
Views:
58
Hi all,

This one has me scratching my head. I have a sub report on a crystal report which gets it's data from the result set of a SQL stored procedure with five parameters. All these parameters are defined on the sub report and linked to fields or parameters on the main report. The problem is that the first parameter in stored procedure is not being sent from the sub report. Instead, parameters 2 - 5 are being sent in the order of 1 - 4. The first parameter is linked to a field from a result set of a stored procedure on the main report.
Anyone confused yet?

Any ideas as to what the problem may be??

Thanks in advance!
Next
Reply
Map
View

Click here to load this message in the networking platform