Search results for query: *

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.

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

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.

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

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

Dear All, i am using oracle 9i. i have a table that indexed in workorder# to be unique across the table, we have a program that take the data from the user and stores it in the database. the program prepare a batch of records and then begin transaction and pass it to the database. the problem...

Hi all, i am using CR9 and oracle 9i . i have a memo field in the database that stores text data, i want to retrieve the this fied with its format (font type, size, color,....) and so and display it in the report. is that possible? thanks.

hi all, i am using CR XI , with SQL server database. my client wants to display 3 summery fields in the cross tab as columns not under each other. how can i accomblish this. thanks

Hi all, i am using CR 9 and MS access database. i have 3 tables tb1, tb2, tb3 . the linkage is in the same order. the problem is that there is a duplicates in the middle table (tb2), which in turn make duplicates in the whole report. how can i treat that problem of duplicates where the solution...

Hi all, i have CR 9 and SQL server 2000, i am dealing with a huge amount of data about 5 million records. i want crystal to pass selection formula to SQL server and let it filter on the selected records and pass them back to crystal. what really happens after choosing parameters, is that CR...

Hi All , i am using CR 9, connecting to SQL Server database. i have 2 groups, in the second group i have 5 summeries. till now everything is alright, the problem arise when i am asked to add 3 string fields beside the summery fields which located in the group 2 footer. the 3 fields bound to 3...

Hi All, i am using CR XI , SQL server 2000. i am trying to save all telephone numbers for a given day, the problem is that the number sure is above 1000 element. Does anybody know how to solve this problem of saving more than 1000 number in an array

hi all, i am using cr XI , SQL server 2000 . what i am trying to do is to display the row heading of the crosstab in the right side of it rather than the left side. is there a way to do it? Total=f1 f2 f3 = row heading =================== 6 = 3 2 1 = No. of customers...

hi all, i am using CR XI DEveloper, SQL server 2000 i have a line chart , it works great. the client wants the chart to draw the first value at y axis. how can i do that? the original chart: * * 0 * 0 * 0 * 0 **************************** should be like: * *...

hi all , i am using CR XI with SQL Server Database. i want to create a (stacked line chart) that shows relation between daily revenues for each brand. in other words, the chart x-axis displays days through the month or year, and the y-axis shows total revenue, and the chart itself contains all...