Search results for query: *

Thank you! Worked like a charm.

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

I am using a sql database. When I copied this to the command box I do not get any errors (no error after correct "." to a "_" in the INNER JOIN MECHANIC on HISTLINE.SALESMAN = MECHANIC.MECHANIC.NAME) but i also do not get any data. I removed the table "mechanic" and the second inner join and...

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

Thanks for the help. After lbass sent this it occured to me that i had not properly formatted the field to "can Grow" oops... That was the reason i only saw 1 group and page#

When i duplicate with new variables all i get is the first goup name and page number regardless of where index 1 is placed. see below // category index1 WhilePrintingRecords; StringVar GroupName; StringVar PageNum2; StringVar GroupName1; if InStr (GroupName, {IC_CATEGORY.LOOKUP}) = 0 then...

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

AWESOME! Worked perfectly I really appreciate your help; you have saved me tons of time!

what is {table.orderno}

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

The date formula works great as did the row formula. Unfortunately, the totals by sku are incorrect. I am using the summary that I placed in the group footer (which is the correct totals. The cross tab is placed in the report footer

You are right, I changed to the sum by group and totals are correct. I tried the cross tab and I get close but.... it is giving me a sub total by sku (which I dont need), the date is not the last date of the month(Even when set for monthly-last date in period)and if I add the sku description...

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

lbass, this works but does not reset after each record how do i reset it? the output adds each routine output together

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

No selection critera on purchase table but several on the sku_id table the selection formula doesnt seem to have any effect here is what I have : isnull ({ic_inventory_receipt_item.INVOICE_DATE}) or{ic_inventory_receipt_item.INVOICE_DATE}=...

lb, this didnt work should the Left outer Join be enforced or reversed or??? I also noticed that some of the dates are not showing from the purchase table (where data exists. The results of what is displayed checks out

similar to thread - Showing latest date from group Crystal Version 10 (see bottom of orig Post) Database Mysql 4.1 The Report sort worked! But... It is omitting items from the sku_id table if there is no data in the date purchased table (ie.new items) Thanks

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