Recent content by GMAN33

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

Thank you both very much!! This appears to have worked!! Have a great one!!

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

That is a BEAUTIFUL thing!!! Thank you very much for the quick response!!! Greatly appreciate it!!!

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

Thank you Dell...is this function available for the base version of BOEXI? I thought from what I read that it was only available in R1 or higher...maybe I read wrong Thanks again

Thank you for the reply So if they do not require to be on the same domain, what would be the correct way of taking it from point a to point b? This is BOE XI base I guess is the name and I do not see an export process only an import process I am not sure the proper way to backup the CMC...

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

Thanks sameer11 - I got the first two to work just find, it is this last one that is still not giving it to me...thank you again for the help

Thanks guys for the replies...but I am sorry if this is confusing. The patient numbers can also be 01HS1234, 02HS1234, 43HS1234, so I think I need to do a string type of formula that looks for the HS, D and S. With the formula I was using above with the '*S*' it was leaving out both the HS and...

Thank you for the reply The patient numbers that I listed could contain thousands of patients with the same format 02HS1234 to 02HS9999 Since they are all in the same field within the same table, I need to have three separate reports for each style of patient formatting like I have above. So...

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