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

Interesting, Charliy's formula yields an integter (week number) while Ken's yields a date, the first day of the week. Both are very useful. thanks, Howard Howard Hammerman, Crystal Training and Crystal Material On-site classes and one-on-one coaching Low-cost telephone/email support...

Thanks Ken, I should have looked at your site in the first place. Howard Howard Hammerman, Crystal Training and Crystal Material On-site classes and one-on-one coaching Low-cost telephone/email support www.hammerman.com

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 believe that I've figured it out. Emp date hours reg ot 1 1-Sep 8 8 0 1 2-Sep 8 8 0 1 3-Sep 10 10 0 1 4-Sep 10 10 0 1 5-Sep 8 4 4 1 6-Sep 4 0 4 Note that on 9/5 the hours were split between regular and overtime and that on 9/6 all the hours went to overtime. I did a test on the running...

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

There is a problem with a manual cross tab. One of the summary measures is an average. Within the xtab expert the averages are accurate. However, in the manual xtab they are not. They are not because I am summing on an indicator formula: If {table1.size} = size1 then 1 else 0. For the sales I...

Been there, done that, it doesn't work. The reason it doesn't work is that I am comparing a subtotal created by the cross tab expert to the parameter value. That subtotal does not exist. Remember it is in a cross tab. There are 14 values in my column field. I need to access the total at level...

Try this: if isnull (table.string} true else "stringA" in {table.string} Howard Hammerman, Crystal Training and Crystal Material On-site classes and one-on-one coaching Low-cost telephone/email support www.hammerman.com

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

Are the A products in our group and the B products in another? Are A & B a sub-group of group 1 (that is, group 2)? If so, sum the sales at the group 2 level and create a formula that divided the value by the subtotal. I bet it is more complicated, right? Howard Hammerman, Crystal Training...

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 found the answer elsewhere in the forum. I needed to "suppress blank sub-reports" in the "format sub-report" attribute of the two sub-reports. Thanks to all. Howard Hammerman, Crystal Training and Crystal Material On-site classes and one-on-one coaching Low-cost telephone/email support...

The soundex function looks at a string of text. It eliminates all the vowels (except for the first letter) and one of all the duplicated consonants. Then it assigns a number to each consonant or consonant group according to the sound. It returns the first letter and the first four numbers...

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 guess the important word in your last sentence is ONLY. Right now yellow happens if Percentdelta is in the range. Here is a better statement: if Sum ({apc_correlated.ons}, {apc_correlated.transit_date_time}, "daily") > 30 or Sum ({apc_correlated.offs}, {apc_correlated.transit_date_time}...

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

First step would be to group on the truck field. Then you need to filter your data to get the reading on first day of the month. Can we assume that there is always a reading on the first day of the month? Use Day({table.field}) = 1 in your query. Next create a year and month field by using the...

I bet you have sorted & grouped your data by {coverage.datein}. The first formula works because you are looking at the first date when processing the report header. When processing the first record {Coverage.DATEIN} = ({?Start Date}+1) will be false. You did not provide an "else" part of your...