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...

That works great until I export this out of my main software, then the zero's re-appear.

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 am using Crystal Version 10.

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...

It works good for the first person but on the second person it repeats the entire header information and now shows their name and info twice basically it repeats the Page Header and the Group Header, But one the first person it's perfect.

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...

Looks good, but I'd like to find a way to where I didn't have to come back in and update the current date information...it will always be standard at 1 year.

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...

Sorry, I'm using 7.0, don't know how to check what service pack I'm on, and the link you gave me has a bunch of different ones so not sure what to download.

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?