Search results for query: *

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

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.

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

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

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

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.

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

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.

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)

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.

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

The year has some 1990's also...

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

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

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

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

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?

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

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)

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?