Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Corinne30

    Division of currency formula with/without rounding

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

    Division of currency formula with/without rounding

    I was hoping to see something in a Crystal reports formula
  3. Corinne30

    Division of currency formula with/without rounding

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

    Duplex Printing of Postcard reminders - Not printing back on last page.

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

    Crystal Reports Subreports slowing down main report

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

    How to use Mod function with odd interest amount

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

    Rename existing image files and move to new folder

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

    Rename existing image files and move to new folder

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

    Rename existing image files and move to new folder

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

    Nested IF Statement not working.

    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}...
  11. Corinne30

    Nested IF Statement not working.

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

    Nested IF Statement not working.

    Hello, I have the if statement below in a formula and the results I'm getting are zeros for all the municipalities that are pulled onto the report. Can anyone see where i'm going wrong with this? Should I be using a case statement?? Thanks in advance. if...
  13. Corinne30

    2 Sided Mailers through Crystal

    Hi, I'm trying to use Crystal Reports to print out mailers from a oracle database. The client wants to have them postcard size and fit 4 per page. I have it all set to format with multiple columns and so far so good. The problem comes in when I try to do anything with the back of the mailer...
  14. Corinne30

    Margin settings to Datacard Printer in VB.NET

    I'm developing in VB.NET 2005 and trying to utilize a Crystal Report. I'm posting here because I've narrowed my problem down to the .NET app is somehow resetting my page margins once the report is loaded and goes to print. The printer I'm using is a Datacard printer that prints ID badges. It...

Part and Inventory Search

Back
Top