Search results for query: *

I'm using CR2008 with a SQL DB and need to create a conditional sort. The report has 2 RH, 2 PH, 1 group and 1 detail section. If the user selects the detailed sales report, the first RH, PH and detail lines are displayed and I need to sort by salesperson, customer, invoice. There is no...

I'm using CR2008 v12.3.0.601 with SQL Server 2008. I need to pull a date value from a system parameter table. I need to use the date to filter the required data but there is no link between the parameter table and the production data. The parameter table has 2 fields: Cell (the one I need is...

I'm using SQL Server 2005. I got a lot of help on here a while ago getting this set up and it works perfectly except when someone enters one of the codes after one has already been used. They aren't supposed to, but it happens. I need to prevent this because it is doubling (or tripling) the...

I'm using SQL Server 2005 and trying to create a view from a single table that will select a myriad of different records based on other records it finds. I have to manipulate the dates to calculate time intervals. I have to find the time between the filedate and enddate and also the time...

I'm using SQL Server 2005, trying to create a conditional trigger that will fire when one of 2 status codes are entered. Once they are entered, I need it to get all the records from the PrintItems table that have the same job number and also have an MCC code and generate records in a 3rd table...

I'm using SQL Server 2005 I need to gather data from 3 tables, but 1 table has a 1:many relationship with the main table. From that table, I only want the first record for that case and stage. This is what I was trying (and failing): SELECT Cases.Case_ReferenceID, Company.Comp_Name...

I'm using CR 2008 with an ODBC connection to a db on SQL Server 2005. The following code does almost everything that I need. I also need to be able to calculate the average response time. I'm not sure what to use or how to convert it to what I need. My times are based on a 9 hour business...

I'm using CR 2008 with an ODBC connection to a db on SQL Server 2005. I need to calculate the difference between 2 dates, excluding non-business hours. I've almost got it working. The following code reassigns the date values correctly and calculates the difference between them correctly. BUT...

I'm using SQL Server 2005 and trying to get data from 3 tables. I can get the (simple) information from the first two tables (shown in the code) but I'm not sure how to get the third part of the data into the query from the third table. SELECT Customer.CustomerN AS '#', Customer.CustomerName...

I'm using SQL Server 2005. I need all the records from OpenJob regardless of whether they appear in either CT_LMGeneral or CT_OTD. All records in OpenJob have corresponding ones in Customer and Salesperson. I'm having difficulty with the criteria and outer joins on CT_LMGeneral and CT_OTD...

I thought I posted this already, but I can't find the thread...I'm using CR 12 with a SQL Server 2005 database. I created the main report using the wizard and selecting the appropriate tables and fields. For the subreport, I needed to do some extra manipulation, so I chose to "Add Command" from...

I'm using CR 12 with a SQL Server 2005 database. I'm using a subreport to calculate values and pass the report footer back to the main report. Each job can have an unlimited number of status codes assigned to it. If one of 4 are used, the different variables are supposed to change to indicate...

I'm using SQL Server 2005 and have written a query to be used in a 3rd party software package. I'd like to be able to either change the way the data displays, either by bolding it or changing the color, when a certain field is used. Is this possible? This is part of the code. If the first...

I'm using Crystal 12.1 with a SQL database. The data itself is perfect. I'm having trouble trying to figure out how to display it the way I want and I don't know if it's even possible in a crosstab report. The columns are sorting chronologically (Jan 2012, Feb 2012, Mar 2012, ... Jan 2013...

I've modified some code that was supplied by the software vendor but I'm not getting the results I'd hoped for. I'm using SQL Server 2005 and Management Studio. I modified the code so that records containing "Helper" in the CCName would be totalled separately from the other records (or so I...

I'm trying to modify existing code supplied by the software company to change a canned stored procedure in SQL Server 2005. I'm using Mgmt Studio. I need to modify the code so that any records that contain the word 'Helper' total the charges and hours separately from the other records. To do...

I'm using CR 2008 v12.2.0.290 with a MS SQL Server db. I'm trying to create what should be a very simple report. I'm selecting all the open (uninvoiced) jobs and I want to know the difference in the number of days between when it finished costing and when it made it to invoicing. The main...

I'm trying to select records from a table where there is no key. I'm using SQL Server 2005. Because of some data entry errors, I need to isolate all the records where they have entered StatusCode 90099 for the same JobN and then I need to change all but the last occurrence of the StatusCode to...

I'm using MS SQL Server 2005. I need to change the values in POItem but have to isolate the records using POItem and PurchaseOrder. I can't seem to get it right. This is the code that gives me the records I want. I can't figure out how/where to put the UPDATE and SET command to change the...

I'm using CR Developer 12.2.0.290 to create reports from MS SQL Server. A 3rd party Print MIS system is the interface to the SQL db. The report I created calculates the number of days between 2 tasks and everything seems to be working wonderfully except for the way it displays the 2nd date...