Recent content by BillPeck

Brian, hi, thanks for the tip. I have done the formula and summary field (as you suggested) and was just trying to get a feel for variables and how they work using a simple example. Any thought on what I'm doing wrong with the variable? Thanks. Bill

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...

When I'm in the formula workshop, the Repository items are gray'ed out. Bill

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

Dave, excellent, leaving it blank worked, parameter comes up fine. 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...

Dave, that worked, thank you very much ! Bill

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...

Great ! Thank you for the time, it looks excellent now. Bill

Dave, Thanks for the reply, your suggestion worked. But I'm now trying to do a date range and not having any luck. Here's the formula: "Customer.Country} = "USA" and{Orders.Order Date} in {?Order Date 2}" I changed the parameter to "Range Values". It prompts me for a range, the lower date...

I set up the parameter field as type 'Date', using a range then entered the data in the required format: 1/1/2001 to 12/31/2001. The parameter doesn't do anything, even if I enter 2/27/2004 to 2/27/2004 it returns all records. But if I enter two dates in the Select Expert, the data gets...