Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ewarr

  1. ewarr

    How to suppress printing entire report within Crystal Enterprise

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

    How to suppress entire report from printing within Crystal Console

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

    How to suppress printing a specific field if result is zero

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

    How to suppress printing a specific field if result is zero

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

    How to use charts with subreports

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

    How to use charts with subreports

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

    Subreport Wizard linking problem

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

    Subreport Wizard linking problem

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

    Subreport parameters

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

    Subreport parameters

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

    How to convert Julian dates from JDEdwards tables

    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!
  12. ewarr

    How to convert Julian dates from JDEdwards tables

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

    How to convert Julian dates from JDEdwards tables

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

    How to print selected records only

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

    How to print selected records only

    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!
See more

Part and Inventory Search

Back
Top