Search results for query: *

I need to produce a report which shows the invoice details as well as the serials that was shipped. The invoice details is simply 1 row per invoice number. The problem is when displaying the serial numbers, as they are a one to many serials can be shipped for each invoice. I've tried used a...

Hi, I need to update the modified date/time of all queries to have a particular date and time. This would be similar to a 'TOUCH' command. By having all queries with the same date/time, Auditors can aesily tell is a query has been modified. Does anyone have some code to do this as a SQL...

Hi Win2000 sp 4 and Excel 2002 sp3 does not open the picture via a hyperlink using the associated program. It always using MS Photo Editor. In Win2k, i've associated a the file to open using IE, but the hyperlink in Excel always uses MS Photo Editor. Does anyone have any solution? Thanks...

Hi, How does an administrator specific entries in the Freq Contacts address book for all users? GW 6.5 e.g We had a name setup for sending email to a help desk. The help desk structure has changes so we created 2 new addresses but do not want users to send email to the old address. The old...

CR/CA/CE 8.5, SQL Server 2K I've been using CR for a couple of years, but I have never used Analysis (i've used Cogons Powerplay before though). I'd like to be able to build a cube that can also be 'drill through' to a Crystal report passing paramaters from the cube at the level that i am...

Cr 8.5 SQL Server 2000 Hi All, Can someone give me a pointer on how to approach a problem on a report to show the consumption of consigned stock? The logic is a bit complicated but here goes. The expample has 3 items, A,B,C The customer was given a qty(opening balance) of 100 on 31/08/2004 for...

SQL2k There are realy 2 parts to the question. 1) Clustered Indexes. I have a clustered index made up of a couple of fields. What I have noticed is that the data is not sorted in the clustered index order UNLESS the index is rebuild using DBCC DBREINDEX. Is this correct? The sp to populate the...

SQL Server, CR 8.5 I'm trying to put a report together which shows the consumption of stock within a site,calander period, item. The report needs to show in which month the stock was fully consumed. If the stock is over consumed, I want to show the QTY for 31-AUG-2004 The starting Qty is the...

Hi all, I have a test installation of SQL 2K sp3a on NT 2KServer sp4. Its actually a copy of my production server on anther pc. I find that some queries/stored procs appear to hang(more than 20min) until the server is restarted. Then the same sp runs faster, approx 2min. The enviroment is a...

Hi, I could think of a appropriate Subject, but I need help puting a query togther. It can also be a stored proc if thats the way to go. Table1 - Master data OrderNo char(10), CostingDate datetime 1, 2004-04-01 1, 2004-06-01 2, 2004-04-02 2, 2004-05-02 2, 2004-06-02 3, 2004-06-03 Table2 -...

Hi, CE 8.5 AS part of the first run time of CE it installs a 1.6Mb active x control (OCX) for the viewing of reports in IE. How do you pre install the OCX on a new PC installation to avoid the first time install? The reason for this is, we have some remote sites on a slow WAN link, so we want...

Hi, CE 8.5, SQL 2000 When I export to Excel, (CE), the column is formated to 4 decimals (as per CR format), but when looking at the Excel cell data, the data contains more decimals, say 6 decimals. In CR 8.5 exporting (data only) it truncates/rounds the cell data to 4 decimals. Is this a...

CR8.5, SQl Server 2k. I'm trying to put a report together that shows Variances. There is a Variance Table and Linked to it is a ItemAgreement Table via left outer join on Item The ItemAgreement has Item and AgreementType in it. A Item can have many agreement types. Agreement TYpe is also a...

Hi I 'm trying to update a header table field [ahseqn] with the maximum value of the detail field [aiseqn]. I have written the query using inner joins, but I'm struggling to convert it use 'where' statements so I can use the Update statement. While i'm testing, I'm using the SELECT statement...

Hi, SQL2k For Testing purposes only, i'm trying to write some sql using the Legacy Syntax, not the SQL-92 syntax. Use NORTHWIND SELECT customers.contactname, orders.freight, employees.Firstname from customers, orders, employees where customers.CustomerID*=orders.CustomerID and...

Hi All, CR8.5, SQL2k I've been using CR for about 2 years using tables and views. But I've never used a SP as a data source. I have a performance issue with a report that needs a parameter passed to a subquery. Subreports are too slow, I don't believe its possible to use a view because of...

Hi All, CR 8.5, SQLServer 2K Within Crystal I want to write a subselect query that accepts a paramater. I know you can achieve similar results with Sub reports, but they can slow reports down. How can you do it with pure Crystal? The scenario is, you want to see every part number in the item...

DB is SQL2k. In a previous posting I raised, thread183-758412, I didn't get any suggestions so decided to go down the Cursor route with some sucess. I've got the stored procedure which outputs dynamic sql. The output is simply a series of Select and Union statements. e.g a sanitised version of...

CR 8.5, SQL Server 2000 I'm trying to get the record selection formula to be passed to the WHERE clause of the SQL. I'm only seeing the first 2 lines been passed. The remaining part, with the nested IF then else Block, is not been passed. (It gets processed on the client which slows the query...

I'm running SQL2K std and Win2k I'm trying to write a generic procedure for a data checking report. The basic requirements is to validate certain columns of a table with another table thats has the correct value. The output is to show only incorrect values eg. the key , the fieldname, the...