Search results for query: *

This problems may have been resolved long time ago. But, in Crystal Report 6.0, there is a much easier way to convert the amount from the numeric status to the words of that amount, even it takes care of the negative amounts: ToWords(fieldname). Kamal Khalil Sr. Client Technical Analyst...

Clarson: Please follow step by step: Put your cursor on the left side of the Detail line. Right Click your mouse. Click on Format. Check New Page After checkBox. Click On the Formula Button (the X2 Button on the Right on the right of New Page After Copy this Formula: Remainder (RecordNumber, 5)...

Are you using SQL, or directly a Crystal Report? Kamal Khalil Sr. Client Technical Analyst kkhalil@Houston.ds.adp.com

Several references stated that 16 Tables is the Max. You will get an error after that. Kamal Khalil Sr. Client Technical Analyst kkhalil@Houston.ds.adp.com

I have few questions to those who already used Report Miner in the fashion described in the first section above: Can you have a list of all the Crystal reports a certain client is usig? Can you have alist of all the clients that are using a certain Crystal report? In what fashion these reports...

Saweens: You have not specified what you are using, and you did not explain what you are going to do with the Duplicates. Generaly, there are 3 steps to DETECT duplication. 1) Sort by the primary key. 2) Create a flag field. 2) Compare with the previous record, when duplicate, flag it ( example...

If you already looking at this page, that means you already passed it. So, click on the back arrow, to go back one page and look at the tabs in the middle of the page. One of them is FAQs. Click on that, and then check the specific item you wish. In this case it is FAQ 1.B as Ken stated. Kamal...

Try the Date difference formula: This will Return the number of date and time boundaries crossed between two specified dates. Syntax DATEDIFF(datepart, startdate, enddate) This example determines the difference in days between the current date and the publication date for titles in the pubs...

Go to Database menu Remove from Report Highlight table name Click on remove button then refresh report Kamal Khalil Sr. Client Technical Analyst kkhalil@Houston.ds.adp.com

In short, a stored procedure is a saved group of statments that returns an output or triggers another action. You need to know where the stored procedure is located. Then, you need to decide what fields you need to pick up , if not all. You will be prompted to decide what are you going to group...

This is a solution if you want to have a certain definite number of records on each page (I used 25 Records on each page). 1) Delete the Last name from the report. 2) Create a Last Name Fromula: Go to main menu Insert Formula field New Name the New formula as: Last Name When Formula window...