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

    Retrieve Current Machine IP Address

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

    Retrieve Current Machine IP Address

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

    blank output when running through application

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

    Define data range in excel and search in a cell content using VBA

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

    Define data range in excel and search in a cell content using VBA

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

    Use cells data in Ecel sheet to create a search string

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

    Saving Module to be accessed from any excel

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

    Use cells data in Ecel sheet to create a search string

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

    Use cells data in Ecel sheet to create a search string

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

    DETAIL SECTION AS PAGE HEADER

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

    Formula for Filtering by Date Field

    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)
  12. WaelYassin

    Default Current Date for selection

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

    Use Null Value to Eliminate Group from Report

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

    Report used Command is not working in CR component

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

    report duplicates section containing subreport to the next page

    Dear All, i have CR9, SQL SERVER 2005 my report duplicates the group footer to the next page. this group footer contains a subreport that shows signatures upon condition. the subreport attributes is set to suppress blank subreport. and the group section set to suppress blank sections. The big...
  16. WaelYassin

    The formula doesn't return data

    Dear All, i am using CR9 on DB oracle 8i, i am trying to build a paragraph using a formula, here is the code which i put on the formula: WhilePrintingRecords; stringVar strText :=""; strText :="A fax of readiness should be sent to our freight forwarder """ + {MMS_COMPANY.COMPANY_NAME} + "...
  17. WaelYassin

    Formatting Form dynamically-Sections problem

    Dear all, i am using CR9 with Oracle 8i i am designing a contract Form, it contains the following sectons: -page header -group header (group based on contract code) -some group sections -details (items) -terms & conditions (static text) -signatures as you see, the signature section is the last...
  18. WaelYassin

    embeding word document dynamically in a report

    Dear All, i have CR XI with SQL server database. i have a field that stores path of word documents. i want crystal report to check that path and open the needed document in the report. in other mean to be able of printing data from database and the corresponding document through the report.
  19. WaelYassin

    Building Generic connection parameters???

    I am using CR 9 and SQL server2000. i have a big number of reports designed to use a certain database, unfortunatelly the client uses another database name but with the same ODBC name. IS there any way to tell the reports to take the connection parameters from the ODBC?? in simple way, i want...

Part and Inventory Search

Back
Top