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: mwmark
  • Content: Threads
  • Order by date
  1. mwmark

    group selection

    SAP crystal 14, sql DB. I have a simple sales report that i want to see ONLY invoice details for invoices that have both sales classes on the same invoice. Not either /or I am excluding all other sales classes in the select expert. Group 1 is invoice, group 2 is class. details are invoice...
  2. mwmark

    sql select syntax

    Firt time using "add command" in the database expert in crystal 2011 for a sql database and need a syntax check. I have a working report created with crystals database linking but the tables are huge and the report takes too long. Attempting to speed up a report by only bringing in columns i...
  3. mwmark

    second groupname index

    using crystal 10 and sql db i have a 3 step index in place for report and want to add an additional group index for group3. *My goal is to show all groups printed in the index(s)* Current working index: //index 1 placed in group footer 2 WhilePrintingRecords; StringVar GroupName; StringVar...
  4. mwmark

    data selection

    Using crystal 10 and a sql db. I have a report that re-assembles my sales orders and works great, but i want to only see ENTIRE orders that have a specific sku_id. Grouping by salesman,customer name,order number, then details (including sku_id), footers. when i try and select a sku_id in the...
  5. mwmark

    totals by month

    I have a Crystal 10 report (sql db) that uses a running total to calculate the total sales by sku(range determined by user). What I need is to break that down by month on each sku. I was going to create a running total for each month, but was hoping for a better way Sku: Jan Feb Mar Apr...
  6. mwmark

    second column format

    How can I make the second column display evenly with the first(below group header 1). The displayed info is in group footer 2. (there are 3 groups in this report) When I format details in the section expert using multiple columns(down then across) the second column starts below the page header...
  7. mwmark

    extracting part of a string

    I am trying to split a string and extract the numbers left of the first 3 consecutive letters. data: 1234567abc4k4k4w 1234abc656565sdjfs 123456789xyza56566 desired output 123456 1234 123456789 fyi:crystal 10, sql db, Any help would be appreciated
  8. mwmark

    Latest date from table

    I am creating an inventory reorder report and have a similar question. I want to display only the last date purchased of the selected sku_id. I grouped by Sku_id and suppress the details, then added the purchase date (from a seperate table) to the group footer with other displayed info. This...
  9. mwmark

    email address check

    Does anyone have a routine to check a string to see if it looks like a valid email address. example: does it have a "@" in it are there spaces or other invalid email Characters?
  10. mwmark

    Another reading character from string and extracting portion of string

    I am trying to look at a string and find a character ("s" in this sample), then display the remaining text after the "s". Sample data: 2857516MAS75330 3057016MAS75333 2253519MAS4472017 Desires result: 75330 75333 4472017 I tried using the thread "reading character from string and extracting...

Part and Inventory Search

Back
Top