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 bkrike 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
  • Content: Threads
  • 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

    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...
  4. 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...
  5. 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.
  6. 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?
  7. 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
  8. 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
  9. 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...
  10. 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...
  11. 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?
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. EngJoo

    How to put the parameter field in select expert?

    Dear all, i am on the beginning stage of using CR8.0. I come across a parameter field function and started try to use it. For my previous practice, i am using the select expert to choose the date range of the report that i requested. It is too troublesome for my user to change because i have...
  17. EngJoo

    How to keep the table line after i export to excel

    Dear all, i would like to get your advise on how to maintain the line that i draw on the CR after export to excel? Thank you very much.
  18. EngJoo

    How to sum a formula field

    Greeting, i would like to sum a formula field which is having the error message &quot;the summary/running total field could not be created&quot; while i write sum(@formula1). but i really need to sum it. i have been tried to sum it by using the running total solution. but i can't find the...
  19. EngJoo

    Reset Record Number after each Group

    Hi all, i am putting a record number in each detail line that has been displayed. i am also do a grouping on my report as well. now i wish that the record number could reset after a group ended. Can any one guide me on that? i am using CR8.0 Thank you very much
  20. EngJoo

    Can CR8.5 can design Bar with Line chart?

    Dear all, As i know CR9 can design combined Bar and Line chart. So can CR8.5 did that too? regards, EngJoo

Part and Inventory Search

Back
Top