Using Stored Procedure w/Parameter and adding another parameter via CR

[Former Member]

I have a situation where I am using a SQL Stored Procedure that contains one Date Parameter.

I am pulling that Stored Procedure fwd into a Crystal Report, but as soon as I add another Parameter via Crystal Reports (in addition to the Parameter that was pulled fwd from the Stored Procedure) Two parameters prompts now appear for the Stored Procedure Parameter.

I need to have the Crystal Report display the Stored Procedure Parameter only once.

[former_member11696]

Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with you directly:

http://store.businessobjects.com/store/bobjamer/DisplayProductByTypePage&parentCategoryID=&categoryI...

[former_member11696]

I don't think that is possible in CR. The first Parameter is to get connected to the data source, SP parameter. Once connected then CR needs it's parameter, Filtering is done through the SP Parameter and then second pass filtering is done through Crystal.

All I can think of is to add the second parameter to the SP so they are prompted at the same time.

You may want to try connecting to the SP through a Command Object and add the second parameter also in the Command Object. Then it may prompt using one box. Copy the SQL from your existing report in Show SQL and paste that into the Command UI and then add the CR parameter to the Command UI and remove the SQL CR created for the parameter from the original report.

Thank you

Don

[Former Member]

I have a Parameter within the SP that is for a Date entry. So I pass the SP Parameter through the Command to CR.

Then I have added some other Parameters that I have the users populating but they are only used in formulas and I donu2019t have those in the Select Records.

Then I add another Parameter that would be for Supplier Selection. As soon as I add this 4th Parameter for the Supplier Select within the Select Record, is when I then encounter the duplicate display of the SP Parameter.

The first prompt is a Date field but for some reason is displaying in the Right hand corner SUPNAME (which is my Supplier Name field) Then the next set of Parameters display is properly showing in the right hand corner all of my actually Parameters.

Why would the first occurrence be associated with the Supplier Name?

I have tried adding a Supplier parameter to the SP itself, but then I am limited to a single entry, it will not allow me to set it to Multiple Values.

Any additional suggestions or information would be greatly appreciated.