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
  • Content: Threads
  • Order by date
  1. 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 =...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. mabis

    Selective running total in a cross tab v10

    I am running v10 CR on top of SQL Server 2000. My cross tab counts the number of phone calls made based on a result code (rows) which is the history.result field. My columns are based on date using history.completeddate. Some sample date from both fields are as follows: history.result 21 RDC...
  12. mabis

    Conditional Format On Time In Crosstab v10

    First, thank you for any help you can offer. Running on CR v10 and SQL 2000. My cross tab offers the results of sales phone calls in my rows and my columns are broken down by half hour. For example: 9:30 10:00 10:30 completed 15 5 3 attempted 2...
  13. mabis

    Archiving Crystal Formulas

    I am running Crystal 10. Most of the reports I am creating reference 2 SQL DBs and I tend to find use for the same formulas in multiple reports. Copying and pasting them is tedious. Is there a method to archive them for use in other reports. I have referenced the net and my multiple manuals...
  14. mabis

    If IsNull Always Returns Alternate Text

    CRM program running on SQL2000. Attempting to evaluate contact titles that are null. In SQL title field is datatype=picklist, size 64, nulls allowed. In all cases my formula returns "No Title" when sql query verifies some title fields are populated. if isnull({CONTACT.TITLE}) or...

Part and Inventory Search

Back
Top