Search results for query: *

I am not sure exactly how to approach this. I have two tables. customer and order customer has a last contact date I want the average of the top 10 sales within 60 days of the last contact. I can get the top ten sales easily enough with a top ten query for the customer and date range using...

Does anyone know if XML exports are more automated in CE10? They are still only available via URL for 9. Actually if anyone knows if XML is available for 10 at all would be a great help. Lisa

I occasionally receive this error when scheduling reports to email (CE9). In the knowledge base there was an article that this was caused by a missing return in older versions of CE but that it had been fixed by a hotfix. I only get this error occasionally. I think it is an exchange...

Does anyone have any experience on reporting off of Log4J logs? They will be stored within an oracle 9i database, and I have been assured that each bit of data will have its own column. I am just wondering about the log format. Any experience or comments would be appreciated. Thanks in...

using CE 9.0 I have reports which I prefer users schedule, and in one case require that they do. The problem is that there are several parameters that I set on these reports that are set to don't prompt becuase the user should not have the ability to change them. But when they schedule these...

How does anyone handle null checking in custom functions? My functions don't return anything if any of the arguments are null. I would prefer to do the checking withing the custom function in the repository but "isnull" isn't allowed in custom functions? How can I check for null? especially...

I am creating a report that has data from two separate databases so half of a detail line comes from one DB and half from another. I am calculating the difference between one number in the main report and one in the subreport, for around 200,000 records to give some scope feel. I can calculate...

Using Crystal reports 9 and Add command. How do you add a multiple value [Array] parameter and have it sent to the database? Thanks Lisa

I have quite a number of reports that when updating to Crystal 9 from Crystal 8.5 the selection formula no longer passes to the database. The main factor seems to be if there is an "or" in part of the selection formula. Here is an example: {sold.getTime} in datediff("s&quot...

I use URL references to managed reports extensively. I have heard that they will be removing URL reporting from version 10? ARGH! how do other people handle the following situations. I have one report that gives all the basic information about a particular catalog. Since catalog is the...

I have heard that you can tell IIS6 to "run as" IIS 5. I need this for some compatiblity issues. Does anyone know how to do this? Thanks in advance Lisa

Hello all, I have numerous datetimes that are all stored in the database as GMT. I would like to convert these to local time with consideration given for daylight savings time and all that. Does anyone have this worked out already? Any suggestions? Lisa

Hello all, I hope this is the correct forum for my question. I am using standard date arithmetic: END_TIME - START_TIME Which returns an interval datatype. I can't for the life of me figure out how to turn the interval that is returned into seconds as an int (or number I don't care...

I am getting ready to update all my reports from 8.5 to 9.0. Until they are all complete all the users will be using only the 8.5 reports (which may require updates). Does anyone have any experience in running both on the same machine or do I need to req another computer for this transition? Lisa

My users are broken up into two sets of groups. The first set is a security setting and the second set is a function setting. Right now I have to create numberous groups based upon the the two types of groups. For instance sales has three groups: sales X general sales X secure sales X...

Does anyone know if you can apply PGP to reports mailed to users. I don't yet have CE9 up and running so cannot test. Some of the reports they want emailed will be going to external clients that require the data be sent with PGP security. Thanks in advance Lisa

I have done a search but can't seem to find any threads on this. We are currently using the full version of CE8 which we plan to upgrade to CE9 later this year when we have a new server available. Updating before then is problematic. I also was going to uprgrade to CR9 at that time as...

When we shut down CE (8.0) through the CMC, including the web services a problem arises on restart. Starting the webservices (IIS) again through the CMC they will hang in startup. My IT person tells me that they will hang if you try to start them through the services themselves as well. If...

I am using Crystal 8.5 and I need to change the font color of a summarized field in a crosstab depending on the value of a different summarized field in the same crosstab. Each field although "summarized" contains only one value (i.e there is only one data row that meets the...

Hello all, I have an application that uses progress. I would like to report off this application using ODBC and crystal reports. I don't have the installation CD for the app (its software that we lease.. they keep the CD). I can't seem to find anywhere to download the ODBC driver/Progress...