Search results for query: *

I want to create a line chart that shows an average price over a range of dates. For specific dates I want to be able to add an annotation that describes an event that occurred on that date. As the date range grows I want my annotation to stay "anchored" to the date it originally pointed to...

The chart is in my report footer. {#Actual forms Out} is a distinct count of Customer.Accountid that evaluates based on the following formula: CurrentDate >= {GoalTracking.Date} and {SP_BROKERAGE_SALES.BROKER_ROLE} = "Sales" and Date({BROKERAGE_ACCOUNT.FORMOUT}) = Date({GoalTracking.Date})...

Thanks LB. I added 2 new formulas "Actual" and "Null". Formula for Actual is: If {GoalTracking.Date} <= CurrentDate then {#Actual Forms Out} else tonumber({@Null}) Formula for Null is blank. I have 1 group in my report GoalTracking.Date (by day). When I put @Actual in either details OR...

I have a line chart that tracks actual new clients (forms in) per day vs the monthly new client goals per day. The first series (Target) works exactly how I want - as you can see in the linked file below the blue series (Target) extends though the end of the month. I get this data from a...

I have been asked to develop a new report where I would chart a sales persons actual progress against their stated monthly and annual goals. So salesperson A would state that his goal is to open 20 new account in January, 15 in February, 40 in March, 10 in April, 20 in May, etc... In March...

Turkbear - thanks for the reply. After I posted my original question I remembered someone mentioning a product called Visual CUT from Millet Software (Ido Millet is a poster on this site I believe). The software only costs $300 and with it I was able to generate an email to each client with...

I am using Crystal Reports XI / Central Management Console to email many reports out each day. I also use Win XP Pro on all computers involved. Is there a way I can email out a scheduled report ONLY when a specific value occurs in one of the fields in my report? Here is the scenario, we...

I have a 40 or so page report that I export to HTML. I then upload these files to our website. Problem is, I have to rename the HTML files to something that makes sense to the person handling our website. The report groups are as follows: Commodity, Year, Month. I have the report start a new...

I am running Crystal Reports XI on Windows XP Pro against an Access database. I have a report that involves for tables: Commodity, CashContracts, HedgedContracts, and ReOwnedContracts. Each of the contracts table is linked to the Commodity table via Commodity.CommYearID. Also in each Contract...

Thanks, that is exactly what I ended up doing.

I'm using crystal reports XI to report on a SQL & Access database within the same report. We have a service at our company where we help farmers manage & sell their entire crop production for a year. Throughout the year we maintain what we call a "Model Farm" that shows for X crop this year at...

I am using Crystal XI against MySQL database. I have multiple reports that show daily call statistics from our recorded calls database. There is a field in the database ('Agentid') that shows all extensions involved in a phone call. The data from this field can look like the following: 120...

Thanks for the response. I called Ken Hamady and I think I will be signing up for his Protege training course. I was very pleasantly surprised to have Ken return my call within about 30 minutes after I left him a message. Mr. Hamady seemed very professional and had a great understanding of...

I was wondering if anyone can recommend some quality training courses for a somewhat advanced Crystal user. I use 8.5 and XI and find that I can almost always get the results I want from a report, but I feel like often I'm using a big hammer to drive the square peg into the round hole. Some of...

I forgot to mention, this is on Crystal XI.

I've been reading SynapseVampires FAQ on Optimizing SQL Pass through and I'm just not getting it. I have a report with the following Select Expert at Record level: ({loggerlog.AGNTID} startswith "1" or {loggerlog.AGNTID} startswith "4") and (Date ({loggerlog.STARTTIME}) in LastFullMonth)...

I use Crystal XI to query many databases in our organization. One of the databases is a MySQL (4.X) database. There is only 1 table in that database I run reports against with about 200,000 rows in the table. My problem (and I've not spent as much time as I should learning performance tweaks...

Andy - Thanks. Worked perfectly. Ryan

I have a field {table.price} that displays numbers such as below: 4.2 4.25 13.1 13.15 13 In need to display these number values as a string based on the following conversion: 4 = 0400 4.2 = 0420 4.25 = 0425 13.1 = 1310 13.15 = 1315 13 = 1300 {table.price} represents any value from 0.01 cents...

I've been reading some past postings about people like myself who in Crystal 8.5 would use the Show SQL Query window to edit & modify the SQL query only to find that in newer versions of Crystal starting at 9 through XI this feature is unavailable. It sounds like you have to have a universe...