Presales business intelligence
I am working in presales from the last 2.5 years, I am not technically strong because I have never done coding, but comfortable in management and business aspects. Can you please suggest any course  in business intelligence which can help me to progress my career?

Answer Question   |  March 28, 2013  5:21 AM
Business Intelligence, Presales business intelligence

Conditional formatting for alternate shading of detail background
How do I create conditional formatting to create alternating grey/white background for data lines?

Answer Question   |  March 26, 2013  1:37 PM
Reports

About AutoCAD 2007 problem
I use AutoCAD 2007. After drawing I save the program as s file and convert image (At first I go to tools then go to display image,then go to save). But when I do this work the image shows as a triangle. How can I possible to save this program as a right position?

Answer Question   |  March 21, 2013  7:39 PM
Autocad 2007, AutoCAD features

SQL insert error in php
When my php executes the db2 insert, I get error 7008. Any ideas what I might try to get it working ? The PF is new with *all public authority and no trigger nor journal. I manually added 1 record via green-screen SQL with the same context as what is assembled in my php. Here’s [...]

Answer Question   |  March 19, 2013  9:20 PM
AS/400, DB2, PHP, SQL

Getting DB2 data into SQL 2008 database
We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged [...]

Answer Question   |  March 20, 2013  7:59 PM
AS/400, DB2, iSeries, SQL 2008

Crystal Reports: Sum by certain date
I need to sum gift amounts based on the specific date a solicitor was assigned to the account.IE: One account has given gifts since 2/25/1999 however the solicitor for this account was not assigned until 5/15/2002. I want to sum all gifts this account has given since 5/15/2002.

Answer Question   |  March 18, 2013  2:16 PM
Crystal Reports, Crystal Reports formulas

Crystal Reports — Add/Remove Recipients
How can I add/remove recipients on existing scheduled jobs without having to recreate the entire job? Thanks

Answer Question   |  March 18, 2013  1:04 PM
Crystal Report, recipients, scheduled reports

Crystal Report
How to generate a Crystal Report report through java by using MS-Access 2003. Steps for generating the report through Java.back end MS-Access2003.

Answer Question   |  March 18, 2013  5:04 AM
Crystal Reports, Java

EDIFACT DESADV
I need a sample template for EDIFACT DESADV to IDOC Delivery05 inbound.

Answer Question   |  March 13, 2013  10:25 AM
iDoc

Crystal Reports XI – Finding records that need to have appointments rescheduled
Hi, I have the following fields to work with: ID #, issue #, meeting #, prior meeting dates, and status. I keep isolating the old records that have already been rescheduled along with the ones that need to be rescheduled. Any ideas would be appreciated. Thanks! Babeas

Answer Question   |  March 11, 2013  12:31 PM
Crystal Reports Record, Crystal Reports XI

AutoCAD 2013
How to micro zoom bigger or smaller a drawing once in the layout space?

Answer Question   |  March 11, 2013  12:56 AM
AutoCAD, AutoCAD 2013

Block Crystal Reports from iSeries access
We have a user who wants to use Crystal Reports to access data on an MS SQL server. She also has access to view limited data on the iSeries using an iSeries application with built-in security. How can we prevent her from accessing data on the iSeries using Crystal Reports. Is there a service we [...]

Answer Question   |  March 11, 2013  12:37 AM
Crystal Reports, iSeries

AS/400…How to batch purchase order entry from an EDI transmission
How can purchase orders received from an EDI transmission be ‘bulk entered’ from a CSV or Excel file into the AS/400?

Answer Question   |  March 8, 2013  10:05 PM
AS/400, EDI, EDI Transactions

Inventory transaction using Crystal Reports Visual and SQL
I have created a report with all parts in our warehouse with part location, qty and transaction dates. Since there are various locations with qty(or no qty) and various transaction dates linked to them, I can not max and get the info I need. I need all parts that have qty (or no qty) in [...]

Answer Question   |  March 7, 2013  3:53 PM
Crystal Reports, SQL

Adding field to Crystal Report, all data disappears
I have a Crystal Report. I have a user defined field. When I add this field to my report, nothing is displayed. What’s the problem?

Answer Question   |  March 5, 2013  4:08 PM
Crystal Reports, Crystal Reports fields

Isolating records for a report
Current Syntax: IsNull ({DISPOSITION.DISPOSITION}) AND {HEARING.OFFICERID}=987 AND {HEARING.HEARING_DATE}<CurrentDate I am trying to isolate appeals that need to be rescheduled. They can be rescheduled multiple times, and I end up with a lot of appeals in my results that have already been rescheduled. Any ideas would be greatly appreciated. This will allow us to go paperless [...]

Answer Question   |  March 4, 2013  4:26 PM
Crystal Reports 11, Crystal Reports Record

Activities in the sequence of occurrence in a MDM program
Arrange following activities in the sequence of occurrence in a MDM program: A) Design logical MDM model B) Understand source and target systems C) Understand organization structure D) Perform data profiling A. C,B,D,A B. C,B,A,D C. D,A,C,B D. None of above

Answer Question   |  March 4, 2013  10:17 AM
MDM, MDM program

syndication means in MDM
What is syndication means in MDM

Answer Question   |  March 3, 2013  10:15 AM
MDM

SAP Transaction Codes
The following transaction codes have disappeared from our PI environment.  They are in the ERP environment.   CG3Y   CG3z   How could this happen?

Answer Question   |  March 1, 2013  5:37 PM
ERP, SAP 6.0, SAP Transaction Codes

gentran, 856, BSN04, DTM03
Usually DTM03 automatically changes to match BSN04. What would cause DTM03 to be left at the default time? And what, if anything, can be done to fix this?

Answer Question   |  March 1, 2013  5:27 PM
BSN04, DTM03, Gentran