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 TouchToneTommy 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: *

  • Users: NewToCR
  • Content: Threads
  • Order by date
  1. NewToCR

    Customer Employee Product

    Problem again... Data is like this Customer Employee Product 1 A X 1 A Y 1 A Z 1 B X 1 B Z 1 C...
  2. NewToCR

    "My Computer" gone

    Hi! I have to confess...I deleted MY Computer icon from Desktop and i want it back. Please, help.
  3. NewToCR

    MY Computer icon gone

    Hi! I have to confess...I deleted MY Computer icon from Desktop and i want it back. Please, help.
  4. NewToCR

    Remove Zeros

    Hi again, I have records with 7 and 8 zeros out of 12 characters. Zeros are preceedeing always. I need to remove those. Should I use Left function?
  5. NewToCR

    Drill Down Info

    There could be unfortunate thing that I will need to incorporate this into CR. Company Info List that includes Executives List at the bottom of the Info List. Done... Now I need to be able to read Individual Info if I want to by...clicking on Individual Name and open another window or...
  6. NewToCR

    3Aliases + 2Aliases (NOT urgent)

    I am very proud of myself for figuring out how to write a query where I have 3 Aliases of 1 table and 2 Aliases of another table. It works. It based on 200+ columns table and my question is how safe it is to have such a query for the Report? I am planing to write it into SQL Server view. Am I up...
  7. NewToCR

    Upon UPDATION

    I was just a at the training where one message said 'upon updation of address' and we were puzzled whether UPDATION is a valid word.
  8. NewToCR

    Alias table not recognized by Select Expert

    I have Cus table and Cus1 alias table. When want to put criterias in Select Expert it only recognizes one table. How to go by?
  9. NewToCR

    'Butterflying' the Table

    I am pretty sure all of my CR writing will have one common thing. I have to 'butterfly' my tables. Customer Cus_Type RepName CoName Address 'I' for Individuals 'C' for Companies So I will have to pull information from the same table where Customer 'I'...
  10. NewToCR

    Week Ending Friday/Previous Friday

    Hi everyone, I am looking for help. I am creating CR 9.2 Report. When Report opens it's date is Week Endind Friday. I am thinking previous Friday should be default unless it IS Friday today - then it is Current Friday. What is the best way to go here? Procedure, SQL expression, formula? I...
  11. NewToCR

    Table Was Renamed

    I developed a few reports in version 8. Someone has taken the liberty to rename some database tables, one of which is in my report. I added the renamed table but do not see a way to re-reference the fields to the appropriate table. Is there a way to do this? I know if there isn't I will...

Part and Inventory Search

Back
Top