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!

Search results for query: *

  1. pl1101

    create previous month to date

    Hello, I am trying to create totals comparing month to date and previous month to date. I created start previous date by using minimum(Lastfullmonth), but I can not figure out how to find the previous month to date. For example if today is 10/21/2013 how do I find 09/21/2013? Can someone...
  2. pl1101

    Weekly interval Date

    Please help! I am trying to create a chart that groups on a weekly basis, but the week need to start on Wednesday to Tuesday. The chart will count customer id's per week. Using Crystal Reports 2000 on a SQL Server database. Thank you for all of your assistance.
  3. pl1101

    Update statement with multiple tables

    I have figured it out... I have a duplicate problem. This can be deleted...
  4. pl1101

    Update statement with multiple tables

    Hello, I have need help in modifying an update statement. I am bringing back a number of rows with my sql, but when I add the update piece it updates less rows. -- update APPLICATION --set PRIMARY_PARAM ='Something Special' (800 rows) where app_id in (select...
  5. pl1101

    Need to create a matrix

    Help me please! Having trouble figuring out the best approach. These are formulas where datepart("q", date)= 1...2...3...4 I have a report that pulls dates by year and quarterly example: qtr1 qrt2 qtr3 qtr4 2009 01/01/2009 04/05/2009...
  6. pl1101

    Convert number elements to date

    I have 3 date elements that are number datatypes. The year is a number like 1,2,3...95, 98,99. Can you help me convert to a date? day and month are the same datatype as year.
  7. pl1101

    Need to hide null value bar on a stacked bar chart

    I have a report that I need to create a stacked bar chart. The chart appears to work correctly except I have a bar that totals my null values. I need to hide that bar. Does anyone know how to do that. I am using Crystal reports 2008. Against an Oracle database. The chart uses a formula field...
  8. pl1101

    Creating SQL Expression with alias

    I am using version XI R2... I have a report that needs to pull in the parent of a table and then reference the child in another table. The quantity is link to the parent and the same table(alias) has to be linked to the child to get the quantity.
  9. pl1101

    Creating SQL Expression with alias

    How do you create a sql Expression using an alias. When I try the creating from a duplicate, but changed the table to the alias, I get an error message that the table cannot be found. Example: (select sum(req_1.qty) from req_1 where mstr_1.pn=req_1.pn)
  10. pl1101

    Bad Date format error

    Well this looks like it is working, but now I get an error "A day number must be between the number of the days in the month". How do you check for the days of the month? Thank you sooo much for the assistance.
  11. pl1101

    Bad Date format error

    if the year should be 1995 then it is stored in the database as 95.00 (number)
  12. pl1101

    Bad Date format error

    The year has some 1990's also...
  13. pl1101

    Bad Date format error

    Now is says date must be between 1 and 9999. I added another if statement numbervar yylen := len(TRIM(totext({LQSPCDT2.SCACYY}))); numbervar yyval; if yyval in [1 to 9999] then if yylen = 1 then yyval := 200+{LQSPCDT2.SCACYY} else if yylen = 2 then yyval := 20+{LQSPCDT2.SCACYY}; date(yyval...
  14. pl1101

    Bad Date format error

    I get an error " a string is required here" numbervar yylen := len(TRIM({LQSPCDT2.SCACYY})); numbervar yyval; if yylen = 1 then yyval := "200"&{LQSPCDT2.SCACYY} else if yylen = 2 then yyval := "20"&{LQSPCDT2.SCACYY}; date(yyval, {LQSPCDT2.SCACMM}, {LQSPCDT2.SCACDD}) ---it highlights the...
  15. pl1101

    Bad Date format error

    I didn't realize that I didn't have to convert. The fields are numbers. The problem is that the year is 2 digits. How do I make 10.00 "2010" and 8.00 "2008" and 0.00 to 2000 for the date? if {LQSPCDT2.SCACYY} IN [1 to 9999] then date({LQSPCDT2.SCACYY}, {LQSPCDT2.SCACMM}, {LQSPCDT2.SCACDD})...
  16. pl1101

    Bad Date format error

    I have 3 fields and I need to convert them to a date and use a parameter. scamm scadd scayy when I do this then I get the "Bad date format string" error. I used the date(totext,0,"") functions. Crystal XI release2 and AS400
  17. pl1101

    Trying to make Crystal Reports more efficient

    I read that I need to include the tables that I use to create the sql expressions. I took out 1 of the fields and removed 2 of the tables, and the report does run for a few minutes and then it freezes. Is there a way to find out on what record or at what stage the report hangs up?
  18. pl1101

    Trying to make Crystal Reports more efficient

    SELECT DISTINCT "FGFC"."FCMO", "FGFC"."FCYR", "FKITMSTR"."IMDSC", "FGFC"."FCCNQ", "FGFC"."FCBK", "FKITMSTR"."IMSTS", "FKITMSTR"."IMSRTF", "FKITMSTR"."IMPN", "FGFC"."FCCSUM", "FKITMSTR"."IMAWRK", "FKITMSTR"."IMBUY", "FGFC"."FCCO", "FPWRKCTR"."WCSDES", "FPWRKCTR"."WCNO", "FTREQ"."DPQTY"...
  19. pl1101

    Need to sort on a variable or command field used in a formula

    If I need to use these sql expressions in a calculation, how do check for null and create a final equation? and allow for division by zero? for example: If I need to use ({%sql_exp1/({%sql_exp2 +({%sql_exp3)
  20. pl1101

    Trying to make Crystal Reports more efficient

    I checked Check under Report -> performance information -> processing -> record selection done on database should be yes. and it says partial. Can I change this value?

Part and Inventory Search

Back
Top