I wont to use PL/I comman like for using same structure twice. Compiler returns error : IBM7043I S 4.1 SQL0314N The host variable “xxxxxxxx” is incorrectly declared. SQLSTATE=00000 IBM7043I S 9.1 SQL0117N The number of values assigned is not the same as the number of specified or implied columns. SQLSTATE=42802 Is there eny way to…

Oracle10g / Crystal Reports XIR2 / Central Management Console (CMC) Our Crystal Report fetches the last one week’s data from a big table. This report runs weekly, once. To tune this report, we created another table to maintain the primary key value(numeric sequence), of the latest viewed record. Through a stored procedure, we fetch this…

i tired these steps : # Download the Microsoft JDBC driver: Microsoft SQL Server JDBC Driver # Extract to a good location. I chose c:program files to extract to. # Copy the sqljdbc4.jar to your installation directory which by default is: c:program filesjasperserver-pro-3.5.1apache-tomcatwebappsjasperserver-proWEB-INFlib # Restart JasperServer (there is a shortcut in the start menu to…

I AM USING AN EXCEL SPREADSHEET AS MY DATABASE. ON THE SPREADSHEET I HAVE A COLUMN THAT HAS NUMERIC AND ALPHA VALUES. WHEN A ADD THIS TO THE CRYSTAL REPORT ONLY THE NUMERIC VALUES DISPLAY AND THE FIELD CANOT BE FORMATTED AS ANYTHING OTHER THEN A NUMBER FIELD. ON THE EXCEL SPREADSHEET THE COLUMN IS…

I have to develop maps which execute extracting and loading data. If, because of any reasons MAP failed with any errors have to fix and restart the same MAP, this time it has to start processing data where it got failed. Please let me know how could I develop map satisfying in both situations.

I want to use SAP IS-Retail functionality of generic variant but creating articles via MDM. Is this possible?? If so, what version of MDM do I need, etc

Hi, i need to connect Cognos with .Net how could i connect then generate reports and then save it in some other format like HTML or EXcel through .NET. Regards, Neha

The report I’m currently attempting to write needs to pull data from two separate tables (linked via a third). Easy to do, especially as the report is specific to the linking value. However, I need to be able to sort the data in the two tables together. To clarify, the Abbrev field in one table…

I have a COBOL program that calls a db2 stored proc program. I get corrupted o/p records when reading the input file from CARTRIDGE. The same records, when copied to DASD, come out fine. Same code, JCL, etc. WTH! Is there a parameter that I need to pass to the system with PGM=IKJEFT01 to solve…

I am using VB6 with back ground Database DB2 AS400 iSerices and Crystal Report 9.0. When I Show the Report Its prompt me to enter password. I have tried to find the solution and found some thing about LogOnServer but every example is there for Crystal Report 7,8, and 8.5. I have tried to use…

I have an iSereis with 2 LPARs – one running V6R1 with a Cobol compiler (not ILE) and the other LPAR is running V5R3 with DB2 files.  What code and/or compiler options do I use to connect the v6r1 Cobol with the v5r3 database and how do I create the Cobol program to run on…

Any new formula I try to write comes up with this error. I have disabled all report formulas that use a shared variable thinking that it would take care of my problem. I am using version 8.5. If I reinstall it would it clear up the problem?

I want to set a global policy where every time someone uploads or creates a document in the share point he will need to enter some basic meta data about the document (like it’s security level and type) not just on a site level but the entire portal. we had a policy like that at…

IN ACAD 2008 ON SOME PROJECTS WHEN A XREF IS BOUND WITH INSERT OR BIND THE XREF WILL DISAPPEAR BUT STILL SHOWS THAT ITS THERE IN THE DIALOG BOX AS IF NOTHING HAPPENED. ANY IDEAS?

I’m working on a formula to calculate the number of criminal offenses that occurred in the same amount of days as my date search parameter but prior to the start date. The date search parameter is always changing. The idea is to compare the number of offenses from the last time period. I want to…

How create opening total ? and how to make it display only one time?

I have a crystal report (XI) with approx 25 tables querying from MSSQL Server. I was wondering if there is a limit to the number of tables allowed in a query. or a limit to the number of alais allow against specific tables? Reason I ask: I recently tried to add tables (alias of tables…

Dear Sir/mam, I would like to ask some questions regarding the use of SPSS for statistics analysis: 1. In examining the reliability of the measures used in questionaires, do I have to calculate the measures of Independent variables separate from dependent variables, so I have two Cronbach’s alpha scores? or do I need to calculate the…

We work with a lot of documents in my office. So of the managers use Abode Acrobat to high light areas of a document, so they can use it for training purposes later. All of our documents are scanned into the system as tiff files. They are able to open a multi page tiff file…

We work with a lot of documents in my office. So of the managers use Abode Acrobat to high light areas of a document, so they can use it for training purposes later. All of our documents are scanned into the system as tiff files. They are able to open a multi page tiff file…