Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mabis
  • Order by date
  1. mabis

    Multiple Groups from Same Table Field

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

    Multiple Groups from Same Table Field

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

    Multiple Groups from Same Table Field

    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 =...
  4. mabis

    Return Value Based On Month Number

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

    Return Value Based On Month Number

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

    Copy data from old table to new

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

    Copy data from old table to new

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

    Formula is returning all zero values CR10

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

    Supressing Subreport On Formula

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

    Formula is returning all zero values CR10

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

    Supressing Subreport On Formula

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

    Summary field for existing formula in Crystal 10

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

    Cant Summize a forumula field

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

    Cant Summize a forumula field

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

    Update A Portion Of A Field Text Value

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

    V10 My running total field not avail to SUM

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

    Show Zero Values In A Cross Tab

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

    Conditional Format On Time In Crosstab v10

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

    Conditional Format On Time In Crosstab v10

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

    Conditional Format On Time In Crosstab v10

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

Part and Inventory Search

Back
Top