A tough one!!!!!!!!!!!!!

[marydn]

Can anyone tell me if the following is possible:

A report that displays a customer name that reports off customer table. The user can then drill down on that customer to obtain order information. The order information is supplied by a stored procedure. However, the CustomerID must be passed from the report to the sp without the user knowing it.

Thanks!!!!!!!!!!!

 

[lyanch]

You can do this easily with any of the newer versions of Crystal. I would probably recommend an "on demand" subreport rather than a drill down.

Lisa

 

[kenhamady]

Does the SP have a parameter?
What version of CR are you using? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[marydn]

Ken,

I am using Crystal 8. The stored procedure does have a parameter. I added the subreport to the main report and I set the link on the ID field. For some reason the report still asks for the sp parameter. It is not being passed. Any help would be appreciated!

 

[Naith]

You're linking to the wrong field.

When you're setting the subreport links, in the "Subreport field to link to" there is an extraordinarily small scroll bar in the field window. Scroll down it until you get to the subreports parameter and link to that.

Naith