Search results for query: *

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

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

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

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

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

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

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

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

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?

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