Search results for query: *

I ended up using this formula and it works. totext({APPYM.AMTPAYM},"0000000000") + Right (totext({APPYM.AMTPAYM},"0000000000.00"),2) I sure there is a cleaner way of doing it but it works.

Thanks for the formula. I ended up using totext({APPYM.AMTPAYM},"0000000000.00") I had to enter the decimal point to get the cents to appear. I need to remove the decimal point but still have the cents appear. Any thoughts

Field name is APPAYM and it's a number field. For example 12250.12 I need it to appear for the bank as 000001225012 Any suggestions would greatly appreciated. Using Crystal IX Thanks Bill D.

Found the solution. Tables were not linked in the second sub-report

I'm working with two sub-reports (Crystal Pro XI). The first sub-report works fine. the second sub-report is attached with no problem. When I preview the main report I'm receiving the following error message: Details: HY000:[Microsoft][SQL Native Client] Connection is busy with results for...

I was moving the wrong field up a section. thanks. One more question. when I moved the sub-report up the information now appears on the correct line. I now have an extra blank line between the details. Since I can't suppress the sub-report or suppress the section the sub-report is in, I kind of...

The shared variable worked fine. I have the information on the main report. The issue is it is one line below where it should appear. I can't remember the correct placement of the formula or if code needs to be added to the formula on the main report so the information lines up on the correct...

It's been several years since I worked with crystal. I'm using crsytal professional 11. I need the formula in a sub-report to pass a value through to the main report and then in the main report the formula to place the value on the main report so I can do a calulation on it. thanks in advance...