Search results for query: *

Hi Everybody, here is the problem: Two tables Table 1: Code Description 1001 aaaa 1002 bbbb 1003 cccc .... Table 2: customer Code 1 1001 1 1002 1 1001 2 1003 3 1004 .... Now I want to create a crosstab analysing the the Data for...

Hi everybody! I have big problems with an OR-statement after we changed a database view. We have a Oracle 8 database and use CR 8.5. I created a report using a view and some tables. The statement in the select expert looked like this: ({view.name_1} = ?Name or {view.name_2} = ?Name or...

Hi everybody, I have a problem exporting a memo field to RTF. The memo field is in Arial 8. It contains a few empty lines. When exported to RTF, the text is in Arial 8 but the empty lines are in Arial 12. The result is that the last lines of the memo field are outside the field size of the RTF...

Hi all, I have a problem with the PDF-Export in Crystal 8.5. I have a report with several growing memo-fields. Sometimes I have that much information in a memo field that the text extents to the next page. If this happens the first few lines of the text on the next page is missing when exported...

Hi everybody, the Problem: I have customer IDs that can be contated many times. Each time the customer is contacted the date is entered in the DB. Now I want to find out how many customers have been contacted x times. The DB looks like this: Customer ID Date 1 1.1.2002...

Hi everybody, I have a grouped report and a formula calculating the days between to date fields. Now I want to count all records where the result of the formula is higher than x. Group: Berlin order1 1.1.02 30.01.02 diff:30days order2 5.01.02 10.01.02 diff:5days . . . Group: Hamburg...

Hi everybody! I have a sheet in Excel 97 with 150 Hyperlinks. They all start with something like http://123.456.789.000/blah/blah/xxx/blah... Now the adress has changed to http://123.456.789.000/blah/blah/yyy/blah... Is there a way to do something like a find and replace for all the links at...

Hi everybody! I have no idea if this is possible at all! I have a database field in the details section of my report and would like to connect the values of this field in a formula and put this formula in the Group header. So what I have is: GH: DS: data1 data2 data3 and...

Hi everybody! I have a table with 7 colums resembeling conditions, the fields containing either NULL or 0 meaning the condition is False or 1 meaning the condition is True. What I want to do is create a formula returning a string with all true conditions (not just the 0's and 1's) I tried...

Hi everybody! I hope this is not a stupid question.... The primary key in the first table in my DB relates to multiple records in my second table. The number of linked records in the second table can be anything from 1 to 35. Now I would like to create a report with data from the first table...