Recent content by EngJoo

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

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

before i forgot ,, i am using CR8.0

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

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

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

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.

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

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

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

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

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

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

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

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?