Search results for query: *

lbass: Thanks so much for you help.

Tried it and got it all to run. Got numbers for #negative that could be meaningful, #Sperm+only and #P30+only just give zeros. I know what I need to do (I think), but am not sure how to do it. LABCASE is kind of the master table. There is only one record per case. ARRESULT will have...

I am getting an error with this running total formula: //{#Sperm+only}: sum({@Sperm+},{ARRESULT.Case Key})>0 and sum({@P30+},{ARRESULT.Case Key})=0 ("The summary/running total field could no be created"). Since the syntax of the next one is the same, I guess it will also error-out...

That looks good and I will give it a try. But to complicate matters, I have to check the value field in the ARRESULT table also. If a test like P30+ has a value of either NULL or "0" then that would count as a negative also. Basically a negative (or not-run) test can be indicated by no...

By filtering and suppressing I have the cases separated and listed the way I need. However, if I do any type of counting (of just the records printed) I also get a count of the suppressed records. Is there anyway to get a summary of just the records printed/showing on the screen?

The way the table is supposed to work is that if the test is not run, there would be no record in the table for that case/test. Let me give a more specific - real world example: If a CASE has items that are tested for semen, the table will be populated with "EXAMSEM" in the ARRESULT.Test...

Using Crystal Reports 8.5 and Oracle Tables..... One of the tables that becomes populated as tests are completed (ARRESULTS) contains fields that relate the tests to a "CASE" (CASE KEY), the test type, the test and the test result (in character form). If there were five test results entered...

Wish there was a way to either cut and paste images or attach files (unless there is and I have not figured out how.....)! Anyway: Cumulative Weekly Cases/Assignments Received CRIM DNA DRUG TOX TOTAL Total 4 2 99 32 4...

Yes, I believe there are cases which span offices (the same case/assignment exists in more then one location). So now comes a problem I have run into before. How do I save the results of my cross tab sums so that I can manually add them?? An example would be great......

Using Crystal Reports 8.5 with Oracle tables..... I have a series of double cross tab reports that essentially do the same thing for different time periods. They count assignments and cases for four offices and four units (4 X 4). The only different between assignments and cases is that there...

When a user enters a Parameter that results in no records (a blank report), how can I create a formula that prints a helpful and/or informative message?

This is what I get trying to connect to any Excel file: ODBC Excel Files no items found Am I doing something wrong? Maybe something needed did not get installed when I installed CR??

I was trying to use CR 8.5 to do some reports using data in a couple Excel spreadsheets in use in our shop and could not seem to find a way to use them directly. Got around this by converting the Excel files to Access files, but I was supprised that I could not just use the .XLS files directly...

(Substr(Table."Field Name",1,254)) Tryed the above as: (Substr("AUDITLOG"."Additional Information",1,254)) and get the following error: ORA-00932 inconsistant datatypes

Lab Case #:C04-03174 Assignment Sequence: 2 Description: Assignment Saved ***Changed Information Follows*** "Lab Code", [CSC] => [CSN] The above is the contents of the memo field in the table{AUDITLOG.Additional Information} that contains key phrases that I would like to look for (like "Lab...

In one of my Oracle tables there is a memo field that is filled in with key phrases when a certain event is triggered. There is also an event code field that is populated when the event occurs, but the codes are too general. I need to be able to pick specific information for the memo field. I...

When you choose "is between" from the Select Expert drop down, does Crystal Report select include the limits in the selection? For example, if I am using two date parameters such as 10/1/2004 and 10/27/2004, will all the records including 10/1 and 10/27 be included?? Or will I get only 10/2...

In CR 8.5 I usually create a series of reports that do the different things I need to happen and string them together as subreports to give me one report (that is transparent to the user). Question: If I edit and change the subreport from the "master" report, does that change the original...

Wonder if there is a registry tweek/change that would (in 8.5) change the default export folder. That buried TEMP directory IS a real pain! Think I'll search my registry.....

Yes, of course I meant 1, 1-1, 2, 2-2, 2-2-2, 3, 22, etc. I will try the formulas tomorrow. Thanks.