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

  • Users: EngJoo
  • Order by date
  1. EngJoo

    Amount (in word) format

    Greeting, does anyone can guide what is the syntax for converting a amount to WORDS? for example: 935 = nine hundred thirty-five only Thanks EngJoo
  2. EngJoo

    Proxy connection failed

    Greetings, my company have proxy server ISA200 but each time when i wish to log in to citrix i got this error Proxy connection failed:the configured proxy server failed to establish a connection. i have installed ICA java client. and some of my friends even told to locate a fill name...
  3. EngJoo

    SQL Expressions formula

    before i forgot ,, i am using CR8.0
  4. EngJoo

    SQL Expressions formula

    actually i have subtotal for each branch by using COUNT summary after i had grouping on branch.but my user would like to have each branch subtotal to be displayed on the report header.In this case, i am trying to use Running total also doesnt solve my problem. I have a lot of branches with a...
  5. EngJoo

    SQL Expressions formula

    Greetings, i am a new user on SQL Expressions formula, Can anyone provide me the sample code that i should write on it? my SQL T-Transac is select count(customer_no) from customer where branch_no = 1 or branch_no 2 so what i should write on SQL expressions? although i have gone throught...
  6. EngJoo

    Error Mes: A string can be at most 254 characters long

    Greetings, i am write a formula like below:- if isnull({employee_action.comment}) then "Action : Null" else "Action : " + totext({employee_action.comment}) but when i run there report, i got the error message of "A String Can Be At Most 254 Characters Long" i know there is a string...
  7. EngJoo

    How query the SQL statement by the output is leading 0

    Greeting, i face a difficulties on query the output in leading 0. for example: my customer number =1234 for instant i declare customer char(10) then i wish my query output is 0000001234(leading Zero) Does anyone can provide me the SQL Script on how to do that? Thank you.
  8. EngJoo

    Can VB call a designing report tools called IMPROMPTU

    Greeting, i would like to ask can VB able to call a designing report tools called IMPROMPTU?
  9. EngJoo

    Infopath 2003

    Greetings, did anyone know how to create the formulas in the repeat table as we can see on the "tour tutorial"? anyone can provides the link for me to do a test? thank you in advance
  10. EngJoo

    Formula on get first record on on everygroup

    No. i want to write a formula in the running total, asking to abstract the first line.to execute Any advice?
  11. EngJoo

    Formula on get first record on on everygroup

    Greetings, i would like to have the formula on which i want to abstract the data on the first row only. Please advise and thank you in advance. regards, EngJoo
  12. EngJoo

    Date Display

    This is what i am use to do at this moment. what if i wanted it to be done in CR any guiden?
  13. EngJoo

    Date Display

    Greetings, have i table stored the date. The data is not full(meaning that one month got 31 days, but my data might only have 14 days. But when i create the report. i wish to display all 31 days instead of 14. if the data is blank that day then the report display will be blank. anyone could...
  14. EngJoo

    Import data from Excel showing "No item Found" in CR ODBC

    Hi there, i am using CR8.0. i am try to import data from a excel worksheet but didnt work. i create the Connection on the DSN in administrative tools. in my excel worksheet. i have a title on the first row follow by all the data. when i try to link it via CR. Then CR show me.. "item not...
  15. EngJoo

    Loading page before Flash runned

    Greetings, i am just a beginner of using flash. i come across almost all the website have the loading(showing percentage) webpage before to the flash is running. Can anyone out there please help?
  16. EngJoo

    Formula to get the second line of detail after group

    Greetings, Could anyone of your guide me how the formula looks like.if i would like to get the second line of detail after i group the Customer No. As detail have multiple lines. what i am trying to do is. Get first line(formula 0), Get second line(formula 1), Get third line(formula 2) Thank...
  17. EngJoo

    Block mail sent by someone

    Hi, could anyone give me advise on can exchange 2K block mail sent by someone? i hope the mail that being filtered in stored on a folder.so that i can browser throught before i sent it to users. recently i encountered a problem which is a outsider used to send a mail to disturb some of my...
  18. EngJoo

    Reset Proxy Setting at IE

    Can you teach me how to import to group policy?
  19. EngJoo

    Reset Proxy Setting at IE

    could anyone let me know whether i can reset the proxy setting under IE properties -> tools-> connections-> LAN setting button. Actually our users have known the proxy port and address.so i would like to reset their proxy to blank before i disable the changing on proxy setting on group policy...
  20. EngJoo

    How reset the page after different groups

    Greetings, i am using CR 8.0. On my record detail, i sort it by job_status. because i want the report print out on different page if the job_status changed. so i go to detail_format_section, write a formula on new page before as previous(job_status)<>job_status. Then i am able to separate out...

Part and Inventory Search

Back
Top