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

These are formulas. It works...thanks! Never saw the suppress function within format field...thanks again! I'm submitting another post for another question.

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

Madawc, I was able to pass only 1 shared variable to main report but I need to pass many values in each subreport to main report. Here's what I'm using right now just to see if I can pass 2 variables from one of the subreports: Subreport formulas: shared numberVar July_Sales := Sum ({@July...

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

The data types should be the same in both tables but for some reason they are not. I was able to use another field where the data type did match and I got the link setup ok. Thanks

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

Thanks. I discovered that the link to main report table was never in place...somehow I missed it when using the subreport wizard. Works fine now.

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

Thanks to all! I used this code from briangriffin and it worked great: whileprintingrecords; numbervar x; numbervar y; x := 2000 + tonumber(mid(totext({juliandate},"#",0),2,2)); y := tonumber(right(totext({juliandate},"#",0),3)) - 1; dateadd("d",y,date(x,1,1)) Nice job....thanks again!

My Julian date is a different format coming from JDEdwards: 110196 = 07/15/2010 with char 2,3 being the year 2010 and 196 being the day of the year. Not sure the purpose of leading "1" but I don't need the first character....just the last 5. Any suggested formulas? Thanks

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

Excellent! Thanks it works! I added a statement to record selection to eliminate records that didn't meet criteria.

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

Thanks. I figured out my problem. My formulas were already summing so Crystal won't allow me to sum a sum. I had the formulas in header but did not have them in details line. I removed the summarization from formulas, put them in detail line, then put summary of that back in header, and then...

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

lbass - I tried your approach and it worked great! Thanks!

I tried this and it still doesn't work. Do I use inner or outer join? Enforced, not enforced? Does the link point to the Master file or Daily file?