Search results for query: *

select pr.parent_id, count(pr.id) as cnt from pr group by pr.parent_id

Thanks LB. I did so, but it looks like they are only considering Parent records that have children and are ignoring the rest (those that have none). I'm not sure what I'm doing wrong.....Any advice?

Thanks K, What's "table.paemrt"?

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!

It's not that the record is null, it's that no records meet the formula's criteria to be placed into the "Opened" bucket. I still want to display the Group Header ("Opened")even though there are no currently records in that Group.

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...

Thanks for the response. Yes, the same DSN exists on the RAS server. The same SR exists on other reports and is working as expected. What may cause the same SR to work with one report and not the other. All of the connection information and links are the same. Is there any limitation as...

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 Turkbear, yes it does. The main report and subreports are all pulling the info from the same data source. I should mention that we just upgraded to Crystal 9 RAS and did not have these problems prior to the upgrade. Below is an additional error message I get...

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...

The formula works perfectly, thank you very much lbass!!!

I should clarify that record_activity_type IN (139) is the id for the activity that I would like to base my conditional suppress upon.

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...

Thanks Dave, I see u2fcr.dll, but what directory should it be in? Currently, it's just in the default installation dir: %\CR9_ENENT\ProgramF\CommonFi\Crystal\20\bin Is that sufficient??

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...

In a possibly related issue, I recieve the following error message when trying to export the report in Crystal Reports format: CRAXDT Error Occured on Server, -2147190548: Error in File ??: Missing or out-of-date export DLL. Any ideas? Thanks!

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...