Search results for query: *

Hi all, I tried to search for this and didn't get anything. I am sure I am searching wrong as I am certain this is a common question. I am running this expression in my query and it is telling me the expression has invalid syntax. Does anyone know what I am doing wrong. I have not used...

Hi all, I am using Crystal Reports 11. I do allright with formulas until I start using date formulas. They confuse me so much that I sit there paralyzed looking at my screen and not knowing what to do. :o( I have to create a report that uses three forumula fields based upon date range...

My co-worker is working on a spreadsheet here is the dilemma. I am hoping someone here can help. Thanks as always I have embedded an excel table within a word document. I created a macro to unprotect the workbook insert a row in the proper place and re-protect the workbook. Is there a VBA...

Hi all, I am sure there is a simple formuala for this but I can't figure it out (I looked in my Crystal book and have been googling for 1/2 hour.) Anyhow, I have an account number that is stored as text. For security purposes I only want to show the last four digits. Is there a text formula I...

Hi all, I have two fields. One is called Mat Date and the other is Est Mat Date. My problem is that the two fields basically mean the same thing but are in two seperate fields. Whenever there is a date in the Mat Date field than the Est Mat Date field is null and vice versa. What I need...

Hi all, one of my co-workers is trying to figure out a way to have a date on a cell that will show the last revised date, not the current date. Is there a simple formula that will do this? I googled and searched but couldn't find anything. Also, It would be when a change was made and saved on...

Hi all, one of my co-workers is trying to figure out a way to have a date on a cell that will show the last revised date, not the current date. Is there a simple formula that will do this? I googled and searched but couldn't find anything. Many thanks

Hi everyone. I am using Crystal 11. I have created a report that has some formulas in my first group. I would like to change the group on the report frequently dependent upon who the report is going to. Anyhow, after I change the group, I get an error message that says "there must be a group...

OK, I have spent most of my day trying to figure out how this can be done. I have googled arrays and variables and still can't figure out if this is what I need to create in order to get my report to look the way I need it to. Here is the scenerio. I have a report that shows two years worth...

Hi all, Trying to get these date range formualas straight in my head is very challenging. I am used to only doing formualas with one or two dates and not a range of dates so I apoligize for the many questions I have. Anyhow, I am creating a report that is going to show sales. This report...

Hi all, I am currently using Crystal 11 I need to make a pie chart in a report based upon a range of dates. The field I need to base it on is the Maturity date (Maturitydt). Normally I would let Crystal do this in the select expert, but cannot do so in this instance because I need all of...

I am using Crystal 8.5 I currently have a table that has fields named PreviousORR and CurrentORR. Both of these are number fields but are built as text in the database I get the information from. I tried to convert the field to a number but whenever I do I lose the decimal point and...

I apologize for the vague description, it's the only way I could think of wording it. I have an Excel spreadsheet. On this spreadsheet is City information, Year and Motor Vehicle Registration Types. The Spreadsheet looks like this. This is sample data City Year Luxury Cars SUVs...

I hope I am in the right forum. This has been driving me crazy and I am stumpted. We are going to be doing an event where we will be relying heavily on Outlook to automate as much as we can. We will be setting up a seperate mailbox to capture responses for an event we are planning. The...