Passing parameters RPG-CL-RPG
I am trying to modify an intermediate CLLE program to submit itself to batch. The calling program (ILE RPG) passes a parameter as a character field with a number in it. The CL program receives it as a numeric field and then calls another RPG program and passes that parameter. The final RPG program receives [...]

Answer Question   |  March 19, 2012  7:47 PM
CLLE, Parameters, RPG ILE

Date parameters within crystal reports 8.5 still brining up all records
Hi, I have created a date parameter as I would like to be able to view absence within the company during certain dates. When I run the parameter it still brings up all the records. Is anyone able to help?

Answer Question   |  March 31, 2012  9:04 AM
Crystal Reports, Crystal Reports 8.5, Parameters

CLP parameters overwritten
Hi.  When I call a CLP, either from command line or from a sbmjob with alpha parameters, if I don’t fill up the whole string length it’s trailing blanks are overwritten by the next parameters.  Example:  PGM PARM(&P1 &P2 &P3)  DCL VAR(&P1) TYPE(*CHAR) LEN(50)  DCL VAR(&P2) TYPE(*CHAR) LEN(50)  DCL VAR(&P3) TYPE(*CHAR) LEN(50)  ….  CALL XX [...]

Answer Question   |  April 4, 2011  12:20 PM
CL programs, CLP, OS/400, Parameters, SBMJOB

help with access database
Searched high and low and while there are many internet posts addressing this topic, none seem to be geared low enough for this ubernubee. I have 2 tables, one lists various addresses and associated file numbers, the file numbers are unique and the primary key in the table. The other table lists various property details [...]

Answer Question   |  March 16, 2011  6:03 PM
Access 2007, Access Database, ComboBox, Parameters, Refresh Report parameters

Error Message when trying to change Parameters – Crystal Reports 11
Failed to Retrieve data from the database. Details: ADO Error Code: 0x80040e14 Source: Microsoft OLE DB Provider for Oracle Description: ORA-06550: Line 1, Column 7: PLS-00201: identifier ‘WHSP_USER.SP_RPT_DAILY_LANE_EXCEPTION’ must be declared ORA-06550: Line 1, Column 7: PL/SQL: Statement ignored Native Error: 6550 [Database Vendor Code: 6550]

Answer Question   |  January 25, 2011  1:43 PM
Crystal Reports 11, Crystal Reports error messages, Crystal Reports Errors, Parameters

Can i use two parameter in oracle report
i want to make a report with two parameter when user select user name in one parametr other show names of all users and user select one name ane detail of that user is shown in report.or if user select any other field other parametr show data of that selected column to selected by the [...]

Answer Question   |  January 6, 2011  9:56 AM
Oracle developers, Oracle development, Oracle Reports, Oracle Reports User Parameters, Parameters

Adding New Parameter to a existing Crystal reports 9.5
I have a exsiting crystal rpt that passes 5 parameters to a stored proc.  We have added 1 more parameter to the procedure now when attempting to run the crystal rpt it errors out with proc expects parameter “new” (new being the added parameter).   I have been unable to get around this. Can anyone help. [...]

Answer Question   |  December 16, 2010  6:32 PM
Crystal 9.5, Crystal Reports 9, Parameters, SQL 2000 to 2005 Migration

Returning AS/400 parameters from procedures
If I have a sub procedure :- P SUBP B D SUBP PI X(10) D Parm1 X D Parm2 X D Parm3 X(10) value options(*nopass) D Data_item X(10) C /free C [some][/some]C If %parm < 3 C Return Data_item C Else C Parm3 = Data_item C Return C Endif C /end free P SUBP E [...]

Answer Question   |  November 11, 2010  10:36 AM
AS/400 Parameters, Parameters, RPG ILE subprocedure, RPG Programming

SQL Server Reporting Services (SSRS) Reports 2005
How to include to Input parameters in the report, so as to help users identify the parameters on which the report was run.

Answer Question   |  October 4, 2010  12:06 PM
input parameters, Parameters, SQL Server, SQL Server reporting, SQL Server Reporting Services, SSRS, SSRS reports, SSRS Reports 2005

XML Publisher Report
I made Matrix report in XML Publisher in that there are two parameter for Date (From Date & To Date)when i run report for one day it is working fine when i run for a month it givs worning i.e Beginning post-processing of request 76437793 on node TAJORN3 at 30-SEP-2010 12:02:15. Post-processing of request 76437793 [...]

Answer Question   |  October 1, 2010  10:16 AM
Parameters, XML development, XML File Creation, XML Publisher

Using AS400 COBOL or CL Program to Call an Excel File and Pass Parameters Back and Forth from 400 to Excel Back to 400
[html xmlns=""> I am beginning my investigation to figure out how to use either a 400/COBOL program or a CL program to call an excel spreadsheet that requires three parameters to a calculation and to return a value back to my 400/COBOL program of CL program so that I then can use that value in [...]

Answer Question   |  September 30, 2010  1:58 AM
AS/400, CL Program, COBOL, excel, Parameters

Float type parameter containing incorrect value after a callp
I’m calling a procedure from an rpg pgm(V5R4). It has several parameters with different types. Before calling, they are set to 0 or blanks. After calling, all is coming back with correct value except for 1 float(8f) field. We don’t have the source for the procedure however, it’s been tested in C pgm and it works [...]

Answer Question   |  October 3, 2010  7:42 PM
float parameter, Parameters, PGM, RPG, V5R4

Crystal Reports XI – Duplicate input parameters
I am creating a Report with the input parameter for all the sales representatives across multiple states. On the report input parameter the values listed are as follows: N/A User1 – CA User2 – CA User3 – CA N/A User1 – CO User2 – CO User3 – CO and so on. I am hard coding [...]

Answer Question   |  September 28, 2010  4:02 AM
Crystal Reports, Crystal Reports Conditional Parameters, Crystal Reports XI, duplicate parameters, input parameters, Parameters

Conditional processing for Connect Direct on UNIX
I want to send a parameter to my unix script which I use to decide if the file that was sent using Connect Direct is moved to backup. The only Condition is seems to use is if the previous step was successful.

Answer Question   |  August 30, 2010  1:54 PM
AIX, Parameters, Unix, Unix administration

How to create a parameter based on previous parameter.
How to create a parameter based on previous parameter. Good Day, I am fairly new to CR and I was wondering if there was any way to accomplish the following? I am looking to create a parameter based on a previous parameter. I am using CR v.XI. Simple Example: Parameter #1: Run Report BY: (a) [...]

Answer Question   |  May 25, 2010  1:10 PM
Crystal Reports User Settings, Crystal Reports XI, Parameters

Passing parameters to report viewer
Hi Kindly excuse me if I appear a bit ignorant on this subject as I am relatively new to SSRS. I have managed to create a report that has 3 parameters (ie. Start Date,End Date,Drop down list) which I have successfully deployed to Report Server. The report basically uses a stored procedure which has the [...]

Answer Question   |  April 19, 2013  11:52 AM
C, C# .NET, Parameters, SSRS

Scope identity on a stored procedure in SQL
I have created the following stored procedure in SQL: CREATE procedure [dbo].[sp_trip_number] @Table_Name nvarchar(100), @Trip_Number int output as begin set nocount on begin transaction DECLARE @DynamicSQL NVARCHAR(1000) DECLARE @New_Trip_Number int SET @DynamicSQL=’INSERT INTO ‘ + @Table_Name + ‘ DEFAULT VALUES’ + ‘;’ + ‘SELECT’+ @New_Trip_Number+ +’=’ + ‘SCOPE_IDENTITY()’ EXEC (@DynamicSQL ) SET @Trip_Number = @New_Trip_Number [...]

Answer Question   |  December 11, 2008  7:54 PM
Parameters, scope, SQL Server stored procedures

Are parameters permitted on SQL Server 2000 views
I think the answer to this is NO, but is there a way to create a view that accepts input parameters? I created the view hard coding in something that now needs the flexibility that a parameter would provide, but I’ve never seen a parameter on a view – Is it possible? Thanks

Answer Question   |  August 20, 2010  7:06 PM
Parameters, SQL Server 2000, SQL Server 2000 views, SQL Server views

Creating a stored procedure in SQL
I need to create a stored procedure in SQL where the clause WHERE is a parameter. Is this possible? If yes, how?

Answer Question   |  April 8, 2010  6:50 PM
Parameters, SQL, Stored Procedures

Definition of the withGrant parameter in SQL
When giving permissions to database users in SQL, what does the withGrant parameter do?

Answer Question   |  September 5, 2008  8:09 PM
Parameters, Permissions, SQL