Search results for query: *

Thanks in advance for reading my question. If I were to consider all the parent records in my database, how may I calculate the Minimum, Maximum, Average and Median number of children records? So for example, if there is a parent record in my database which has 0 (zero) children, I'd like to...

Currently, my years display as follows: 2,006.00 How may I get them to display as 2006 Thanks!

Hello and thanks for taking the time to read my inquiry. I have written a report that groups records according to a formula. The formula puts each record into a status bucket. "Opened" or "Closed", for example. If no records qualify for any one of these buckets, the Group Header (which...

Hello and thanks for taking the time to ready my post. I recently upgraded from Crystal 9 to Crystal 9 RAS. One of my reports is no longer working after the upgrade. When I run the report on my desktop, I receive no errors and the report runs well. When I run the report via a web app using...

Thanks for taking the time to read my question. Crystal RAS v.9 When running a report from my desktop Crystal client, the report runs as expected (no errors, data returned correctly). When I run the report from our web application, I am prompted for the Database Username and Password. The...

Thanks for taking the time to read my question. I'd like to be able to suppress a section on my report if a certain 'approval' activity has not been performed against the record. Please note, there will be many activities performed against any given record. At first I tried to suppress the...

After I generate a single record report on my web app, I recieve the following error message when trying to export a report in Crystal Reports format (all other formats worked fine): CRAXDT Error Occured on Server, -2147190548: Error in File ??: Missing or out-of-date export DLL. Any ideas...

Thanks in advance for taking the time to read my question. Version: Crystal Reports 9 Advanced Edition. When I attempt to e-mail a Crystal Report from our web application I recieve the following error message: "ERROR: The string is non-numeric. -2147191667" I have verified that the SMTP...

Product Version 9.2.2.693 We are using a the parameter ?SPUser to display on the report the name of the user who ran the report from our Web app. When a user with special characters (Cintrón, Juan) runs a report, the value that is returned by SPUser is incorrect (Cintrón, Juan). Does...

Hello and thanks for taking the time to read my question. Backround: I am developing a multiple record report that will return many rows per every Release Number (UDF/unique identifier per every row of info returned). The values in the Release Number field will only numberic characters...

Thanks for taking the time to read my question. What is the correct syntax to conditionally suppress a section of the report depending on whether or not a field is null? Any advice would be greatly appreciated! Thanks!

Hello- Thanks for taking time out of your busy day to read my question. Is is possible to group and sort the main report by a field only available on the sub-report? If so, what's the trick? Your expertise and advice is greatly appreciated! Thanks!

Hello and thanks for taking the time to read my question. Backround: I am developing a multiple record report that will return 1 or 2 rows per every Domain Name (unique identifier). All of the information in each row returned will be identical with the exception of the Status field. The value...

Thanks for taking the time to look at my question. Version 8.5: Backround: I have created two fields (let's call them DelayTime1 and DelayTime2) which calculate the number of days a record is past due by subtracting date_time fields one another. I have tested these fields and they're working...