Search results for query: *

I'm trying to do some basics with variables and not having any luck. I'm just trying to count the # of USA customers, like this: FORMULA FIELD: numberVar USA_Total_Customers := 0; whilePrintingRecords; If {Customer.Country}="USA" then USA_Total_Customers := USA_Total_Customers + 1 Then I...

I have detail records then a summary and want the $ sign to show up only on the first detail per group. I tried to do this by having a conditional formula in Format Editor, Number, Customize, Currency Symbol for the "Enable Currency Symbol". I figured this was a boolean field, so I tried to...

I'm looking at G Peck's "Crystal Report 9", p. 168 and trying to do the exercise. It seems to me that you can't do "Top N" reporting with a running total. When I have a report with one group (Country) and a Running total that summarizes Last_Years_Sales, the "Group Sort Expert" button is...

In G Peck's "Crystal Reports 9", he says on p. 193 that there are four objects that can go in the Repository: - Text objects, - Bitmaps (pictures), - Custom functions, and - Sql commands. But in my version of Crystal (9.0), there are only three types of components listed in the Repository: -...

What is the basic method for providing reports to users? This is for a small organization, one database, the goals are: - a nice facility to view reports - reports are viewed in "runtime" mode, i.e., not from within Crystal "designer". - menu'ing facility - logon on once Thanks. Bill

I've set up a stored procedure in Sql Server with a paramater. I can run it fine in Query Analyzer. When I select the stored procedure as the "table" in the Database Expert, it immediately asks for the parameter. So I just enter "A" but get an error message "Not Supported, Cannot obtain error...

I just took the 1st exam (RDCR200A) and it was harder than I expected. The questions are very fine-grained so it became a test-taking challenge as opposed to knowing how to write a report. I had minimal experience with Crystal prior to the test but spent considerable time reading G. Peck's...

I'm working on Ch 14 of the Crystal 9-Complete Reference (George Peck), specifically p. 386. I've created three parameter fields but can't get the entered values to display on the Preview tab as they do on the screen shot on p. 386. Here's what my Preview tab displays: Customer Name includes...

I was playing around with date selections and got unexpected results, using Xtreme database First I created a parameter for Order Date, but all records were retrieved, even though I entered 1/1/2003 to 12/31/2003. Then I tried the Select Expert, that worked fine, but I prefer to use a...

Is there a place to download a fresh copy of the Xtreme database? I hacked mine up without creating a backup. Thanks ! Bill