Assign fixed value to parameter field
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22097
Printed Date: 31 Mar 2025 at 12:35am
Topic: Assign fixed value to parameter field
Posted By: pbengtss
Subject: Assign fixed value to parameter field
Date Posted: 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.
|
Replies:
Posted By: kevlray
Date Posted: 27 Sep 2016 at 4:02am
|
Why would you want a parameter? Why not just make it a filter?
|
Posted By: pbengtss
Date Posted: 27 Sep 2016 at 4:32am
|
The stored procedure requires it.
|
Posted By: kevlray
Date Posted: 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
Date Posted: 27 Sep 2016 at 7:39am
CR Pro XI.
The link doesn't help in this case.
|
Posted By: kevlray
Date Posted: 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
Date Posted: 31 Oct 2016 at 12:35am
|
I changed the stored procedure and removed that parameter.
|
|