Search results for query: *

Using Crystal 10 and I need to fiqure out a formula where if the print date of my report is before one of the dates my report is pulling then the field needs to be blank. For example. I have someone who has placed orders into the future. I have orders from them in Dec 5 2006, Dec 5 2007 Dec 5...

What I need to be able to do is to create a parameter field in which a number get's type in, then on my report it would then add 1 to the subsequent numbers IE: I type in 12345 into the parameter field, then if I have 5 rows of data I need them to be 12346 12347 12348 12349 12350 Ect, is...

Basic question, but I can't fiqure it out. Using Crystal 10 I need to turn zeros into blank fields. So if 0 then " ", but I don't know what hte formula would be. This is what I tried. If ({ROTOptionExport.Shares 1}= 0 )then " " else ({ROTOptionExport.Shares 1})

Using Crystal 10 and have a header and footer system I need to use, seems to be fine, but when I run my report then try to export it as a .CSV file, I get a repeat of the header and footer for each line of data, when I just really want it one time for the whole report. Here is an example of...

I'm sure this is a stupid question so I aplogize in advance, but I need to know the if than for null I am assuming it's If {whatever.rot} is null then "0.0000" else {whatever.rot} If someone could please help I would highly appreciate it. Thank You This is using crystal 10

I have a report I'm creating in Crystal 10 So what I have is a purchase date and a purchase period Purchase date would be like 8/14/2007 and the purchase period would be like 1 or 2 or 3 or 4. What I need is a formula that would subtract 1 year from the purchase date if the purchase period is...

How do I place a formula to enter in leading zeros on a number for instance I need to hold 10 places so 101 should be 0000000101 1001 should be 000000101 10001 should be 0000010001 so no matter what the number is I need 10 fields and the fields should be leading zeros. This is using Crystal 10...

Hello, Using Crystal 10 and have a subreport to pull data. I have two questions. A. When I run this new report in my software and then export the data out in a character seperated value file the sub report data is not showing. B. The subreport is pulling fields based off of Tax Description...

I have a report that I have created that has a ton of columns, this report get's run through my software and then I export to Excel. The data will open up to see the complete text, however the column headers are shrunken and will not enlarge to read all the text that is in the Text Box. Is there...

Hello, A little background, I'm a basic user that needs help fast. What I need to do is over my head. If you can help me I sincerly appreciate it. A person at my job wrote a custom report, but has since left and I need to modify something that he has done. I am using Crystal 10 and what is...

Hello, I have created a individual per person statement for my employees in Crystal 8.5, I'm going to mail these out to my employees and thought it would be easier to create a cover sheet with name and address that would print out at the same time of their statement, so Mr. Amor would have a...

Hello, I'm using Crystal 8.5 and I'm having troubles with the following formula. Here is what I'm looking for. I have a bunch of items purchase throughout the year but only want the items for two specific dates and a separate column on my report for each one. Something like Customer A...

Using Crystal 8.5 Here is the scenario. Someone buys items from us once a quarter, but I need it broken out by if they bought the items over a year ago, or under a year ago So something like Items bought less than 1 year ago 423 Items bought more than a year ago 223 I have the dates they...

Is there a way when Exporting my Crystal Report out to straight TEXT format for it to keep all of my page breaks and column headers??? If I take it out to .RTF it's find, but if I take it out to TEXT it looses all of it's formating, is there anyway to get around this??? Any help is appreciated...

I'm using Crystal 7 and on one of my reports it list the employee's ID or SSN, would like it to "X" out the first 5 numbers, and just leave the last 4, anyone know how to do this, or maybe just show the last 4 numbers only?

One of the fields that I have is "Management Unit" and I have my report doing a Page Break at each new Management Unit however, I need it to now put the number 1 on the top of my report ONLY when the management unit changes, so if I have 3 pages of the same management unit page number...

O.K, Let's say I have 4 different departments Sales Management Executive High Level Exc I'm looking for a formula for when it come accross the word Sales it makes that Department one, Management would be Department 15, ect ect....what can I use for this? This is Crystal 7

I posted this in another forum and it's gone unanswered and I need help ASAP. I need to know how to tell Crystal to do a Page break by Group Footer number 2? I'm using Version 7 of Crystal, all help is appreciated. Thanks

How do I set up a page break at the Group Footer number 1 only? I'm using Crystal 7 and Group footer is being used for Subtotals. Thanks

Here is what I'm looking for, I'm doing a report in Crystal version 7. I am using Tax fields and what I need is a formula that will look into the listing of employee's taxes and will pull out the tax description 4 (I have 8 tax fields to choose from) like (Ca-State), but if that field is...