Search results for query: *

lbass: You are right. Maybe its my strategy the stinks. How would you go about trying to accomplish this.. . As mentioned a product can be qualified in tbl.Category in levels 1, 2 and 3. I was trying to group by 1, 2 and 3 to narrow my results. You have shown that's not going to happen...

Lbass: I added the following fields to the details section CategoryLevel [1] Width [.5625”] Height [1.25”] CategoryID [67] CategoryCode [LL] CategoryName [Laser/Ink Jet/Copier Labels] CategoryDescription [Sheeted labels designed for laser, inkjet and copier printing] An example of the records...

Using Crystal 10. Products in my database (SQL 200) are categorized into product levels. Ultimately, I want my report to group on those levels. For example: GH1 =Level 1 (tblCategory.CategoryLevel=1) GH2 = Level 2 (tblCategory.CategoryLevel=2) GH3 = Level 3 (tblCategory.CategoryLevel=3) GH4 =...

No reply necessary. Found my error in select expert. Apologies.

I am writing a sales and commission report in Crystal 10. I have 2 databases. One in SQL 2000 and the other in Access. SQL contains all the sales numbers, order date, items, sales, cost etc. Access contains all the goals, sales, new business goals The dbs are linked based on Salesrep last...

I know this is simple stuff for most. My novice-ness is showing. 1. Under the SELECT statement jrbarnett wrote, should there be a '(' before contactid? 2. Even when I add the '(' before contactid I still get the following error. Obviously, I dont know what is causing it. Server: Msg 170...

I run a small business and I am trying to pretend I know SQL2000. Any help would be appreciated. I added a field RDI to an existing table MABIS CUSTOM in db SALESLOGIX. There are additional fields in MABIS CUSTOM. Therefore, when other fields are updated, the modify date changes. I need a...

At linetotal would be the total of the line on the new order when the formula works properly. With your changes it now works properly! I guess my version was silly :) Thanks for the help.

Im placing it in GFb by itself. When I follow your direction it does suppress when it should. However it is also suppressing GH2 and GH2a and GH2b (where the sub report is) in some cases. With the supress forumula my total sales numbers are $60,000 short. Strange. In these cases...

Running on CR10 connecting to a SQL2000 db used for order entry and sales tracking. We are attempting to track first time new orders from clients. The trigger is manual where an existing user field is being populated. In other words, if a new client buys product for the very first time, the...

Thank you in advance for any assistance you can provide. I am attempting to conditionally suppress a sub-report based on a T, F value in the main report. The problem is it is suppressing more data than it should. Running CR10. I have linked two SQL2000 dbs as follows: QWRIGHT is the sales...

Systems: Crystal reports 10, ODBC to SQL 2000. Report Premise: Calculate which business clients are new or regained clients for the current year. Do so by checking revenue from the prior year versus the current year. If the client had zero revenue in prior year and greater than zero in...

Robbie, Bob: I am most appreciative of your help. Unfortunately, I do not understand and need some clarification. Robbie, you reference three formulas @ytdstart, @ytdcalc and @06not05. These are not in my current forumulas. Do I create these as separate formulas first for use with the...

Premise of the report (CR 10.0) is simple comparing prior year’s sales to current year sales. Groups are by salesperson (useridmaster.lastname) and then by account (account.account_name) sorted by largest 06 sales on down. Requested by VP of sales is a summary of sales from accounts that...

Running on SQL 2000. My field I am trying to update is from table tblToner with field name description that is a varchar field with max 8000 char. Nulls are allowed. I want to avoid changing hundreds of fields for the same reason. For example this field value... HP Series I/LJ/LJ+ /LJ HP...

Running Crystal Reports v10 Goal: Count new accounts sold in current year vs. prior year by comparing current YTD sales greater than 0 against all of prior year sales. Problem: I have created a formula to evaluate current YTD and prior year sales to give me a 1 for any account that ordered...

Crystal V10 My crosstab summarizes phone calls made by customer service people. It counts the number of phone calls made by employees and breaks down the rows by date completed {history.completedate} and calls during each half-hour block during the day {@halfhour}. The rows are by user...

GOT IT. Sorry for the false alarm. Looks like this (unless there is an easier way!). if {history.username} = "harvey, traci" and gridrowcolumnvalue("@halfhour") in time(13,00,0) to time(15,30,0) and dayofweek({HISTORY.COMPLETEDDATE})=2 then cryellow else if {history.username} = "harvey...

I understand the formula required here. But I am struggling to modify to use it not only with time but also with day per week. In other wods, for "smith, jim" I may want to highlight time(9,30,0) to time(11,30,0) on Monday but time(12,30,0) to time(15,30,0) on Tuesday lbass, thank you for...

Thank you for your question and the help. The cross tab is placed in a username group "history.username