Search results for query: *

I'm trying to add stock prices to an Excel spreadsheet. I have a column with stock symbols. I am trying to use MSN MoneyCentral Investor Stock Quotes. I clicked on the data tap, the on connection and added the "MSN MoneyCentral Investor Stock Quotes" I clicked on properties and checked the...

I need to group payroll data by week. The problem is, my client's week starts on a Monday and ends on a Sunday. How do I tell the group expert to sort on that kind of week? I know that there is a place to enter a formula, I just can't figure it out. Thanks, Howard Hammerman, Crystal Training...

I need to create a payroll report that separates employees' hours into regular and overtime. The employees go out on service jobs (dispatches). Each dispatch will have a start and end time. I've already calculated the number of hours for each dispatch. For example, 3.50 hours. Regular time is...

I have a potential client that needs to post the results of a report on their web page on a daily basis. The report need not be interactive. If we could include drill-down capability, that would be great. What is the best way to do this? I know how to export to HTML, but I could use help...

My client has create a cross tab with two row fields and one column subtotal. There are 14 categories in the column field. Each cell has two values: Units sold, average sale. It works perfectly. Now the client wants to suppress the values in each cell (but not the row totals) when the sum of...

I need to have a Crystal Report (Crystal 2008) refresh itself every 15 minutes. Is there a way to do this within Crystal. Is there a third party program to do it? Thanks, Howard Hammerman, Crystal Training and Crystal Material On-site classes and one-on-one coaching Low-cost telephone/email...

I have developed a complex report for my client. It is grouped by employee number and then sorted by invoice number. In order to get the correct results, I need two sub-reports based on the invoice number. I created two additional detail sections. Detail a has only a "reset" formula in which I...

I have a spreadsheet with transaction data for each customer. Column A is the customer number. Some customers have one transaction, some have many. I want to insert a blank row after the last transaction for each customer. Is there an automatic way to do that? Thanks. Howard Hammerman, Crystal...

Is there a way to have Crystal forget about the previous parameter values when I refresh the report and pick "new values"? My client would like the parameters to be blank. Howard Hammerman, Crystal Training and Crystal Material On-site classes and one-on-one coaching Low-cost telephone/email...

All of a sudden I can't open the field explorer. When I click on the icon nothing happens. I tried it via the menu as well. If I edit an existing formula the three lists at the top are not there: Field list, function list, variable list. Has this happened to anyone else? Do I need to...

My client has Crystal XI. He is trying to connect to an external sql database using a MYSQL driver. Someone created a system DSN for him using the driver and the correct IP address, user name and password but Crystal can't see it. I tried creating a file DSN but it wouldn't save even after it...

My client has an DBISAM database and he wants to use Crystal 2011 to access it. Does anyone have a suggestion? Howard Hammerman, Crystal Training and Crystal Material On-site classes and one-on-one coaching Low-cost telephone/email support www.hammerman.com

I have created a report for a client based on an SQL accounting database using the latest version of Crystal. I am summing six columns to three group levels and a grand total. All is well except for one column my grand total is 2 cents higher than the grand total shown in the report provided by...

I created a formula to check for missing data that were critical to another report. The code was as follows: numbervar F1 := if isnull({table.field1} then 1 else 0; numbervar F2 := if isnull({table.field2} then 1 else 0; local numbervar total := F1 + F2; Total When I inserted the field in the...

My client wants an invoice report. Not a problem. One page per invoice. However, he wants a preliminary report that checks to make sure that all the elements needed for the monthly invoice are in the tables in the correct format. Again not a problem. Those customers who fail the test need to...

My client's database has a table of work tickets with four fields: Startdate (datetime but the time portion is all zeros) Starttime (Eight-character string field format hh:mm:ss) Enddate (same format as startdate) Endtime (same format as starttime) I created a datetime variable in a formula as...

My client is a plumber and his employees fill out work tickets when they are on a job. All this is entered into an SQL database. The table I am working with has one record per ticket with start datetime and enddatime fields. The task is to calculate regular hours and overtime hours from each...

My client has a database of parts and because of some limitations in the database, she has to, in some cases, insert the quantity and the part number into the same field. Here is an example: 12-12345;6-54321 This indicates that for that record (linked to a piece of equipment) there are 12...

I need to produce a daily form that will list the assignments given to each technician for the day. A tech can have as many as 5 assignments; some days a tech will have just one. I can produce the form with the required vertical and horizontal lines. However, now the client wants a sumary in...

When running CR 2008 I notice an ad for Crystal Reports viewer. How does it work? Howard Hammerman, Crystal Training and Crystal Material On-site classes and one-on-one coaching Low-cost telephone/email support www.hammerman.com