Recent content by Corinne30

I am trying to figure out the following: My users need to be able to input a beginning number through a parameter and then number the rows in the detail section starting at that number. ie. if the beginning parameter number is 50 then the first row would be 50 , next 51 next 52 and so on. I...

I am trying to figure out the following: My users need to be able to input a beginning number through a parameter and then number the rows in the detail section starting at that number. ie. if the beginning parameter number is 50 then the first row would be 50 , next 51 next 52 and so on. I...

Any help is appreciated.

Currently my formula is : {?interest}/2 which results in 8.675

I was hoping to see something in a Crystal reports formula

Need formula for: User has an interest amount of 17.35 which needs to be divided by 2 which is a result set of 8.675. Once that division is done I need to have the 2 amounts 1 should be 8.68 and the other should be 8.67 which when added together total back to 17.35 How should a formula for...

I have a Crystal report that has been designed to print 4 post card size mailers on 8.5 x 11 landscape card stock. The report data comes from a view, where the grouping was done so there is no grouping on the report. All sections on report are suppressed except for the details sections...

I'm hoping that someone can give me insight on my problem. I have a report that when my customer runs for a large date range, the report takes hours to compile. It was created with 2 sub reports in the detail section which I know is the problem. I've taken both off and it runs fine, I add...

I have a calculation that I need some help with. The users need to enter an interest amount and then that amount gets divided by 2 and the results of that are then either multiplied by .25 or .75. My problem comes when the interest amount is an odd amount like .09 How can I use the mod...

Hi Andy, Thanks for responding. The logic is to take the permit_id which is unique and append the _0001.tif to it and then rename the file 20120404.AEY to 37_0001.tif and then the next one would be: 20010108.AA7 renamed to 36_0001.tif. I'm just not sure how to be able to do this. Somewhere...

Hi - Thanks for responding. I'm still missing the point of the renaming if the file. I need to rename it with the ID of the users ID. the file originally named 20120404.AEY needs to be named 37_0001.tif based on the link from my text file. I'm sorry but I'm missing how the example you posted...

Hi, I'm working in vb.net What I need to do is to rename image files that exist in a file structure to a new naming convention based on data in a text file. Can anyone look at this and let me know what I need to do??? My text file looks like this: SCANNED_DATETIME|PERMIT_ID|OLD_NAME...

Hi Charlity, I tried your suggestion and I get hte same msg when trying to save the formula: if ({VW_MORTGAGE_TAX_BY_TOWN_MC.MUNICIPALITY_NAME} <> {?MunicipalitytoAdjust} AND{VW_MORTGAGE_TAX_BY_TOWN_MC.MUNICIPALITY_NAME} <> {?MunicipalitytoAdjust2}) then Sum ({@SumRefAdj}...

Thanks for responding. I tried what you suggested but errors at the last two lines: else Sum ({@SumRefAdj}, {VW_MORTGAGE_TAX_BY_TOWN_MC.MUNICIPALITY_NAME})*{@GetTaxRate} says that remaining text doesn't belong to the formula. Do I need to change the parentheses? Thanks