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 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...
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)
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...
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...
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} + "...
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.