Recent content by chris35

I am running a CR11 on BOXI enterprise server that fails due to an "Invalid argument for database" error. When I run this report from CR on my desktop, it runs fine. I am using a .csv for the main datasource that is living on the enterprise server and I have two tables linked in that go directly...

I am running CE9 and want to schedule a number of reports to run off a scheduled event, which is the successful completion of another report. I have been successful with a trial run of a few reports, but before I proceed any further, I need to know if there is an inherent limit to the number of...

Thanks LB, that did the trick! CL

I am using CR9 and am calculating a turn around time and then diplaying it in Hrs & Mins. Here is the formula: datetimevar CDT:={View.CallbackDateODBC}+{View.CallbackTimeODBC}; datetimevar PDT:={View.PhoneDateODBC}+{View.PhoneTimeODBC}; numbervar callphone:= DateDiff ("n",CDT,PDT); if...

We have numerous reports that go directly to the data base. But running most of our reports off a query minimizes the time that the database is accessed directly and saves system resources. I agree that permissions on the server seems to be the issue here. Thanks

Okay, let me clarify. I am talking about a SQL designer query. We were informed by our vendor that "CE does not support the process of scheduling queries (SQL Design queries) and using the resulting .qry file as a data source for subsequent scheduled Crystal reports." So....we are replacing the...

Hello, we are trying to migrate from Info 7.5 (CR8) to CE9. We currently run about 100 reports off a daily query run. Since CE9 does not support queries, we are moving to using a daily report that saves to a CSV file and then run our reports off that file. Everything works fine up to the point...

Not sure if this is possible or not, but I am stumped. I am pulling hospital lab data and the data presents as multiple copies of records, like so: AN BillCode S10295 TD S10295 TD S10295 TD S10301 MDX S10301 MDX I have a detail...

Hope someone can help. I am using CR 8.0. I work in a hospital and need to calculate a ratio between two different lab test results. I have a result for XBUN and for XCRE and need to calculate the XBUN/XCRE ratio. the problem is this, for each patient sample, there are two detail records...

I am using Info 7.5. I am trying to set up a monthly query with a date parameter and schedule it to run with a date Prompt for the last full month. We have daily queries that run great with a "Yesterday" prompt. What are the available choices for Prompts? Does it depend on the d/base? And is...

I am using Crystal 8/Info 7.5. Is there a way to create report templates that save items in the report header/footer for use in other reports? Rather than building the header for each new report I build, I would like to just have the items there for each one. For eaxmple, certain text objects...

lbass---Thanks a bunch. you were correct about what I was working with and the formulas worked great!!!

Sorry I did not provide enough info. 'Test code' is any of hundreds of tests that can be ordered on one patient sample. A record would have multiple test codes ordered. I want to collect those records that have all 4 tests (amy,lips,sgot, and sgpt) ordered. Does that help I hope?

I feel like a dunce, but I am drawing a blank right now. How do I select for a list of certain items and is inclusive of records that have all the items and not just some? EX: {field.testcode} = "Amy, Lips, SGOT, and SGPT", inclusively. Not just one or more the above list. Thanks.

I am working on a report that counts fields per each group member, but only want to grand total certain types in the field. Example: the field is SpclBillCode and it only has 4 possible answers. I need to show how many times two of these answers are ordered per physician and then grand total...