Search results for query: *

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

I mean simultaneous executions of multiple reports. We have a number of reports that are dependent, yet have a scheduled time as well. As our server goes down fairly frequently, the reports do not queue up if the scheduled time has passed. We would like to make them dependent without having a...

Hello, In the Info Scheduler (v7.5), is there a limit on the number of reports that can run dependent on one query without specifying a specific start time? Thanks for any help.

That's great, but I need to know how to define R1 and R2 first. I need to select for {order.test code} first and then make the {order.result} from that test code equal to R1, same for R2, all in the formula (or another formula that I can reference). Thanks

I work for a hospital and am dealing with test codes and test results. I am wondering how to write a formula that calculates a ratio using data from multiple selected fields. The calculation needs to be "R1/R2 X 10". R1 represents the result from one test code and R2 is the result from...

Thanks Gavin, but we do intend to use the queries for multiple reports. How do we accomplish it? Chris