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.

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

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)

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

Is there a way to make Crystal reports run faster or more efficient? I am using Crystal XI against an AS400 database. I have 5 sql expressions and linking to 5 tables, but I am only pulling directly from 2 of them. There are 4 running totals and about 11 simple formulas. The 2 tables that I...

Hello, I am not sure if anyone has had this problem, but I am trying to use the date criteria in a sql expression. I can do it manually, but is there a way to make the field = month(currentdate)? When I put this in a sql expression it says column currentdate not in specified tables. What is...

I have read through the threads and see that I can not sort on a variable that I pass to the main report from the subreport, but can I sort if I use the command select feature? Let me explain what I am trying to do: I am having a hard time creating a report the uses a summed field from 1...

I am using version XI and I have a report that contains a subreport. I need to suppress the data in the main report when the subreport is not null. Can this be done in Crystal. In other words can I show the data in the main report when the subreport is blank or null? I have tried using a...

I have a report where I only need to display the summary of a part number by date. I created a crosstab using the part number for the row the date for the column and sum(qty) in the summarized section. When I suppress the date label, the report still shows the white space where the date would...

Can someone please help me with a cross-tab delima? I have to insert a cross-tab to show: row: Part column: date Summary: quantity on hand I can create the cross-tab, but I only want the numbers to display. When I suppress everything else, the report still leaves space where the suppressed...

I have a crosstab in a subreport. The crosstab has rows that are blank and I have suppressed blank section set in the main report and in the subreport. The section is still not being suppresed. It shows space where the crosstab should be. Help please!!!

I need to convert multiple row into a single column separated by commas. I read another thread that tells me how to do it, but the comma is either is added to the end. How do I stop the comma from appearing at the end. Example: Id 1 2 3 4 4 Need to display: id 1,2,3,4,4 It currently...

I am trying to use a field as a dynamic heading but I am having trouble creating a distinct list as the heading and making the data line up with the appropriate heading. Currently, the heading will on show up for the one piece of date. Program Project Status Release date...