Search results for query: *

Thank you so much, I will try your suggestion this afternoon. The OR folks tell me there won't be numbers in the 'codes' (for now there aren't, at least in prod... test is a whole other animal)

Thanks all, Brian, yes I'm recreating the preadmit testing record data for HSM Ken you are correct, I was going to say the same, there could be too many. I just confirmed that there will be changes to the list. My concern is if they make a change to the legend list it won't pull the data...

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

Well, that has helped but it's still doing it in some places.

Snap to grid is already turned off, but I removed the guides... great idea. I'll put them back in now that it's all done and see it makes a difference.

Assuming Mondays are the first day of the week, something like this should work: {yourtable.datefield} in {?StartDate} to {?StopDate} and DayOfWeek ({casemain.actcase_start_datetime}) <> 1

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

Thanks so much lbass, that worked.

The Group Sort Expert is greyed out... I hadn't even noticed that. What can I do to make it not greyed out? Report options for both have database server is case-insensitve checked. Here's a link to a pdf that shows two examples of the output, one from each campus...

what is the formula you are using and what version of Cystal?

You'll see a mix of upper and lower case, it's supposed to be that way (a drug safety protocol of some kind I think). I thought it could have something to do with that since it does seem to be those that are sorting wrong. med list on Page 1, (Part 1 of the form) CELEBREX* FOLIC ACID...

I'll start with the allergies explanation, sorry, I should have said Part 1 and Part 2, instead of Page 1 and 2, since they both can span more than one page, and to save paper they only want the allergies there once per Part, not every page. I'm all ears if there is a better way. The multiple...

Can you post the text in your selection criteria?

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

What version of Business Objects are you on?

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

Well, not sure if you've already got an answer since this thread is a few months old, but one thing you can try is try create an SQL Expression Field, call it UserName, then just type SYSTEM_USER. That has worked for me. Not so great if the report runs through a viewer though, then it shows...

I recently had a similar issue, where I needed version 8.5. You can buy old versions directly from Business Object, so you may want to consider doing that so you have a developer copy for yourself. I imagine that the cost of the consultant would have been higher than buying it. I too had the...

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

The account number is in a subreport. All accounts will always have an A or a W. The 0s are all facility A, and will eventually purge out (within 6 months). Here's what the report looks like: Report Header - null Page Header A - subreport of global address(now not applicable) Page Header...