Search results for query: *

I thought from reading the data definitions it would be in the Link to Another trx field, but does not seem to be there. Can anyone point me in the right direction? I just want to subtract the credit form the total sale and display that amount in a Crystal Report, should be simple but is giving...

I need to get the 1st and last day of the last full 6 months ie, Feb,1,2012 and Feb 28,2012 (or 29 if leap year) Jan 1, 2012 - Jan 31,2012 - Dec 1, 2011 - Dec 31,2011 - Nov 1,2011 - Nov 30,2011 and so on. I need that series in separate fields in order to use them in a query to gather the prior...

Hello gurus! I am confused by the DATEDIFF and DATEADD options when it comes to spanning a year, or when months do not all have 31 days.. I wish to grab all dates in a 6 month range of full months, which span a year. For example, if the query is run from March 15th, 2012, the desired result...

This is causing me grief, and I have not been able to get a resolution from any of the consultants I engaged. It is a situation that will require explanation: The application we are running requires SQL 2000, but there is a second app running on the server which needs sql 2008. So SQl 2000 was...

Hello all, I am new to XML, and have looked for a solution in the list, maybe I am asking the question wrong. I have created a select in SQL 2000 to output data to a folder. All is working fine. Sample below: sp_makewebtask @outputfile = 'C:\ Hot Folder\filename.xml', @query = ' select...

I am running in circles with this one, perhaps someone can point me in a new direction. It is a MSSQL data base which stores estimate data in a single table. Each estimate has a unique number as it's ID. An estimate can be related to additional estimates by a field called MASTER, which is the...

Greetings all, I am really at a loss here, seemed like it should be simple, but up against a brick wall. Running a SQL stored procedure (SQL 2000)with several unions for a Crystal Report. Due to the large amount of data in the database, I am filtering the info in each union with an IN...

Greetings, I want to try to update some date values in a test database on SQL 2000 server. I would assume that this would work: update JobTable set datepart(yyyy,jobdate) = '2009' But no, syntax error Incorrect syntax near '('. I have tried a few other ways, with again no success. Perhaps...

Hello all, I have a SQL database and am writing a query to return records based on a date. This is desired to be automated, so each time it runs, it looks at past date date. Problem is the SQL data is stored without the time portion. So it's '2008-05-19 00:00:00.000'. Or course, getdate()...

I have a string created by a formula to replace some words in the string, so it looks like this: W~1~1~1~SHW~1~5.5~1~1~ Each of the numbers shown between the ~ can be 2 didgit, with the 5.5 also can be 2, plus one dec place. The alpha characters (W and SHW) will always be 1 (W) or 3 (SHW). I...

Greetings all. Working with Crystal 10 and a progress database (ODBC Connection). There are 2 fields which hold the saleman code number and another with commission rate. Problem is the field can contain more than one salesrep and the 2nd can hold matching commission rates. Example...

I have an English database (VFP and SQL) which needs to write some spanish reports from. Has anyone attempted this, and can oyu offer any advice as to what is involved? I checked the Crystal site, and struck out. Thanks in advance.

I need to extract and display a date from an order number. The order numbers are XXYYYYDDDAAA with XX being a two letter code for product type, YYYY is the year, DDD is the day of the year with Jan. 1 being 001 and Dec. 31 being 365. The last three characters, AAA are the number of that order...

Crystal 10. When emailing reports, the STMP is inserted in front of the email address. Ant ideas as to why?

Hello all, I am helping out with a project, and am fixing up some old reports for the client. One of them has me a bit bewildered, as I have never run across it before. Crystal 10.0 Developer version. The report has the page header and footer removed, they felt it was not needed so deleted...

I am new to triggers, but have found a need to create one. I am spinning round in circles, and may have missed the solution! Here is what I am doing: SQL Server 2000. I have a data base that stores job and cutomer information. I have a trigger to update a new table with specific information...

I also posted on the other forum, but thought maybe some of you might have something on this problem. Custom tractor fed form set up in Crystal 10. Form was designed on an Epson LQ2550. It runs awesome. Client has Epson LQ1000, so driver in report was changed prior to sending to user. It...

Custom tractor fed form set up in Crystal 10. Form was designed on an Epson LQ2550. It runs awesome. Client has Epson LQ1000, so driver in report was changed prior to sending to user. It persist in running 11in (letter) size. All settings on user machine verified for 9.5 X 7 fanfold form. The...

Hello all, I am working with a SQL 2000 database. One table hold employee names, in a varchar(28) filed. The names are stored in a single string seperated by a blank space (such as Joe Brown). What I would like to do is pull out the last name only(the right of the space). I am aware of a...

Anyone seen this? I am adding a view from a SQL 2000 database. The field is in the Crystal SQL, but even after I verified the linking ( a simple inner join) in the Linking tab, Crystal does not add the Join statement to the SQL. So of course, the field is not recognized by the report. Happens...