Recent content by WaelYassin

Thanks Ido for your reply, we have conversation via emails and hope we finally agree to proceed in the purchase of Visual Cut and Cut Light software

I am using Crystal 9.0 on Windows 10. I need to figure out a way to retrieve the current machine IP address and use it in a report to be printed out in the footer. any ideas how this can be done. Thanks in advance.

you may be using Date Parameter, check the format (Day/Month/Year) and try to pass a generic range (01/01/2012) if so, it is the matter of how database handles the date format.

Thanks Skip for your help, But i didn't understand the line even from the F1 Help, how it work? second thing is that the purpose is to iterate on group of excel files and extract their similar template data into designated master excel file. i think it should be some kind of Macro...

I am using Excel 2003. i have work sheet consists of A B C D xaxaax 3 DDDD 3 4 columns as you can see, column A is header and B is values and the same for C & D. what i want is to search for specific header or cell at A or C and then...

No, you are concatenating with the (CM) in advance, not the token, so if you got the last value, no need for the last (CM). As in My Example, when you substitute in your good Function Output will be: Brown.|Yellow.|Red.|Black.| Remember that i neglected the last line in the code to show the...

Thanks alot PHV

Dear All, I want to know how to design a function that can be shared and used from any Excel sheet or project in the current PC.

Thanks all of you, But Special one for Skip, I amended the last line in the function to be MakeList = Left(MakeList, Len(MakeList) - Len(CM)) This will make the # of truncated characters dynamic to the delimenter's characters count. Thanks again

Dear All, I am trying to use excel sheet to do the following, i have a set of strings that can be output from other program, i want to paste them in Excel then go through each cell contents and concatenate it with (.|) then the next cell contents. Example: Brown Yellow Red Black Output...

On the Detail A, go to section expert, check on New page after. On the Detail C, go to section expert, check on New page after.

You have to extract the month and year from your number first. // Suppose you field is called x Right(X,2)<= Month(CurrentDate) AND Left(X,4) <= Year(CurrentDate)

You can use the special field (CurrentDate), it will return the current date value.

1- Create a formula that will test for null date and return 1 if null and 0 if not. 2- put a sum upon this formula per the group you already have. 3- In the group selection formula, select the groups with sum < 1 .

Dear All, i am using CR 9 and SQL server 2005. i have designed a report that connect using a sql command. the report is working fine, but when i tried to open it through the CR viewer (Active X) from our Program, the report didn't start or even open. i don't know is it a limitation or what? i...