-
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...
-
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...
Last updated: -
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...
Last updated: -
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...
Last updated: -
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...
Last updated: -
Crystal Report using SQL 2005 Stored Procedure with DateTime Data type variable
I want my Crystal Report parameter calendar pick to display date only
Last updated: -
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
Last updated: -
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?
Last updated: -
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...
Last updated: -
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)...
Last updated: -
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...
Last updated: -
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...
-
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...
Last updated: -
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:...
Last updated: -
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.
Last updated: -
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...
Last updated: -
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...
Last updated: -
[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...
Last updated: -
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...
-
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.
Last updated: