Recent content by mwmark

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