Search results for query: *

Okay, I am back to this report. I have everything working correctly (beats and units in the right order) and now I realize that I need to include two fields in the row of the cross-tab. The unit could have been assisting unit #1 or #2. Which are two seperate fields in the table. I am using a...

Thanks to everyone, I tried all three and they all three worked.

Thanks for all your effort! It worked!!!

Thanks, that worked. Sorry you have to be so specific with me. That got rid of the , but I still have the .00 I tried putting in another replace with the .00, but I keep getting an error. This is what I have now. stringvar goodNumber:=...

I have tried this formula replace(totext({VW_PERSONNEL.ADDR_NUM}),",",""); {VW_PERSONNEL.ADDR_NUM} & " " + {VW_PERSONNEL.ADDR_STREET} it is still returning 1,547.00. Can you see what I am doing wrong? Thanks Amanda

I am beginning to think there is something wrong with my installation of Crystal. First of all (my fault) my crosstab is not in the pageheader, but in the report header. I tried to do what you said, but when I go to section expert, the arrows move my highlight up/down, not the highlighted line...

I would like to have the Title of the report print on every page. I have created a cross-tab report and the cross-tab is in the header section.. Thanks Amanda

LB You are right. I did mean phone type and that works just fine. I did the first suggestion (on your last post)because we can have duplicate names, created the group, changed the group on the report and refreshed data. Got an error at that point that says "A string can be at most 254...

THANKS LB.. That worked! I continue to need help though. Now that I have the phone numbers the way I want, the order of the report is not correct. It should be in alphabetical order by name. I have in the record sort order the name and then the phone as the fields to sort by, but the 1st line...

Okay everyone I finally got back to my report and I did what lbass suggested. It worked with only one glich. Here is a sample of the data: rec 1 H (317)555-1211, W (317) 555-8459, P (317) 555-9898 rec 2 H (317)555-1234, C (317) 555-7689, P (317) 555-1267 rec 3 P (317)555-7845, H (317) 555-8467...

In the oracle table for the phone numbers, each record has only one phone number in it with the type of phone such as H for Home, W for Work. I think the table should have been set up to have all the phone numbers in one record, but I didn't set up the table. The way it is now there could be up...

Thanks for the reply, but I am sorry to report that I could't get it to work. I am sure it is me not doing what I should be doing. I am just starting to use Crystal. I did group by ID number (and yes, there is one personnel record for two or three phone number records, ie; work, home...

I have two oracle personnel files, linked by ID number. The 1st file has person info, the 2nd has work and home phone numbers. I want to print everyone's info all on 1 line with both work and home phone. I am getting two lines for each person. Thanks Amanda

Correction: I am creating a cross-tab using unit number as the rows and beats as the columns. My problem is, beat "ecp" in the file, I want it to be added to beat "17" on the report, "hqa" in the file, I want to be added to beat 18 on the report, etc. The file...

I am creating a cross-tab using unit number as the rows and beats as the columns. My problem is, beat "ecp" in the file, I want it to be "17" on the report, "hqa" in the file, I want to be 18 on the report, etc. The file includes beats 17 and 18. I know that I need...

I am creating a cross-tab using unit number as the rows and beats as the columns. My problem is, beat "ecp" in the file, I want it to be "17" on the report, "hqa" in the file, I want to be 18 on the report. The file includes beats 17 and 18. I know that I need to...

I am creating a cross-tab using unit number as the rows and beats as the columns. My problem is, beat "ecp" in the file, I want it to be "17" on the report, "hqa" in the file, I want to be 18 on the report, etc. The file includes beats 17 and 18. I know that I need...

I tried both ways. The Right("000" +{NumericText.NumericText},3)gave me a weird result. I then tried the specified order and it seems to be working. Thanks for the help guys. This is a great site for me (a cobol programmer working my way into the PC world). Amanda

I said, in error, that this worked. It didn't and the reason being I didn't realize the field does not contain numeric data. The "beat" field contains 1, 2, 3, and so on, but there is also HDQ, CEN, etc. I would like for the numbers to appear first in the cross tab in numberic...

Thanks Bob. I have done that and it worked!