Search results for query: *

Hi All Crystal Reports XI Oracle 10g I receive patient pages for a study and the visits for each subject could have 2 to 20 pages per visit. When a page is received for that visit, it is marked as RECEIVED So data could look like below SUBJ VISIT PAGE RECEIVED 101 1 12 Y 101 1 13 N 120 1 12...

Crystal Reports XI, Oracle 10g We collect and scan documents for patients into our DB. When a patient receives a record, it is marked as being an original "Y" or not an original "N" copy of a form. However, they could receive the same form over and over again until the original is received...

Hi All Crystal Dev XI/Oracle 10 DB/Oracle Native Client connection I have a {subject} field that is like this ABC004-12345-02 I need to trim/split to obtain 04-12345 Any assistance would be greatly appreciated!! Thanks

Hi All Using Crystal Reports Developer XI against Oracle 10 DB. I have a report that contains a couple of groups The way the report is formatted now, looks very nice but they would like it in Excel and not PDF When I export to Excel, the grouped fields repeat multiple times as expected...

Hi All I have BOEXI installed on one server that has a couple hundred reports. My company was acquired and I had to install BOE on another server that resides on this new company's domain. I have access to both servers still but they won't talk to one another What is the process of exporting...

Hi All Using Crystal Reports Developer 11 and Oracle 8 DB I have a report that lists medical events for patient dosages The data in the one table (AE_DOSAGES) looks like this: SEQ NO PATIENT FROM DATE TO DATE 1 ABC 03JAN08 05JAN08 2 ABC 08JAN08...

Hi All CRXI Developer, Oracle 9 DB I have three types of patients with numbers like 02HS1234 04D02 09H2323 I need three separate reports for each of these patients and the data is all in the same table I was able to get the first and second patients by using a record selection like...

Hi All CR XI Developer Oracle 9 DB I have a report header RHa with our company logo and title and then I have RHb with a cross tab in it for summaries of the specific data. This section RHb spans muliple pages. I have the page numbers on the page footer and that works, but it could be 20 of...

CR XI Developer Oracle 9 Oracle Server connection Hi All Not sure if this is possible, but here it goes I work in a clinical environment using an Oracle Database to collect data for clinical drug trials. Each time we create a new study within the DB, it is assigned a three alpha-numeric...

Hi All CR XI I have a crosstab within a header section of the report. Is there a way of splitting the crosstab so that it stays on one page? Almost like wrapping it to the edge of the page Thanks for the help

Hi All CR XI/Oracle 9 DB This is for a doctor's office for a clinical trial. We have a DB table that we enter in individual records the pages that a patient may receive for each visit. Visit 1: Pages 1, 2, 3, 7, 10 Visit 12: Pages 4, 5, 6, 12 They may or may not fill out each page at each...

Hi All CR XI Pro with Oracle 9 DB using Oracle Clinical...if anyone knows what that is ;-) I have an Oracle_Accounts table that lists all users that currently have accounts. I link that to the clinical studies table that will show me what studies they have access to. Now there is also a...

Hi All I walked into the middle of a nightmare ;-) Our HR department is using Filemaker Recruiter. They had it installed on a network share...first mistake because they are sharing it. I believe it became corrupted, however they can still access it one user at a time and other users can no...

Hi All I have a DB field that has data in it like PAGE 01 PAGE 02 PAGE 10 PAGE 121 PAGE 200 I need to get just the number part of this but also eliminate the leading 0 on the data PAGE 01 to PAGE 09 so that I just get 1, 2, 3, etc I am using replace({table.field name},"PAGE 0",""); this...

Hi All Using CRXI Developer and I have a parameter that is used and prior to XI you could start typing in the parameter and it would go right to it. Now in XI, I am finding that if I type in "B", or any letter, it will go to the first choice, but as soon as I type the second letter, it will go...

Hi All We can connect to our servers remotely but when trying to execute a SAS session, it is extremely slow. The SAS software is installed on the server and just the client runs on the enduser PC. To those that work through a VPN, do you the complete installation of SAS installed on each...

Hi All I installed CR XI Enterprise and XI Developer on my W2K Pro machine. I am able to run reports fine through Developer but when publishing them to Enterprise and try to execute them, I get a "Failed to open the connection: Report Name" error. I created the connections through Designer...

Hi All I installed CR XI Enterprise and XI Developer on my W2K Pro machine. I am able to run reports fine through Developer but when publishing them to Enterprise, I get a "Failed to open the connection: Report Name" error. I created the connections through Designer, and not sure what else...

Hi All Tough question to explain but will try I have a group of patients that participate in a clinical trial. They complete a case report form (CRF) that contains information in regards to the trial. As the programmer, I have created the DB that each page of the CRF is called PAGE1, PAGE2...

To All We recently migrated from Lotus Notes to Outlook 2000 and I am having a small problem. When users send me email with screenshots of their desktop, and I have the preview pane open, Outlook takes a good 20 seconds for the email to appear (become readable). Is there anyway of making this...