Search results for query: *

Hello, I am trying to import data directly out of Progress 9.1E into SQL Server 2005. For many tables this is no problem, I created a Linked server and am able to connect the tables and can use T-SQL statements to select records out of the tables. SQL Server 2005 has a big F***-up in their...

Hello, I am currently busy to build a datawarehouse and I am importing data out of a linked server (Progress 9.1E). I am working with SQL Server 2005. I will get an error: Msg 8114, Level 16, State 8, Line 1 Error converting data type DBTYPE_DBTIMESTAMP to datetime. The problem occures when...

Hi, I am not sure if I am doing something wrong or if it is a bug but, I can not seem to parse a SQL querie in the DTS Wizard. I get the following message. "Unexpected Error occured.The provider has returned an Error result without an Error message". The syntax is: select...

How can I add an auto increment row in a query? Existing table: Names Name John Jamie Adolf Nelson Tony George Kevin I want to make a select ... into query (to create a new table) SELECT Name INTO NewNames FROM Names ORDER BY Name GO The result has to be ID Name 1| Adolf 2| George 3| Jamie...

Hello.... In some (sql)languages there is a possibility to compare a field from row 1 with the same field in row 2. P.E. here is the query: SELECT ref, cust, purch_date FROM sell ORDER BY ref, cust, purch_date GO ref cust purch_date 123 1001 2005-01-03 123 1001 2005-04-01 123 1004...

Hi, I would like to concat to greps to eachother. p.e. file: 016-00.txt job started: thursday 15 july at 23:00:09 file: 017-01.txt job started: friday 16 july at 23:00:08 output after the grep 016-thursday 15 july at 23:00:09 017-friday 16 july at 23:00:08 I was thinking about: grep 'Job...

Hi, I've downloaded "mysql-4.0.20a-win-src.zip" for winXP. After upacking the files I don't know how to get started. I did search at this forum and at mysql.com, but no results. Can you tell me how I can get started with mysql?

Hi guys and girls, I use CR 8.5 prof my formula is: (standing in group #2) ------ numbervar week1; if GroupName ({@days old}) = "week1" then week1 := DistinctCount ({database.field}, {@days old}); ------ I have a variable "week1" and I use "week1" in group #2...

Hi there, I want to put my reports on intranet so everyone can check them. But the other people dont have Crystal Reports. Is there a viewer I can use? Please tell me. Greetz, Henky

Hi, I have a question about a summary on a field in a group. I think it isnt clear to you, so I'll explain. I am creating a report. That report has got 4 groups. In the 1th 3th and 4th group I need an amount. 1th gr (type)>(totadress) <-- 4* sum of all group2 in group1 2th gr (....)> ... ...

Hi there, I have a question &quot;&quot; about hyperlinks. I have a report and I have to export the report to MS Excel. I use a hyperlink in the report. The hyperlink works excellent in the report, but when the report is exported to MS Excel, the hyperlink doesnt work anymore. Could you help me...

Hi People, I hope it is allowed to ask some questions about Seagate Info in here. It is my first time to use SI 7 seriously. I tried to use SI some times, but I always had sad days after using it. I want to refresh a report when I am a sleep :). When I schedule a report it is always FAILED...

Hi, Can I create a kind of Macro in Crystal Reports? Every night my database get updated (when I am asleep:). It is cool when my reports will be updated too every night. Can somebody help me? Henky

Hi Guys (or Girls), I have a question about the error DBFNTX/1210. We use a program to administrate the orders. That program is build in CA Clipper. That program is used to make and change records in DBF-files (DBASE3) and the program makes NTX-files (Indexes). Normally we only change data when...

I want to import a file (jepje.dbf) <--dbase3 and I got the failure message &quot;10019&quot;. Does anybody know how I can import that file?? Thank you

Hi guys (and girls), Do you know how I can make some vertical groups in a report?

I've got a problem! Showing a report on the intranet is not possible. Do I need to install some drivers or stuff? I want to see the report on a PC without installing Crystal Reports. Can somebody help me?<br><br>Henky<br><br>

Hello All<br><br>Firstly I have to tell that I am from Holland and that English isn't my main language, so you know why some<br>sentences or words aren't clear to you. (all apologies for that:)<br><br>I am using CR v8.0 (for 2 months now.) I have to make a report about what we sold over the last...