Recent content by gc6294

Thanks!!! I had thought I started with that, but must not of.... Thanks!!!!!

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"...

Well, I'm running it thru ES because I'm just modifying an existing Macola Report. If I removed it from ES and made it Standalone, would need to create my own parameter and Record Selections... I really just need to do some slight modifications to existing Macola ES reports. What is the...

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...

awesome.... That did it..Thank you all....

Thanks for the help - appreciate it...yes, that is how my pivot is set up.. However I want to sort the rows based on the values in one of the columns.

Not sure I get it... don't have row names? I have column names in the DATA section..

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...

Thanks guys... must have been tired.. Tried the same thing 3 times .. finally looks like it worked... Thanks again to everyone

My formula for determining the testtype is: WhilePrintingRecords; StringVar ItemNo; If {Itemmaster_SQL.commodity_cd} = "testtype" then ItemNo := {Orderlinehistory_SQL.item_no} else ItemNo := ItemNo I then have a field that resets it in the Group Header WhilePrintingRecords; StringVar ItemNo :=...

thanks LB - Sounds like you are on to something but I just can't get it to work.. Still shows all records.. must be something I am doing...

Can you do section suppression in 8.5? Not sure where?