Search results for query: *

Current field value coming from sql table is numeric (6,2). I am using this field in an interface to another application that requires fixed length numeric (7,3). Changing the strings to fixed length has been easy enough, but numbers - not so much. my formula is: if {table.colname} >= 1.0...

I have created a Crystal 8.5 report that pulls data from a sql view. My report contains a sub report and is set to run and export to Excel nightly, using Info Scheduler 7. My problem is that when the main report has no records, the export for this report shows no records, even though there are...

My Crystal report contains one sub report that exports correctly to Excel 7, but does not export the sub report at all when exporting to Excel 8. I have looked through the patches available for Crystal 8.5, but I see nothing that pertains to this issue. I guess I've missed something. Can...

I went back and checked - Force New Page was in a group footer. Thanks for your help

I have inherited an Access report running in Access 2000, that is page breaking after each 'group'. I don't want these page breaks to happen and have checked the properties of the Page/Report/Group headers and footers to verify that each is set to "No" for "Keep Together", Force New Page is set...

Force New Page was set to None. Anything else I can check?

I have inherited an Access report running in Access 2000, that is page breaking after each 'group'. I don't want these page breaks to happen and have checked the properties of the Page/Report/Group headers and footers to verify that each is set to "No" for "Keep Together", and that is the extent...

I need to be able to export my Crystal reports to a prn file format. Is there any way to do this?

End user with Windows 95 downloads Performance Review form with VB macros and receives the following error: Microsoft Word can't hyphenate this document. This feature is not currently installed. Other Windows 95 users have used this Performance Review form with no problem. Any idea what is...

Thanks so much - I had no idea about the continuous break thing. I'll try that!

Someone here just found the code for this - wanted to share with you...go to this linkhttp://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDocContent.htm

We are having the same problem. Does anyone have a solution? Thanks

We created a Performance Appraisal template in Word that our managers will access from the company intranet. The managers will record their responses on the template. The template has been write protected to prevent changes to the template, but this prevents spell check of the manager...

I used synapsevampire's solution and everything works great now except if there is Repaid Date and not a Loan Added Date. I think I understand why this isn't quite working, but I don't know how to fix it. The group footer formula says if Repaid Date <> cdate(1950,1,1) then Repaid Date - Loan...

Using Crystal v.8.5 to connect to an SQL database through an ODBC connection. All transactions (actions) for a particular loan are stored in a table called Log, which is actually a history file. There are many transaction codes available for a loan, but I am only interested in the Loan Added...

Still getting zeros.

I have created a CR that pulls all loans with a trans type number 1 and 2, with trans type 1 eq "Loan Added" and trans type 2 eq "Loan Paid Off". Both of these trans types will have a date tied to the transaction which is stored in the transaction date field. How do I subtract the...

Since I came here yesterday and received help passing my shared variable correctly to my main report, I have a shared variable repaidDate in my Main report which I can use to subtract from a loan initiation date in my Main report to get a number of days figure for each Loan ID. Now I need to...

As soon as I put the reset formula into the main report my report worked and the world is a wonderful place. Thanks so much for your help. You all are great!

ok, I remember a reset formula when I used running totals in Crystal Reports v.6.0, but I really don't remember a reset formula for this. Is there documentation regarding this? Thanks so much for your help and your patience!