Recent content by rynosims

Thank You dgillz. That is exactly what I was looking for!!

Hi again forum!! My report is finished, but there is one problem. I have a Navy background, and when I pring it out on my B/W laser printer, the background comes out black, and you can't read anything. So, how can I suppress the background just for printing purposes? If I knew the printing...

Thank You. That si exactly what I wanted!!

Is there a way to make Crystal Reports 8 put the info on a set number of pages? For example, I have data for 3 different states, and I want them all to be on a seperate page when displayed on the intenet. How can I have, say, Pennsylvania on page 1, New York on page 2, and Maryland on page 3...

I am using an ODBC data base. I believe that I have found the problem. I think that the only way to pull info from the second table is there has to ba data in the table for ALL records. I was wondering if there is a way around this. The only time I need the info from the second table is when...

Hello forum! I was wondering if any of you could help out a little. I am creating a report (still) for aircraft. I have 8 fields from 1 table (acft_ctrl_sts). All the information I need in my report comes up just fine. When I attempt to add data from another table (arcft_dscrpncy), the only...

I need to add the total of several fields. Here are the database fieldsthat I have: ARCRFT_CNTRL_STS.ARCRFT_STS_CD This field has the following info: FMC NMCMU NMCSU PMCS, etc... ARCRFT_CNTRL_STS.ARCRAFT_TYP This field has the following info: C130E C009A C021A, etc...

Hello, it's me again! I am now trying to create a Cross-Tab that can add several bits of date. I need to ad the total number of aircraft for a particular airfrafe. That is no problem. Now, I need to add the total number of 4 rows in the same cross-tab. It would look something like this...

Thank you all for the information. I finally got it to work. I know a good place to go to for Crystal Reports Info thanks to you guys. I am new to the whole database thing, so I might be asking a few more questions here. I already know a few I want to ask, but I am not quite there yet!!

Okay, but there is more data than just NMCMSA. If I say just TRUE, then anything will turn into DEPOT. Do I make it say if {fieldname} = "NMCMSA" then "DEPOT" else {fieldname} = FMC or else {fieldname} = NMCM Is thet how I could do it?

I tried that, but I get the message "The formula result must be a boolean."

Is there a formula that I can change the displayed value of a field? For instance, I deal with airplanes, and airplane statuses. The Database I use has status code "NMCMSA". I want Crystal Reports do display "DEPOT" anytime that "NMCMSA" would be displayed. The...