Assign fixed value to parameter field

Printed From: Crystal Reports Book — Forum Name: Technical Questions

Posted By: pbengtss — 26 Sep 2016 at 9:24pm

I have a report that contains a parameter field. However, the value always has to be 1 and it will never change.
How do I make the report to always choose 1 instead of prompting every time I open the report?

I can't change the setup - the parameter field will always be in the report.

Posted By: kevlray — 27 Sep 2016 at 4:02am

Why would you want a parameter? Why not just make it a filter?

Posted By: pbengtss — 27 Sep 2016 at 4:32am

The stored procedure requires it.

Posted By: kevlray — 27 Sep 2016 at 4:59am

Depending on what version of Crystal you have. You can have the parameter have a default value. But given that it is a parameter I do not know how to 'hide' it. In Microsoft Report Builder you can hide parameters.

I did find this link, I have not tried it myself. http://scn.sap.com/thread/908053

Posted By: pbengtss — 27 Sep 2016 at 7:39am

CR Pro XI.

The link doesn't help in this case.

Posted By: kevlray — 27 Sep 2016 at 11:30am

Sorry, out of ideas. Unfortunately I am not well versed in using Stored Procedures with Crystal Reports. I know that calling Stored Procedures from SQL Server Management Studio, you can 'hard code' values sent to a Stored Procedure.

Posted By: pbengtss — 31 Oct 2016 at 12:35am

I changed the stored procedure and removed that parameter.