How do I create a Parameter Field From a Formula?

Using Crystal Reports 8.5. I created a formula field called "Transfer To AR". This uses a field from a SQL table where there are about 30 different possible entries. The formula is an IF THEN ELSE formula. If Closed Reason = "Transfer To AR" THEN "True" ELSE "False". I want to create a Parameter...

jmsdcounty5 pointsBadges:

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...

Vatchy1,415 pointsBadges:

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...

Nmarrakchi5 pointsBadges:

Parameterized Query Syntax

Thank you Mr Hatmaker for sharing the "Parameterized Query with excel." I have watched the videos on youtube (beyond excel) describing the function and I have a few questions.1-I am looking for the syntax for "contains". I am searching for the syntax to place in the criteria field that would return...

YulData5 pointsBadges:

Daily Job Suddenly Disappeared

Hello, We have job that runs in overnight batch Mon-Friday. The users access the reports the next morning. Suddenly, on 1/18/2008 the spooled reports for the job are no longer on the system. All previous jobs are there, but since this day the job has ran daily but none of the reports are kept-users...

Turing200810 pointsBadges:

iSeries: Command that accepts object name as parameter

I've been trying (and trying) to create a new command on iSeries, where the parameter has the same file name using the LIBRARY/FILE MEMBER syntax. Something like this:MYCMD FILE(MYLIB/MYFILE MYMEMBER)Or this:MYCMD FILE(MYLIB/MYFILE) MEMBER(MYMEMBER)I've tried several things including:Create a PARM...

ITKE1,131,715 pointsBadges:

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...

Shaygen5 pointsBadges:

Crystal Report using SQL 2005 Stored Procedure with DateTime Data type variable

I want my Crystal Report parameter calendar pick to display date only

LrdByron5 pointsBadges:

url validation testing?

1.when i change (add /n," , ' parameter manipulation) the URL , so now how the web application or websites act? 2. any good business rule or usecase available for the URL validation or Redirection? Regards Prabakar M

Sibiprabu5 pointsBadges:

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?

Ajmx5 pointsBadges:

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)...

Jsebastians15 pointsBadges:

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...

Joebaich5 pointsBadges:

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 user to...

Zaraiqbal5 pointsBadges:

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...

Ftrucks015 pointsBadges:

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 And then if I call it using Callp SUBP(A: B:...

MichaelRlancaster15 pointsBadges:

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.

YogeshNT5 pointsBadges:

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...

kglen0160 pointsBadges:

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...

Naved5 pointsBadges:

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 my...

400Programmer185 pointsBadges:

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 N/A as the default value...

NaviIT5 pointsBadges: