Search results for query: *

Hi, I'm trying to create a Select statement searching for a character ° (<alt> 0176) within a field... I've tried a few things, including the below.... SELECT "REMIT_TO"."VENDOR_ID", "REMIT_TO"."ADDR1", "REMIT_TO"."ADDR2", "REMIT_TO"."ADDR3", "REMIT_TO"."CITY", "REMIT_TO"."ID"...

Is there a standard procedure one should take when modifying a standard Macola ES Crystal Report? Should the report be modified on the Network distribution folder? Should the report be renamed or should I just modify the original? It will then need to be copied to the C:\Program Files\Exact...

I have a Pivottable Excel file that uses calculated fields in the DATA section. Is there a way I can sort on a column in this summary area? I saw somewhere to do Field Settings, then click on Advanced, but I don't have an Advanced... Any ideas?

I'm in the process of moving to a SQL Server 2005 server running Progression 76.400a. I assume I need to install SQL 2005 client software on each workstation. Do I need to delete the SQL 2000 client first? Do I need anything installed on the 2005 client other than "Client Components"...

I am unable to modify Maintenance Plan - get an error 14258 . Cannot perform this operation while SQLSERVERAGENT is starting. Appears it is in Lightweight Pooling mode... http://support.microsoft.com/kb/303287 Any problems with just turning this mode off and restarting Services? Hopefully...

Just was hoping to get everyone's thoughts on the merits of doing SQL server backups thru a maintenance plan to bak files vs. not doing sql backups and relying on a tape backup software with a sql agent. I was always under the impression that you should use a combination of both - if you need...

Is there a way to execute a script that would remove all rows in an Excel spreadsheet if a certain cell on that row is empty. For example, would like to automatically remove all rows where cell H in that row has no value. Is that easy to do? Thanks

I have a problem that I want to do a Record Selection on a Crystal 8.5 report based on a formula that uses a WhilePrintingRecords function. The report is a sales report - when it hits an item of a certain type it assigns a string "TEST TYPE" for the remainder of items in the order until the...

Anyone have ideas on how to do this. I need to create a report showing total sales by customer. The Report will only have 2 data columns, total sales in the current year up to date that the user enters in thru a parameter. The other column will have the total sales for the same date range in...

I am unable to modify Maintenance Plan - get an error 14258 . Cannot perform this operation while SQLSERVERAGENT is starting. Saw another post to check if it is running fiber mode processing - it is.. How do I change? Should I change? Any adverse affects of changing? Any idea how it changed...

When I use DTS to copy a table from 1 database to another, where the table already exists in the database I am copying to, will it overwrite the existing table or will it append the data to what's already there? Thanks..

Anyone ever have luck exporting cleanly a standard Macola report to Excel (not a Crystal Report)? I understand how to print to file then trying to format within Excel by using delimiters or fixed width. However, this is a somewhat painful process and the results are typically pretty ugly. Is...

I need to create a crystal report off of a MS SQL 2000 database. The report is an customer address master report, with the customer info coming from CUSTOMER_SQL and delivery, billing , etc addresses coming off of ADDRESSES_SQL. I'd like to format everything on one line, such that I can put...

Am on 7.6.300 Pervasive 2000. Need to get to 7.6.400a Pervasive 9.5. Can anyone suggest an upgrade path for a 1-time install? Is 7.6.400a compatible with Pervasive 2000? I was thinking of doing Progression 400 upgrade first then doing Pervasive Upgrades because Pervasive Version 9.1 is...

I have an excel file that is used as a data file for a number of PivotTables. The Excel Data file is created from a Crystal Reports export and is re-created frequently. Is there a way to automatically create a Dynamic Named Range each time the Excel Data file is created?

Have two pivottables working off the same Excel data file on the same 'tab' in a Pivottable worksheet. One is on top of the other. It seems that if my 'top' pivot grows in detail (# of rows increase), then it tries to overwrite my bottom pivot. I would prefer it just push my bottom pivot down...

Just looking for ideas.. I have a series of pivottables used for sales analysis. The reports are created via a crystal report reporting off of a SQL database. The Crystal Report is exported to a pivottable data file, then linked to the Pivottable Excel sheet. The problem is the Pivottable...

I have a Pivottable (Excel 2003). In the drop-down selection box for the columns, I have a lot of old data values that are no longer used in my report. Is there a way to remove these old values from the drop-down selections?

I'm looking for the best way to format a formula in Crystal. Would like to say something like this if @STATE_COUNTRY='France' or 'Germany' or 'Hungary' etc... Then 'Europe' if @STATE_COUNTRY='JAPAN' or 'China' etc then 'Asia' What's the best way to format a formula like this - I seem to get...

I have a SQL Server 2000 database. My company does a lot of business with Chinese vendors and customers. I would like to have some of my forms print out in Chinese in addition to English with the rest of the database basically in English. I was thinking of adding some cross-reference tables...