DataManagement

Business Intelligence for Financial Module

I'm looking for a BI demo for EBS Financial Modules (AR, AP, GL, etc)

can not find database dll

How to fix "can not find database dll"

runtime error "server has not yet been opened"

Runs in Crystal IDE but not when run from VB. Access DB. Have 8 other reports using same code which work.

Crystal report Crosstab

I want to run the report for 2007,2008 and 2009 how to display this three year in the top by month

Crystal 8 & SQL problem

I created 80+ reports for the company intranet and they worked great. At the time the ODBC's were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet...

COM Class DLL in Virtual Directory

Hi all, I created a COM Class DLL and was able to run my application on local. However, when I shifted everything to the virtual directory, it started giving problem. Particularly problems like, "Retrieving the COM class factory for component with CLSID {XXXX} failed due to the following error:...

What's a good, simple reliable way to log errors for later investigation?

I'm doing new work in an old old system. It's built with a bit of everything you could use from System/34 onwards - except maybe WSU. Naturally, as I Put together new functions, I test return codes, record locks, database integrity as I go. Just spent a couple of hours finding out that a...

Build a Data warehouse end to end

Im asked to build a datawarehouse from end to end. I have already worked on datawarehousing projects. I need to prepare a proposal document. How do i prepare a proposal document that explains End-to-end development. Can I get a sample document? Thanks.

More than one level nesting in crystal reports

Hi, **************** Using: Crystal reports XI release 2 Database - DB2 **************** I have three screens(say A,B and C). When I click on an item in A screen then it should display screen B and when I click on an item in screen B then it should display scren C. Eg. screen A -> screen B...

CPYTOIMPF

i am new to as400 and i wanted to transfer file from as400 to pc using CPYTOIPMF as per advised here. BUt i am receiving an error File system error occurred. Error number 3025. whats wrong? thanks

Automatic transfer of AS400 output file to PC folder

Is there a way to automatically transfer an output file to PC folder in an Excel form? My boss want me to create a CL program that every time the output file was created, it automatically convert that output file to Excel(numeric values in comma seperated) in a PC folder. I usually do this...

Refresh/Run SQL

We upgraded to Crystal Reports 2008. Our older version queries appear to work... In the Older Verion all we did is click the lightening blot. Now... we have to go through Database, SQL to run/refresh the query. Isn't there a one click key for to run these queries?

Transform variables in SPSS

I am working with a very big data set in SPSS. I am trying to transform 7 variables into 1. I figured out that the mode would be more represenative than the mean for this particular case but it is not offer in the functions of the "compute variables" option. I don't want to do it by hand. The...

Crystal Reports Formula

I am trying to seperate data in a field. For example the data in my field looks like this: Coldwell Banker Residential - IL - Waukegan...I need to get rid of everything before Waukegan. In other words I want it to display only the town. I can do it with the mid function, however, there is one...

Learning SAS

I am an IT professional and student looking to learn SAS to see if it would be beneficial for my organization. Can anyone recommend a good book for this that includes a CD with a trial version of the software?

Uploading an image for use in Optio

I need to upload a signature file onto our AS400 for use in an Optio layout. Does anyone know what steps I need to do to get the image file into a usable format on the AS400 so Optio can use it? Thanks in advance.

Formula setup on the crystal report

I want to generate error on the report viewer when sum of the specific column is not equal to the sum of the other specific column.How can i solve this?

view data from ODBC to Crystal Reports

i am using Crystal Reports 10 to display data from ODBC. The error "Failed to open rowset. Details:HY000:[UVODBC][1401030] ERROR ID:46 Severity: ERROR Facility: DBCAPERR-UCI.Error. Func: SQLPrepare(DML);State:S1000;Universecode:950088; MSg:[SQL Client][Universe]universe/sql syntax error.unexpected...

Find hidden subreport

How do I quickly find a hidden subreport in Crystal Reports.

Oracle 6i Log in - User-name & Password

What is the user-name and password of Oracle 6i to Log in?