Search results for query: *

I'm using Crystal XI Looking to use my array values to look up and return descriptions instead of the codes stored. Here is a sample of the values captured from a multiselect box. Field value: PacerIcddibMurmerPalpAnginaNote My array : Pacer,Icddib,Murmer,Palp,Angina,Note Need to end up...

I have a Crystal 10 report with a lot of lines (both horizontal and vertical). Increasing the zoom to 300% I get them lined up perfectly, and it looks great when it prints. Then I move the report to another server, and my perfectly aligned lines don't look so perfect anymore. This isn't...

Hi all, My report is an electronic version of a form that is partially a carbon copy, for Medication Reconcilliation before surgery. Page 1 - Medications on Admission Page 2 - Medications at Discharge Both Pages are ALMOST the same, but different info is written about the meds. Page 2 is a...

I'm using Crystal 10 and creating a .ttx file. I need for the text qualifiers not to appear in an export. I can't remember how to set the parameters so they don't get sent. Can anyone help me remember? I thought there was an export setting somewhere, but I'm at a complete loss. I hope this...

In this older version of Business Objects that I'm using, how can I determine the primary keys (and foreign key) structures of tables in the Universe? I know that later versions(6.5 and higher?) have a tab in the object properties for keys, but can't find anything like that in my version. I...

Hi all, I'm trying to modify a 'template' report. The report exists (written by someone else) and pretty much needs to remain unchanged except for one thing. We've added a reporting facility, and I need to have the header of the report show either Address A, or Address B. Problem is that the...

Hi all, I'm using BO 5.1.8 Is there a way to print the list of values in my query condition when it's not a user prompt? I'd like to show that list on the report. I know I could just hard code them on the report but I didn't want to have to keep changing it as revisions are necessary...

HI all, I've got a module in Access97 that I'm using to update a graph in Excel for patient registrations (by hour) to an ER by their acuity. In Access I create the graph a few ways for each month (weekdays, weekends, all days)... so I want to put the path of the saved file in the footer. I'm...

Hi all, I've got a database originally written in Access 97 that got converted to Access 2003. Since the rollout of users on our new Citrix environment(Citrix Presentation Server 4.0, with Web Client) is in groups, SOME of the users of the database still have to use the Access 97 version...

I'm using Access 97 and I have a form that's based on a table with an Autonumber field as the primary key. I used the wizard to create buttons for First Record, Previous Record, Next Record, Last Record and New Record. What I'd like to do is when the 'Next Record' button is clicked, have it...

Hi all, I'm using Crytal 6 and Oracle 8 to write a Turnaround Time report for our Lab system. (I'm new to Crystal) I got the elapsed time to stuff to work beautifully and in my testing I hardcoded the date range so I wouldn't have to keep answering the parameters. This is what I used (and...

Hi all, I've got an Oracle Database(Oracle 8) with Date fields that show on the oracle side as DateTime. Then in Crystal(Crytal 6) it's just a date and I can't see the time at all. Does anyone know what I can do to get the time as well? Since my report will be a 'turnaround time' report, not...

Hi all, I am fairly new to Crystal, and I have some reports to write that have to be done in Crystal 6.0. (I've really only used Crytal 8.5) My selection formula is this: {STHISTORY.STHISTORYKEY} > "22000900" and {STHISTORY.STATUS} in ["D","A"] When I run it looking at just they key (for...

I'm using Business Objects 5.1.2 Does anyone know how I can create and object that is the elapsed time between two Date/Time objects? The objects(PCM_AUDIT.AUDIT_START_DT and PCM_AUDIT.AUDIT_END_DT)contain data that looks like this: 10/27/2003 23:28:06 Sometimes the elapsed time is hours...

I'm using Access 97 to store information downloaded from another application. I've got a table of patient results for restraint usage. 'Initiated' is a result, and 'Removed' is a result. What I need to do is figure out how long a patient was in restraints. Since it's possible staff could...

I've got an Access 97 database that's asking for a password when I didn't set one. I did all the password 'hacking' I could figure out. (I figured that was OK since it's my application in the first place). All I got back was a 'garbage' password full of symbols etc. My method was working on...

Hi all, I've got a database I created, that I was in the middle of developing. I didn't put a password on it yet... Shame on me for my laziness in not protecting it for my own convenience. There appears to be a password on it now though... which means one of the users must have done it...

Hi all, I've got two data providers, the first one is a list of people, the second is detail about the same people in the first, but only when they've got certain records. How can I show all the people, but only have the table appear for those who have detail? Ie, Joe Smith Jane Smith...

Hi all, I'm using Access97. I have a form based on a table and a subform based on a query, linked on an account number. Main form: "frmAdmissionForm", Field: "AdmittedFrom" Subform: "frmsubAdmittedFrom", Field: "AdmittedFrom" What I'm trying to do is...

Hi all, We've just upgraded Crystal from 6.0 to 8.0. Every report we open gives us a pop-up box saying: &quot;The remaining text does not appear to be part of the formula&quot;. Could it be a reference to a function is missing? If so, what do I do? Well, regardless... what do I do <grin>...