Recent content by ckiklas

Hey Matt, Just out of curiosity, did you install Crystal over terminal services? Also, what version of Crystal are we talking, 8.5? This is why I ask: We had similar problems before version 10 (actually, lots of little problems), but we had installed crystal over TS. We uninstalled all...

EMax1, you would pu the formula lbass suggested in the Select Expert. That's the hand holding the three marbles, or you can go to: report > Select Expert Once there, click on "Show Formula" and add the formula there. -chris.

Hi Greg, I would use: {iAgentPerformanceStat.Timestamp} in LastFullMonth That should do it for you. But if you really want to figure out the exact first and last date, you should use the DateDiff function in Crystal. Let me know if you want me to write that out for you. -chris.

In CR, try using the Date() function instead of Left. Let Crystal worry about where the date is actually located in the field. so: Date(WhateverYourDateTimeFieldIs) should do it

Romspree has a good point. You might want to add some error trapping in your formula to make sure you don't get a division by zero result or anything else fishy. Check to make sure the output is an actual number. If it didn't work yesterday, but works this morning and you didn't do anything...

It's not Crystal that doesn't like the query, it's Oracle. When reading errors, always read from the right to the left (bottom to top). When read that way, the first error you come to is the root error. In your case, the error you should be concerned with is: ORa-00936: missing expression...

It's not very elegant, but you could do this with a supression formula instead of in the select expert. Return all data, and then supress the data greater that whatever your parameter was.

There is a tool from Apos (Object Manager) that will allow you to change the login information for multiple reports all at once. www.apons.on.ca

If my users were going to schedule this report (as opposed to viewing it), I would build the report so that the dates were relative, ie Yesterday, Today, Last Full Week, Last Month, etc. That way, when scheduled, the user selects which relative date to use on the schedule.

Try using the DateDiff function in CR. That will calculate the number of weeks for you. Or days, or weeks, or minutes, or whatever.

I am very new to DB2...I can do this in Oracle or SQL Server, but can't quite get the syntax right for DB2. I need to create a new field based on two other fields. Field1 = Numeric Field2 = Alpha (but always contains numbers) NewField = Numberic ( Field1 and Field2 together) I tried using...

We have also been using the APOS tool, and our developers think it is the best thing we have ever added to CE.