Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gc6294

    Search for a character in Oracle SQL statement

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

    Search for a character in Oracle SQL statement

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

    Modifying Macola ES Crystal Report

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

    Modifying Macola ES Crystal Report

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

    Sorting on a field in Data area on pivotable

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

    Sorting on a field in Data area on pivotable

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

    Sorting on a field in Data area on pivotable

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

    Sorting on a field in Data area on pivotable

    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?
  9. gc6294

    Upgrading to SQL Server 2005

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

    Lightweight Pooling mode

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

    SQL Server Backup vs tape backup

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

    While{PrintingRecords and Record Selection

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

    While{PrintingRecords and Record Selection

    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 :=...
  14. gc6294

    While{PrintingRecords and Record Selection

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

    While{PrintingRecords and Record Selection

    Can you do section suppression in 8.5? Not sure where?
  16. gc6294

    Remove Excel lines with an empty cell

    Thanks - I was hoping for something a little less manual, but, yes you are correct, that would work.. Thanks
  17. gc6294

    Remove Excel lines with an empty cell

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

    While{PrintingRecords and Record Selection

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

    Get date ranges thru parameter (previous year)

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

    Maintenance Plan sql 2000

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

Part and Inventory Search

Back
Top