Search results for query: *

In SQL Server Management Studio Express: when running queries and sending the results to txt I get blank lines (or returns?) at the end of the results. Does anyone know where these blank lines are coming from and how to stop them?? Thanks...

I'm using Crystal 8.5, having difficulty pulling XML data in. How can I tell what the table and row hints should be to pull the data in (assuming that's the problem)? I'm connecting and getting the following fields but no other: <lastauthor>, <created> and <version>. I get no other fields and...

My data is as follows: 7/9/2008 12:44:32 AM. I need to use the number option in pivottable field (lower right) to format this field as the time alone - but I don't have access to the number button - ??

I have a date/time field with the following data as an example: '4/8/2008 12:03:14 AM'. I need the correct syntax to select just the time in this field. Can anyone help? Thanks...

Having no luck trying to get precision 2 data in a stored procedure. I've tried variations of the following logic with no success. Can someone help? Thanks... SELECT CONVERT(DECIMAL(10,2),SUM(PRD.Pages*GrossFolder)/1000) MGP FROM...

Data looks like the attached: product order press printed overrun waste % newspaper1 10,000 4 5,760 newspaper1 10,000 5 5,840 newspaper1 10,000 n/a n/a 1,600 Summary 10,000 All 11,600 1,600 xx.xx What I need to do is calculate a waste % based on the information that is found...

First sheet is SUMMARY1, summary information pulled in w/MS Query: Press No. 1 (cell A2) 2 (cell A3) 3 (cell A4) 4 (cell A5) 5 (cell A6) 6 (cell A7) 7 (cell A8) 8 (cell A9) Second sheet references first sheets info as follows: =IF(summary!A2<>"",summary!A2,"")...

I am receiving a strange error message when 1) starting Crystal Reports XI and 2) closing a report within Crystal Reports XI: Internet Explorer Script Error - an error has occured on the script of this page. Line 51, Char 2, Error 'document.getElementById(...) is null or not an object', Code 0...

I'm running Windows XP, using Crystal Reports XI, accessing a ProvideX 6.2 database. I'm working with an invoice detail table that has over 500,000 records and trying to find a way to position to a specific record as a "starting" point so the whole table doesn't have to be read before it returns...

I'm running Windows XP using Crystal Reports XI (Developer - evaluation copy), accessing a ProvideX 6.2 database. When writing a new report (using Standard Report Wizard) and selecting two tables (i.e. po_po_header and po_po_lines) I get the crw32.exe error and Crystal shuts down. In some cases...

Hi, I'm running Tapeware 7.0 on a Windows 2003 server. The selected backup has been saying "formatting media" for quite some time. The drive is a PowerVault 100T, the tape is new - DDS4. Does anyone know how long formatting media is supposed to take? Assuming it's taking way too long, any ideas...

I'm running Crystal Reports 8.5 and am having a problem with the parameters. I have a primary detail report and a subreport that is a summary report. My parameters are identical for both reports - from date, to date and product line. When I edit subreport links it attempts to link ?from date to...

getting an error message trying to get some logic correct in pervasive.sql data manager so I can use the code in crystal reports 8.5. in essence I'm trying to obtain similar information from 2 tables - a header and a history table - so I can consolidate the information and use it in a report...

In the detail section I have something along these lines: if part = &quot;1100&quot; and flag_closed = &quot;y&quot; then date_closed else _______ - what I need here is a null if that's possible. The only thing that seems to work is placing date('01/01/01') in this spot but I really need a blank...