Search results for query: *

Hi Everbody, thanks for all the input. You guys are great! With my best, Frank

Dear Ken, of cause I have to put a criteria on table2. I only want the information for one customer (for a certain period, but I did not mention it here to keep it simple). And even if I choose all customers, I would only get the discriptions used so far. But table1 also contains a lot of...

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 re-ran the report using ODBC instead of connecting natively, no improvement. I don't think that the dot is causing any problems as long as the database is configured for the English/US number format. I had problems with this dot in the begining, and got that fixed by changing...

Dear Jambu, I always work on the same database. No margin of error there. We do have multiple databases but they are offline right now. Also I don't make any changes to the SQL. I just copy it in an editor, save it and run it. With my best, Frank

Hi Naith, I tryed the suggested change; I did not get any data back! I also tried the SQL again and got all data (as expected). I checked the Database driver: Oracle 7.x (pdsora7.dll) Another thing I tried: Table.Cond <> 1 and ({?Name} in [{view.name_1},{view.name_2},{view.name_3}] Again no...

Hi everybody, first of all I would like to thank everybody for their input.:-) But things are still unchanged.:-( I checked all brackets and they are OK. I changed the order and split it up as suguested by Naith, nothing works! The SQL form CR for the first statement looks like this: SELECT...

Hi Naith, I also always work directly with the Selection formula, sorry for not making this clear. I tried everything you mentiond, but the situation is unchanged. All SQLs copied from CR to SQL*Plus are working fine so I assume the DB is returning the right data. But I noticed that for some...

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

Dear Steve, this works! I could not get the part with the Redim working (I always got he error message that an array must be indexed) but I just initialised the array with more elements (20 instead of 5) and deleted the redim statement. No problem! (We are not contacting our coustomer that...

SMPhillips, further help would be wunderful. I never worked with arrays in CR. I thought it would be a simple problem to solve, but it turns out to be much more complicated than I antipicated. With my best, Frank

I am very sorry, maybe my brain is on vacation.. I don't have a clue what you are talking about. I tried it for an hour and I read the Hamady stuff getting the impression that it cannot be done. Should I use groups or not? How do I write a formula counting records without using the count...

Hi Madawc, can you be bit more specific on the formula? If I have the count field in the formula, the formula is not given as an option for the grouping. With my best, Frank

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

Works perfect! Thankx from Germany Frank

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

Thanks for giving me this hint. I change it somewhat to be more flexible... Sub Hyperlink_change() Dim oWS As Worksheet Dim oLink As Hyperlink Dim sOldAdr As String Dim sNewAdr As String Dim sOldAddress As String Dim Position1 As Long Dim Position2 As Long sOldAdr =...

No, that does not work! My hyperlink text as displayed in the cell (like: Click here to get to xxx) would be edited but not the adress behind it. If I search for http://123.456.789.000/blah I don't get a hit because this string is only present in the link but not in the text displayed in the...