Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: GMAN33
  • Content: Threads
  • Order by date
  1. GMAN33

    Suppress Group and Details Based off Detail Records

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

    Almost duplicates?

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

    Splitting a field

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

    Exporting to Excel

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

    Business Objects Server XI Migration

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

    Previous/Next Record Selection

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

    Wildcard use

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

    Page Number in Report Header

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

    Using Table Selection in Parameter

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

    Cross-Tab Formatting Question

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

    Missing Pages

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

    Oracle Journal Tables - Oracle Clinical

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

    FM7v3 Pro Access Issues

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

    Last Part of String

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

    Parameter Typing

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

    SAS Through VPN

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

    CR XI - Windows 2000 Pro

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

    CR XI Windows 2000 Pro

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

    Missing documents report

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

    Outlook 2000 and screenshots

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

Part and Inventory Search

Back
Top