Search results for query: *

Using Crystal SQL Designer(32) For Windows Version 8 Need help with what the exact Version of SQL that this is based on so that I know what statements are acceptble. Is anyone aware of a good reference source for learning Crystal SQL Designer? Many Thanks

Using Crystal Reports Professional Version 9.2 Tried to delete the formula @balance, yet Crystal shows the following message. "The field @balance is being used in the report. Deleting it will remove it from the report canvas." So, I then in Design mode deleted all formulas,groups,selection and...

Thank you both synapsevampire and lbass for your replys, works fine.

In SQL Database using Crystal V9 I am trying to show time field RT_TIME correctly which is stored in the database as a number field so that 150759 I want to show as 3:07:59 PM Which is the best formula to use

I have a report that lists 20 customers which I want to modify to show total sales based on the parent customer (though not all customers have parents). In the SQL database it would appear as follows: RM_CUST RM_PARENT VALUE Cust1 100.00 Cust2...

Thanks LB Unfortunately tried this with no success. The way this information is stored in the SQL database is that for every account {GM_ACCT} it will have a Total account that it refers to {GM_TOTAL_ACCOUNT}. The {GM_NAME} field is associated with the {GM_ACCT} field and the the problem is that...

Started using Crystal in SQL database info as follows- SQL Database - Crystal Version 9 One Table named GM Output Expected is as follows GLAccount AccountName TotalAccount TotalDesc 300.1005.00 Petty Cash 300.1025.00 Cash Assets This information is stored in the GM table as...

In your General Ledger accounts table you should have a field for Account Add date and Account Edit Date. You could use these fields to compare to the "Last Published date" which the user could enter at run time (Crystal Parameter field). You could then use a formula to compare this date to the...