Convert string to number
In Cyrstal reports, how do i convert a string to a number

Answer Question   |  June 19, 2012  1:15 PM
Crystal Reports, Crystal Reports Formatting

Export error
This wizard will close because it encountered the following error: Additional information: Error HRESULT E_FAIL has been returned from a call to a COM component (Microsoft SqlServer.DTSRuntimeWrap) Any idea why i am getting this error? Thanks in advance. Raj.

Answer Question   |  June 18, 2012  1:48 PM
Export utility

Crystal Reports- displaying calculations for date range prior to date search parameter
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 [...]

Answer Question   |  June 6, 2012  2:57 PM
Crystal Reports XI

Crystal 8.5 export trouble
My Application is developed in Vb6,Sqlserver2003 and crystal report 8.5.this application is well run on windows XP,Server2003 etc. but now we are Shift our OS to Server 2008 R2 32 bit. application running well but when I trying to export reprot(i.e click on export button of the crystal report) suddenly application going to crash.I cant [...]

Answer Question   |  June 5, 2012  9:48 AM
Crystal Reports 8.5, SQL Server 2003

X Position in Crystal Reports
How to extract the X Position Adjustment of a text object (PH) in Crystal Reports Programmatically. I know Size and Positon Window is not accessible in .net environment but you can access it in Crystal Reports.  I am tring to extract the formula behind the X Position Adjustment inside the textbox.. Any help would be of [...]

Answer Question   |  May 29, 2012  5:03 PM
.NET, Crystal Reports

How to view Crystal Reports in Internet Explorer?
when i deploy my asp.net website on windows 7 with oracle 11g database in backend.I am using sap crystal report version 13.0.2000.0 It gives error as Unsupported Operation. A document processed by the JRC engine cannot be opened in the C++ stack.Description: An unhandled exception occurred during the execution of the current web request. Please [...]

Answer Question   |  May 24, 2012  6:01 AM
Crystal Reports, Oracle 11g

Crystal Reports CSV with quotes inside string
I need to export a CR XI report to csv. Some of the fields allow users to use double quotes to indicate inches. When exported to CSV I get something like this: “Andy”, 4685, “requires 5″ by 2″ silver plate”, 1132 According to CSV standard it should be: “Andy”, 4685, “requires 5″” by 2″” silver [...]

Answer Question   |  May 24, 2012  4:26 PM
Crystal Report formula, Crystal Report XI, CSV

Can AutoCAD edit .cal drawings?
I need to edit existing drawings that have been already scanned into our drawing vault, and some of them are saved as .cal file format. Can AutoCAD convert these drawings and open them for editing? There are a lot of them that need to be edited, so I am looking for the most expeditious way [...]

Answer Question   |  May 18, 2012  8:14 PM
AutoCAD, converting data files, edit, File conversion programs, File formats

TCP Ports
Could you let me know which TCP ports are required to be open for Crystal Reports 2008 please? On the client pc it is installed on.

Answer Question   |  May 22, 2012  10:30 AM
Crystal Reports 2008, TCP Ports

Formula Workshop gives me an error but no description of the error…
Trying to run a report in Crystal Reports XI, and it pops up the Formula Workshop with the Error section populated with one of the formulas, but there’s absolutely no text anywhere telling me why it threw the error.  Is there a way to find out what’s wrong?

Answer Question   |  May 14, 2012  4:06 PM
Crystal Report XI, Crystal Reports form

report could not be opened for writing
I need help with how to fix the error “This report could not be opened for writing. Any changes must be saved to a new file” when opening the report (did not make changes).

Answer Question   |  May 9, 2012  1:00 PM
Crystal Report error messages, Crystal Report XI

Processing limit was reached
One of our customer Production server has Crystal Reports server 2008 SP1 installed along with Crystal Reports server Embedded 2008.This server has total of 9 RAS services running. There reports are generated and refreshed through a Crystal DOTNET API viewer. The issue with one particular report is when performing Generate/Refresh through the Crystal Viewer, once the [...]

Answer Question   |  May 8, 2012  8:55 AM
Crystal Reports 2008, RAS

Secure FTP for one User
I’m in the process of setting up Secure FTP over SSL for a Single User Profile “TESTFTP”.If i do enable of SSL FTP and assign certficates to FTP client from DCM. Everyone has to follow SSL ftp.Could anybody assist me in setting up SSL ftp for ONLY one user.? Currently no SSL is enabled in [...]

Answer Question   |  June 22, 2012  6:47 AM
AS/400, Data, DCM, FTP, iSeries, SSL, User profiles

Select Criteria
I want to pull data from Item Descriptions utilizing only certain words within the description; i.e., Vesuvio Beige Hand Board. I want to pull all records with the words “Hand Board” in the description and I’m having trouble getting that to happen.  I’ve tried “is like”, “in” and everything else I can think of, but [...]

Answer Question   |  April 20, 2012  7:19 PM
Crystal Reports 8, Crystal Reports Database

Microsoft Visual Basic error
I was using a floor plan sent to me by an architect, and after I opened it I started getting a notice every time I opened any other drawing, either mine or an architect’s. I get this warning box that says: !Microsoft Visual Basic Object library invalid of contains references to object definitions that could [...]

Answer Question   |  April 17, 2012  12:13 PM
Autocad 2007, Microsoft Visual Basic

Crystal crosstab formulas
When I create a crosstab report using general ledger debits and credits, I can’t get the formula to subtract the credits from the debits. Can you tell me what formula I can use to fix this issue?

Answer Question   |  April 17, 2012  7:41 PM
Crystal Report formula, Crystal Reports 10

Crystal Report 2008
We recently moved our report portal from Crystal Xi to Crystal 2008. Now the embedded images on the reports only display a text of “Image”. When I send the report to the printer the Image will then display. Does anyone have any idea how to get the image to display on the screen?

Answer Question   |  April 12, 2012  4:35 PM
Crystal Reports 2008, Crystal Reports XI

Any CRM not based on marketing?
I need a simple CRM to assign incoming emails to my staff, and to view their communications between each other. Shocked that I can not find any such thing available! Somebody pls help!

Answer Question   |  April 1, 2012  9:13 PM
CRM, Microsoft Dynamics

I would like to run a report on AS/400 to indentify which DB2 tables to reorg.
Hi,  New to iSeries. I need to identify which tables need to be reorged. From manual I see that if I do a DSPFD FILE(xxx/*ALL) TYPE(MBRLIST). I get a report where the Total deleted records are more than 10% of the total records I should reorg. Is there a report similar from DB2 side a [...]

Answer Question   |  March 23, 2012  9:54 AM
DB2, iSeries, OS/400

What do you think of Microsoft’s new “Metro UI” for business applications?
Microsoft’s unveiled a new “Metro-ized” UI for business applications, recently showing off an updated version of ERP software Dynamics GP. Do you think the move to better looking interfaces is a step in the right direction, or simply dumbing now software that has to be complex because it does complex operations?

Answer Question   |  April 9, 2012  1:38 PM
Dynamics GP, ERP, Microsoft, Windows, Windows Metro