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

    Crystal report PthPercentile and Oracle Percentile

    No, that's only group. The content of number is from the table num field. Thanks.
  2. JeanneZ

    Crystal report PthPercentile and Oracle Percentile

    Hi Crystal expert, I need help. I used PthPercentile in Crystal report but got different result vs Oracle percentile function. For example: Our data like dept num 1 0.1069 2 0.1182 3 0.0658 4 0.1045 I would like to find 33% low and 66% high values...
  3. JeanneZ

    Window xp connect to Unix

    Thanks a lot for your information. I will download it.
  4. JeanneZ

    Window xp connect to Unix

    Hi, Now I know it is Secure shell. Which software should I use? Where can I download it? Thanks.
  5. JeanneZ

    Window xp connect to Unix

    Thanks a lot for answering my question so quick. I just need to logon to Unix box from windows to create/run some scripts. I am not sure it is simple shell or secure shell. Thanks.
  6. JeanneZ

    Crystal Report chart question

    Hi Crystal Reports experts, I have some questions to consult you. I need to create a report in bar chart format. The data is like: Proj_id, start_date, End_date, Error_meg The report will be like: Proj1 | ___________ Proj2 | ________________ Proj3 | ________________________...
  7. JeanneZ

    Window xp connect to Unix

    Hi expert, I would like to consult with you. Any free download tool for me to use from windows xp connect to Unix? Thanks a lot for any help. J
  8. JeanneZ

    Conversion failed when converting the nvarchar value 'Name' to data ty

    Thanks a lot for you answering my question. Yes, it is bad design. I will talk with DBA for the solution. Again, thanks a lot for you all.
  9. JeanneZ

    Conversion failed when converting the nvarchar value 'Name' to data ty

    Hi, SQL expert, I have a question to consult you. We have a table with fields to conbine user first name, last name and company name, and other information. There are two fields related, propertynames, propertyvalues. The two columns are ntext data type. Some data sample like: propertynames...
  10. JeanneZ

    Send a report by email attached excel file with name and date

    Hi, SQL reporting experts, I have a question to consult you. We have setup the reports sending by email by attached excel file. The scheduled reports are sent by attached file like ReportA.xls. I would like to know if any way we can send the excel report with report name and date by attachment...
  11. JeanneZ

    SQL question

    Thanks.
  12. JeanneZ

    SQL question

    I am new for SQL Server and have a question to consult experts. I have an Employee table: ID Name ManagerID DepartmentID Region 101 Kay Scott 201 D1 South 102 Kim Lee 201 D1 South 103 Jean Lu 301 D2 North 107 Sam Smith 402...
  13. JeanneZ

    Display a tbale's column

    Thanks a lot for your help!
  14. JeanneZ

    Display a tbale's column

    I am new for MS SQL server. I was Oracle Developer. I would like to know how I can display the table's column information, like Oracle desc table_name command. Thanks a lot for any help. Jeanne
  15. JeanneZ

    BO Report question

    Thanks a lot for your help.
  16. JeanneZ

    BO Report question

    I will create a BO report to list Top 100 paid employees. I used Free-hand SQL ranking all the employees because I need the show total paid for top 100 and top paid for all others. On the report, I only need show top 100. How can set the filter? Thanks a lot for any help. Jeanne
  17. JeanneZ

    database name change for BO server

    Thanks a lot for your help.
  18. JeanneZ

    database name change for BO server

    Intuit, Thanks a lot for your help. One more question, if I use same db name for new database, and modify tnsname on BO server machine, do I need to modify repository on BO server? Thanks. Jeanne
  19. JeanneZ

    database name change for BO server

    Hi, BO experts, I have a question to consult you. We will change our oracle database server and database name. We use Business Objects version 6.1 (very old). And we have free hand SQL reports and Universes reports on BO web server. My question is how can I change database name for BO reports...
  20. JeanneZ

    Top 5 salary for each department

    Mufasa, Thanks a lot for your help.

Part and Inventory Search

Back
Top