asked on

Crystal report XI subreport linking errors using a stored procedure

ok -

I am feeding parameters via a command to a stored procedure. that stored procedure is linked in a subreport in crystal. The links were all working fine and all the sudden the {start date} and {end date} subreport links drop off my report stops working. I have attached some screenshots for review.

Any help would be wonderful... I have no idea how to get my parameters linked back.

Mike
Subreport-links-dropping-off.doc

ASKER CERTIFIED SOLUTION

pssandhu

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mike DeFelice

ASKER

No it did not help... In fact I cannot change the parameter from a string. it keeps on reverting back... When I try to send it I get a failure of: error 42000 - invalid syntax near 2009.

I have to assume 2009 is the date that I entered in the parameter to verify the database.

verification-error.doc

pssandhu

Are you sure you do not have any dates specified under "Record Selection"? If you are make sure you are coverting it into the correct datatype there.
Also, make another copy of the report so we can test. On the copy delete the SQL Command and use Database Expert to link to the Stored procedure. When you link to the stored procedure the paramets should be created automatically and then check to see if you can link to the subreport.
Between, is you subreport a stored prc too. Try refreshing the subreport on its own to make sure there are no problems with the subreport.
P.

Mike DeFelice

ASKER

I was wrong... I implimented the solution incorrectly. pssandhu was right .\

Thanks!

Mike