Joined: 18 May 2016
Online Status: Offline
Posts: 22
Topic: Assign fixed value to parameter field 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.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
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
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
