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!

  • Congratulations strongm 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. Ktwhite

    XP Internet Security - Rogue Program

    Thanks everyone for the great solutions. I did manage to download the following programs which seemed to help quite a bit: 1. Malwarebytes Antimalware 2. SuperAntiSPYWARE Before that however, I downloaded this program called Rkill which shuts the spyware down, but does not remove any of the...
  2. Ktwhite

    XP Internet Security - Rogue Program

    I have this program on one of my computers called "XP Internet Security". It is definitely not part of "Microsoft Security Essentials". I did a search on this program, and I saw a posting that indicated it is a virus. The posting stated exactly what this program is doing to my computer. When...
  3. Ktwhite

    Scheduling Reports in Crystal 8.5

    Thank you for the clarification. Ken
  4. Ktwhite

    Scheduling Reports in Crystal 8.5

    Thanks for the excellent wrap-up. I have used the CR Distribution Tool with v7, and it does have it's limitations. I did download the scr8 distribution executable from the CR website, although I'm not sure it will work for us. I'll give it a spin in a test environment. Ken
  5. Ktwhite

    Scheduling Reports in Crystal 8.5

    WOW! Thank you very much for responding to my thread with all this good information. Ken
  6. Ktwhite

    Scheduling Reports in Crystal 8.5

    Using the Crystal Reports 8.5 Developer edition, and/or the Crystal SQL Designer Tool, is it possible to Schedule reports to run at a specified time and date without using any of the Crystal Web Components? Since we will be using Crystal Reports to support many of our clients, using RDC with...
  7. Ktwhite

    Data Field Association Without Table Links

    Thank you for the response. The database type I am using is USQL version 3.10. My report consist of a total of 6 tables, which attempts to list pets and their owners with name and address information, and the pet license number. Within the database there is a file called CENA (Central Name...
  8. Ktwhite

    Data Field Association Without Table Links

    I need to associate two fields in a report which cannot be accomplished through links for a particular report within Crystal 8.5. Since the "Where" clause is not allowed, is there a way to duplicate the following select statement via formulas? Thanks. SELECT SL_RECORD.SL_FUND...
  9. Ktwhite

    I attempting to create a SQL Statem

    Thanks so much for your response. I will review the on-line help to more familiarize myself regarding formulas with respect to SQL Expressions. One more thing...The reason I have been looking into SQL Expressions, is because of some linking problems. I am linking from one primary table to two...
  10. Ktwhite

    I attempting to create a SQL Statem

    I attempting to create a SQL Statement within Crystal Reports 8.5. I visited a number of forums, reviewed the Crystal Knowledge Base website, and have been unable to create a successful query within Crystal Reports. I have been able to run numerous successful queries within USQL, through which...
  11. Ktwhite

    Group Sorting Difficulty

    LISA; Thank you soooo...much! Your suggestion to change the background color was right on target for my problem. As a result, I was able to identify the 'extra whitespace' (which would have never occurred to me as the problem), then "Suppress" tne section. Thanks again Ken
  12. Ktwhite

    Group Sorting Difficulty

    Thanks again, however it is my understanding that this site only supports anonymous contact, and as a result I am not privy to information on how to communicate with specific individuals. Perhaps you know of a particular location /website that deals with "Grouping" within Crystal. I...
  13. Ktwhite

    Group Sorting Difficulty

    Thanks for the response, but I am not quite there yet. For this particular report, I have the "Keep Group Together" option 'ON' for Group 4 only; a "page break after" for Group 3, and a "page break after" for Group 4. I have also Suppressing blank section on each...
  14. Ktwhite

    Group Sorting Difficulty

    ...detail 6961 WATER O & M TRANSFER 677,849 detail PARENT 6900 905,868 grp4 subtotal 5253 SALES TAX2 2,257 detail 5255 R & B 4,785 detail PARENT 5200 7,042 grp4 subtotal ** TOTAL REVENUES 912,910 group 3 subtotal Ken
  15. Ktwhite

    Linking 3 Tables

    ...detail 6961 WATER O & M TRANSFER 677,849 detail PARENT 6900 905,868 grp4 subtotal 5253 SALES TAX2 2,257 detail 5255 R & B 4,785 detail PARENT 5200 7,042 grp4 subtotal ** TOTAL REVENUES 912,910 group 3 subtotal Ken
  16. Ktwhite

    Reversing The Sign On Account Balances

    Thank you for clearing this up for me. &quot;Setting Negatives to None&quot; or typing Bal < 0 in the x-2 by Reverse Sign for Display both work fine, and a lot simpler than my approach. Ken
  17. Ktwhite

    Reversing The Sign On Account Balances

    I am attempting to reverse the sign for all instances in a particular column of a report where the sign is negative. Since each column includes revenue in expense accounts, simply selecting; &quot;reverse sign for display&quot; within the format editor will not work for all instances. I am not...
  18. Ktwhite

    Grouping Multiple Entries to an Account

    Using CR 8.5, I am attempting to group detail within a report for like account numbers. Initially I created a 5th group in the report to achieve this. This works except; reformatting the report to hide the details of each group, adding subtotals for each of the 7 columns, suppressing the...
  19. Ktwhite

    Format Question With Multiple Groups

    Ok...I stand corrected. And thank you both (Lisa, Ken). I did have to make the &quot;Keep Group Together&quot; selection by accessing: Reports> Change Group Expert> Options, then check Keep Group Together. When I selected this option in the Section Expert only, it did not work with this...
  20. Ktwhite

    Format Question With Multiple Groups

    Thank you again Lisa for the quick response. However, keeping the group together allows only one group per page. In a case where the group only has a few records, I would like the report to keep several groups of the same type on the same page as there is enough room. It seems that the...

Part and Inventory Search

Back
Top