Search results for query: *

Hello, my report is scheduled to run daily from Crystal Enterprise sending report as an email with PDF attachment. I would like to suppress printing (no email sent) if the following is true: Last Update date <> currentdate-1 I am told that suppressing printing from Crystal Enterprise is not...

Hello, my report is scheduled to run daily from Crystal Management Console sending report as an email with PDF attachment. I would like to suppress printing (no email sent) if the following is true: Last Update date <> currentdate-1 I am told that suppressing printing from Crystal Console is...

Hello, my report links 2 tables with a left outer join and compares GOAL to FORECAST using YTD SALES. Table1 = GOAL, FORECAST Table2 = YTD SALES For each record, there are 3 goal buckets and 3 forecast buckets displayed in report but there will only be data for 1 goal and 1 forecast depending...

The main report includes 2 subreports and I need to build a chart using data from all subreports along with main. I understand that I must use global variables in subreports for the chart to work. Can someone provide example code for the subreports along with main report? Main Report=forecast...

I'm building a 2nd subreport using the wizard and when I try to link subreport field to main report table, the drop box does not display all fields in my subreport table...just a partial list and the field I need to use is not in list. The wizard worked fine for my first subreport and allowed...

I'm a newbie to Subreports...I've avoided them up until now...primarily because I don't understand how to get Subreports to use certain parameters from main report in group header. My main report groups by item number and I need subreport to use item number as parameter to pull sales. My...

How do I convert Julian dates from JDEdwards tables to normal format (xx/xx/xxxx) ? Currently I'm using a cross-ref table in Excel but I'm thinking Crystal might have a formula? Thanks

How do I print selected records and not the entire report? For example, is there a way to tell Crystal to only print report if the data in field X is not null? Thanks for your help!

I am building a report that summarizes sales by customer and product and then compares the sales summary (multiple invoices for the same product summed together) to a product level goal. Each customer has 1 goal for every product so I am bringing the goal field from Goal File and placing it in...

I'm grouping report like this: Customer Name Sales period 1 Sales period 2 Product 1000 2000 I'm using formulas to calculate sales by date range as I have multiple date ranges across report. I need to summarize sales for each date range by customer...

I need to link 2 files together and only display the "new" resellers that were not in the Master Reseller file. This report will be used to capture the non-matching records only. I can't figure out the correct linking to do this. File 1 = Master Resellers File File 2 = Daily Resellers (this...

Select statement: {AgdataView.Distributor_IC} in ["0216501890000", "0091965930000", "7939627130000"] or {AgdataView.Reseller_IC} in ["0216501890000", "0091965930000", "7939627130000"] Each record in the database has both a Distributor_IC and Reseller_IC. The report needs to subtotal on...

In one report (no subreports), I need to create a custom group of customers and subtotal by the custom group AND run subtotals for each individual customer with grand total at bottom. See example below. Customers C,D,E sales need to be grouped together while Cust A and B do not. Can you help...

The below SQL works great and pulls invoices for 2007 and then sums dollars by product name. ( select sum("Sales_Dollars") from "AgdataView" A where A."Agdata Product Name" = "AgdataView"."Agdata Product Name" and {fn year(A."Invoice_Date")} = 2007 ) Now I need to use a date range and my SQL...

I am using 2 tables for this report linking the IC# fields. I need to see all invoice activity from table A and all invoice activity from table B but only show unique invoice #'s. So it's possible to have only 1 invoice from table A and many invoices from table B for the same IC#. Here's an...

Hope someone can help! I have 2 files linked: File 1: Invoice records with no prices File 2: Pricing by invoice date range and state I want to check the invoice date for each record in File 1 and find the appropriate price in File 2 by comparing invoice date in File 1 with a date range in...

I'm using Crystal v10 and need to add a formula to a grouped header that will use a different grouping. For example, the report currently groups by Distributor, then Product. On the Product group line, I need to add a formula that will only group by Product and not Distributor/Product.