Search results for query: *

Hi: We are using WSS 3.0 with Search Server Express. I have a question about the modifying the Search results display. When you search on a contact (ex: Branson), the display looks something like the follwoing: Branson Eric ...ericbranson@test.co...

I am using SharePoint 2003. When I upload a document to the site, I get two alerts - one that says the document has been added, and another that says that the document has been modified. I was expecting only one email about the document being added. Does anyone else have this problem? Any ideas...

Hi: Using Crystal Reports XI and MySQL 4.1.5 Each report has a query in the Command box of the Database expert in Crystal Reports. There are more than a 100 reports that have been delivered to the customers. Unfortunately...we have found a bug in the queries that need to be fixed. Does anyone...

Using MySQL 4.1 I have the following table: Stat | StatDt | ChkDt ========================= 1 | 8/3 | 8/3 NULL | NULL | 8/7 23 | 9/12 | 9/12 5 | 9/17 | 9/17 NULL | NULL | 9/25 NULL | NULL | 10/1 If a stat is available (NOT NULL value), the StatDt...

I am using a simple HelloWorld servlet that runs just fine under the /classes folder, but it does not run under the /classes/bjohnson directory. Works as: /classes/HelloWorld Does not work when I run it as: /classes/bjohnson/HelloWorld I have the .class file in both folders. Both folders...

Using MySQL 4.1.5. I am pretty new to writing SQL queries so I am hoping someone can help me with this. I have the following data in a database. ID | Date | Value ------------------------ 2 | June 3 | 10 2 | June 15 | 5 2 | June 20 | 7 2 | July 7 | 10 3 | June 8 | 2 What I...

I am having some problems with running totals and charting and I hope someone can help me. I am using MySQL 4.1.5 and Crystal Reports XI. Trying to chart the actual cost per month. Currently, I have the following formulas: ActualCost:If type = 'a' then CCur(mycost) else CCur(0); I also...

Hi: I am really new to xml and have a question about apostrophe. What is the difference between &apos; and &#8217; If I use &apos; for something defined as an element, the page displays properly. It gives me garbage if I use &#8217; However, within the paragraph <p>...</p>, I have to use...

Hi: I am new to stored procedures so I am hoping someone can point me in the right direction... My original query looks something like: (SELECT * FROM db) [tab]AS tb1 INNER JOIN (SELECT tb2.a, tb2.b FROM db WHERE tb2.b='xyz') [tab]AS tb2 ON tb1.a = tb2.a Using stored procedures, I...

Hi: We are currently using Crystal Reports XI and MySQL 4.1.5. All of our reports are query based. In other words, instead of using the tables in the database directly, we paste the the query into Crystal Reports using the Add Command. We are thinking of moving to MySQL 5.0.x so that we can...

Hi: I am pretty new to MySQL. We are using MySQL 4.1.5 to write queries and incorporate them into Crystal Reports. Is there a 'Next' or 'Previous' function in MySQL? I have not found anything. I have a table like the following: Date1 | Date2 | Value...

Using Crystal XI and MySQL db. I have the following info available to me: Date1 | Date2 | Info1 Formula ============================== 02/02/06 | 12/12/05 | a 0 02/02/06 | 01/16/06 | b 1 02/02/06 | 04/04/06 | c 1 02/02/06 | 05/03/06 | d...

Hi: I am using CR XI. I have the following information provided to me: start date (eg: 01/05/06) and end date (eg: 01/08/06). I need to create a group on the dates that fall within that range, which should then look like: 01/05/06 ... 01/06/06 ... 01/07/06 ... 01/08/06 ... Can anyone...

Hi: I am writing a query using MySQL and am running into some problems. Hopefully someone can help. My first query gets the year and month from the database and then concats them to create a datetime. When I run that query by itself, it displays the correct datetime format. However, when I...

Hello: I am pretty new to MySQL, so I am hoping someone can help me with this. I have the following data in my database. ID | Name | Relation/Value ----------------------------------------- 26 | PPID | DMDR_14 26 | PPID | BMDR_20 14 | DMDR | DMDR_16 16 | DMDR | BMDR_33 16...

I am hoping someone can help me with the following problem: Using Crystal Reports XI with a MySQL db. Example: Person | Start Date | End Date | Hours/Day George | 10/03 | 10/12 | 6 Chris | 10/25 | 10/28 | 8 George |...

Hi: Can anyone explain to me how the 'Save Data with Report' really works. We are using Crystal XI and some complex MySQL queries to create these reports. The reports are being generated and distributed via the web. However, whenever there is a large amount of data, the viewer takes minutes to...

Hi: I am using CR 10 with a MySQL database. I have the following setup in my database: Date Revision 01/03/05 3 01/19/05 8 02/06/05 4 05/12/05 3 In Crystal Reports, I need to be able to list all the months even if we have no data for it. I need to enter the months...

Hi: I am using CR 10 Pro. I have two running total values (Planned and Actual). I created a formula called Variance = (#Planned - #Actual) I need to chart the Variance against Time. But, the Variance field is not showing under the available fields for charting. Can someone tell me how and...

I am having some major problems with charting and I am hoping someone can help me with this. I have to show trends of planned versus actual for over 50 different charts. The following is an example of the data structure. ID No. Planned Date Actual Date...