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
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.