Search results for query: *

Using a simple formula with unexpected results: 2*{#SD} {#SD}= 0.01, so 2*0.01 should equal 0.02, but returning 0.03 (?) I am guessing this has to do with the calculation considering than the number of displayed decimal places, but even if I increase the field to show four decimal places, the...

I am building a simple report that uses a left outer join to link instrument table (bu_t) to result table (rslt_pat_t). I am not getting the expected results. I expect to get every instrument regardless of whether there are results assoicated with that instrument or not. I am only getting...

I am trying to clean up a database where many components of address were entered into one field. The field contains CITY PROVINCE POSTAL CODE. The city may be any number of characters, the province is always 2 letters and the postal code 6. I was able to break out the province and postal code...

Please note: I am NOT familiar with VBA so any replies please talk as much as possible in layman terminology. Thank you! [dazed] I have created a simple form to add data to a table. I have added two buttons, a "next" button and a "exit" button. When a user tries to enter a duplicate value in...

This is such a minor problem but so frustrating. I am working on a new workstation and on this workstation I cannot select a field or text object by simply clicking on it and highlighting it. The fields/text objects do not highlight and instead the cursor, as soon as you move it over the...

I have a simple report in which instrument serial numbers are listed if they meet a certain criteria. 501 numbers are listed from a much longer list. I then added a table which has results for these instruments linked by the serial number. I used a left outer join. It was my understanding...

I suspect what I am trying to achieve may have to do with how I link tables, but I am very weak on this topic. I have an Operator table, a table for Patient_results and a table for Control_results. Operator ID is the field linking the Operator table to the Patient table and the operator...

My reports are set up on landscape. When you call a print preview, they appear landscape on the screen. When you actually print them, they print portrait and then on the screen they have reverted to portrait, so I need to go into page setup and change to landscape before they print properly...

I have inserted a new group in a report. The information that appeared in the Report Header should now be in the Group Header and print at the beginning of each group. However, I would like the Page Header to appear under the Group Header, not above it. How can I acheive this? Thanks in advance.

I created several reports in Crystal Report ver 10. We have been upgraded to CR ver 11.0.0.895. When I open the reports I get the message "This report uses an invalid printer. The default printer will be used instead". The printer we had when these reports were built is no longer available...

How can I request that a report always pulls data for the past 12 months from the data generated? I would like the report to tabulate data on the previous 365 days, or last full year each time the report is called but cannot find a function that seems to do this. I am using version 10.0.0.533...

I have a report that has three sub-reports. Each detail line in the main report shows operator information based on operators selected by specified site parameters. Each of the three subreport fields contains a count of work done for a specified period of time. I would like to have a...

I have a formula that, if the Count is null (no records) the formula should regard this as zero. If the count is not Null then the formula should use the count value. I would like to use: if IsNull (Count ({rslt_qc_t.rslt_type_id}))then "0" else Count ({rslt_qc_t.rslt_type_id}) however, the...

I am using the DateDiff function to calculate the number of months a report spans. I would expect, for example, that a report that spans from January 1,2004 to December 31, 2004 would return with a count of 12 months, but it is returning 11 months. Please advise what I may be overlooking...

I have found other threads discussing similar topics, but cannot seem to extract the solution I need from them so here is my problem: My main report is based on operator data. I have inserted two subreports so far, and will be adding more, that within themselves look at activity for the same...

I have a field on a table that consists of lastname, firstname. There are over 20,000 names listed in this table. Some names appear several times in the table. I would like to create a parameter field that allows the user to start typing in the last name and to select the appropriate name from...