Search results for query: *

Thanks for the advice. I'm going to ask for a few more dollars.

I quit my old job (sql, crystal reports, access, content management, database etc.) in July. I now have a new job. Recently I've been contacted by employer to be a consultant. They want to pay me at the same rate I was being paid which was $27. They also want me to come in on evenings and...

There is only one date field. The database doesn't identify parent vs. child. The only way to identify the parent vs. child is by the app (US main app) and the type. The parent & children appd always have the same type (UF).

Thank you for the response. I tried to solution and it works however, I made an error in my initial question to you. I apologize. It's possible that within the each app no there could applications that are filed that are related to the main application but not children of the main application...

The report I have works perfectly except I need to make some modifications to the detail part of the report. The problem I have is that I need to populate the expiration date of the main application to the children. There is a main application (the parent) filed in the United States. Each...

The dilemma I have is this. The excel spreadsheet contents change frequently but not the column headings. I thought I could do is simply copy and paste of over the spreadsheet and it would automatically update the subreport but it's not doing that. Is there any way to refresh the data easily...

Can I link it from the database expert? It doesn't seem to work when I try to do it directly from there.

I have an excel spreadsheet full of data that I must connect to our existing database. Is there an easy way I can link the excel spreadsheet and database?

I did as you suggested and I keep getting a boolean is required here. The if then else statement is highlight. I have a parameter in my select expert. ({table_product} in [{?product}]

I did try your fix, that is moving one of the alpha's to the top of the spreadsheet. I thought I had stated tha earlier.

Next to each alphanumeric is a comment HN02005 comment HN02007 comment

Hi synapsevampire I just get 0 in place of the alphanumeric character. I need to use excel b/c the alphanumeric's comments are external to the db. It's easier to link them this way rather than have someone enter hundereds of comments. Thanks

Thanks I tried the formula but it doesn't seem to work. if isnumeric({alphanumeric)then totext({alphanumeric},",",2) I get a string is required error.

I'm creating the report from an excel spreadsheet. It should read it as text but it's not. The field type in CR is number. How can I change it?

I have a list of alphanumeric and numeric values. 3936032 398990 411 HN02005 HN02007 HN02044 HN02073 88/010 A020010 I extracted the alphanumeric/nmeric numbers from oracle and placed them into excel. I changed the column to text but none of the alphanumeric values are coming across. All I get...

I need to convert an oracle number field to a text field in CR. The field name is {Sheet1_.Alphanumeric} I tried To Text but it did not work.

Thanks for the help. I think I know what the problem is. I'm trying to develop a report where the only thing the user has to do is select the product type via the parameters. Each app is assigned one product type APPNO Country Status Number Type APP01 US Grant 966333...

Hi I'm not sure what happened but the double brackets aren't in the formula editor. I will continue to try different combinations. Thanks for your help. I'm pretty close.

Hello. I changed the order of the formula so that each statement starts with ISNULL. I also began to place the parentheses around my statements but I get the following error. "The remaining text does not appear to be part of the formula." I've shortened the formula. Where am I going wrong...

Hi Synapsevampire, Thanks for the reply. I did test the formula. Everything I ask for came out. It was nearly perfect. Except for the extra country. I didn't understand why. I will add the parentheticals. Also there are two different date fields I must check not one. Ctry Grant date...