comparing variable to a field with comma-separated values
<b><i>One way</i></b> to do it could be using a condition like this: WHERE (ItemString = @item OR ItemString LIKE @item + ‘,%’ OR ItemString LIKE ‘%,’ + @item + ‘,%’ OR ItemString LIKE ‘%,’ + @item)

View Answer   |  August 14, 2009  2:51 PM
Comma Separated Values, SQL Server 2000, SQL Server development

Crystal Formula – Maximum of a Running Total/Count?
If I am following what you want to do, you’ll need to create a running total just like the one in the detail section, change it to read Maximum, and place it in a group or page footer.

View Answer   |  August 13, 2009  4:47 PM
COUNT, Crystal Count, Crystal Reports

Printing Documents
Well, thsi looks like a problem happening to look of the final document so i think you need to check the page/Document properties coded in DOC1 tool. For instance, if the page orientation set in DOC1 tool is landscape and size is A4 and you are trying to print in a potrait A3 sheet, results [...]

View Answer   |  August 13, 2009  11:06 AM
COBOL, DOC1, JCL

runtime error “server has not yet been opened”
Bliever 15 pts. | Aug 12 2009 8:54PM GMT Good question. I found the answer and it was due to the fact that I was pointing to the wrong kind of connection. I changed to OLEDB for Jet 4.0 and it worked fine. thanks

View Answer   |  August 12, 2009  9:04 PM
Crystal IDE, Crystal Reports, Crystal Reports 8.5, Crystal Reports error messages

Export tabels from SQL Server to iSeries
You can use FTP First CRTPF FILE(YOURLIB/FTPIN) RCDLEN(80) Use DBU or UPDDTA put in the FTP commands to signon to the server and retrieve the file Set up a CLP that does CRTPF FILE(QTEMP/FTPIN) RCDLEN(80) OVRDBF FILE(INPUT) TOFILE(YOURLIB/FTPIN) OVRDBF FILE(OUTPUT) TOFILE(QTEMP/FTPOUT) FTP (HOSTNAME) Now you will have your flle and you can do whatever you [...]

View Answer   |  August 12, 2009  6:14 PM
Export, iSeries programming commands, SQL

jasper server with sql server
get ur answer through jasper server.com,u can clear it ESH says: If you use jtds as your db driver, yes. It can be used in iReport or on Jasper server. JDBC driver class: net.sourceforge.jtds.jdbc.Driver JDBC URL: jdbc:jtds:sqlserver://serverName/dbName;instance=

View Answer   |  August 11, 2009  4:04 PM
JasperServer, JDBC, SQL Server

can I use accdb with Crystal report 8.0?
You should be able to access the database through Crystal by creating a connection via administrative tools in you windows control pannel and then creating and ODBC database connection to the database(you will need to do this for ever user who needs to run any reports over you access DB)

View Answer   |  August 11, 2009  3:55 PM
ACCDB, Crystal Reports, Crystal Reports 8

Is there a way of checking remote PCs to see how much of the hard drive is taken up with MS Office documents?
WinDirStat can be downloaded for free from <a href=”http://www.snapfiles.com/php/download.php?id=108811&a=7125275&tag=637756&loc=2″>here</a> WinDirStat is a visual drive space manager that uses treemaps to represent each file as a colored rectangle, allowing you to instantly visualize file distribution across an entire drive or folder. In addition, the file types are color coded and can be clicked to reveal file [...]

View Answer   |  August 10, 2009  6:42 PM
Backup and recovery software, hard disk storage, Microsoft Office, Remote PCs, Remote users, Reports

Crystal Reports grouping by date
When you say be weekly intervals, do you mean Sunday – Saturday every week? If I’m following then you need to create a formula that finds the first and last days of the week and then group on that. I used Sunday – Saturday. <pre> datevar Sunday; datevar Saturday; stringvar week; sunday := dateserial(year({LEASED.STARTDT}),month({LEASED.STARTDT}),day({LEASED.STARTDT})-((datepart(“w”,{LEASED.STARTDT},1)))+1); saturday:=dateserial(year({LEASED.STARTDT}),month({LEASED.STARTDT}),day({LEASED.STARTDT})+(7-((datepart(“w”,{LEASED.STARTDT},1))))); [...]

View Answer   |  August 7, 2009  3:42 PM
Crystal Reports

Is synchronous replication possible between EMC DMX4 and EMC CLARiiON CX3-80?
There isn’t any way to use the in-array MirrorView/Synchronous or SRDF/Synchronous between Sym and Clariion. To accomplish this you would need to use some sort of host based or SAN based solution instead. You might consider using open replicator.

View Answer   |  August 6, 2009  7:25 PM
Asynchronous replication, Data Replication, EMC, EMC CLARiiON, EMC CLARiiON CX3, EMC CLARiiON CX3-80, EMC DMX-4, EMC MirrorView, EMC Symmetrix DMX-4, MirrorView, Replication, Synchronous replication

Crystal report Crosstab
Create a year formula for the field you wish to test year({database.field}). In the cross tab expert put that formula in the columns area. Hope that helps. If not, please provide a little more detail and I’ll try again.

View Answer   |  August 6, 2009  3:43 PM
Crystal Reports, Crystal Reports Crosstabs, Crystal Reports Projects

In DB2 when a select statement is executed, it is taking lot of time and the table is being locked.
DB/2 on what platform? Locking occurs because of commitment level setting commitment level depends on the environment you are issuing the Select from. Summary: Need to know Platform? Need to know Programming tool that select is issued from? Phil Hi, I’m using DB2 in AIX environment. That is what I can give u the details [...]

View Answer   |  August 5, 2009  8:01 PM
DB2, DB2 query, SELECT statement

Select printer from CRViewer in VB 6.0 and Crystal Reports 8.0
FIXING CRYSTAL VERSION 2 Search for these files on the local machine Crviewer.dll, swebrs.dll, sviewhlp.dll If they exist unregister them this way: on (WIN2K) START/RUN/regsvr32 /u c:program filesSeagate softwareviewerscrviewer.dll Repeat for each file then rename them to .old Copy the three files from a valid location (CD, me, etc) And Register them this way: on [...]

View Answer   |  August 5, 2009  2:14 PM
CRViewer, Crystal Reports, Crystal Reports 8, Crystal Reports printing, VB 6, VB 6.0, Visual Basic, Visual Basic 6

What’s a good, simple reliable way to log errors for later investigation?
If you’re using MONMSG, you can email the error to specific support people using the SNDDST command. They in turn can setup their cell phone to receive these emails immediately.

View Answer   |  August 4, 2009  10:25 PM
DB2, DB2 error logs, i5, Joblogs, Logging Operators

tablespace
in DB2, ALTER TABLESPACE … TRACKMOD yes/no would become effective immediately.

View Answer   |  August 3, 2009  4:15 PM
DB2, TABLESPACES

Automatic transfer of AS400 output file to PC folder
To my knowledge there is no way to automatically convert a spool file to excel using CL. You would need to convert the program that creates the spool file so that it creates the excel sheet instead of the spool file. I do this quite frequently and the users love it. See this thread for [...]

View Answer   |  August 3, 2009  4:10 PM
AS/400 output files, AS/400 Transfer, DB2

CPYTOIMPF
Please show us the command you are issuing and the error message. You may need to dspjoblog to see the complete error messages. Phil

View Answer   |  August 3, 2009  1:53 PM
AS/400 error messages, CPYTOIMPF, DB2, Error number 3025

Crystal Reports Formula
Will the name of the town always follow a – two letter abbreviation and another – ? If that is the case you could just look for the second dash in the field and pull everything after that.

View Answer   |  July 31, 2009  3:27 PM
Crystal Reports

Uploading an image for use in Optio
We are running a well aged version of Optio. There is a PC program called PCEXPRESS from Optio which converts the signiture so that be used on the AS/400.

View Answer   |  July 30, 2009  5:43 PM
AS/400, Optio Software

Formula setup on the crystal report
I’m assuming you are creating running totals for the sums of the columns. So then just create a formula that has <pre> if {sum column1} <> {sum column2} then “Error Message” </pre> Not sure if that answers your question.

View Answer   |  July 30, 2009  4:46 PM
Crystal Reports, Crystal Reports formulas