Search results for query: *

I am seeing the below message in the log file. The only reference I can find about it points to a bug. The link provided confuses me more. I do not know what happened, I have just inherited this database and the entire error log file contains this message. I have not seen any other issues. Do...

hi all has anyone succesfully goten RS to work with MySQL? I can get basics to work, but I keep failing when I try to use parameters. the stuff I have found on the web has not been helpful... any suggestions or help would be greatly appreciated. thanks in advance.

hi all I need to do a sales summary report that displays a figure for today Tuesday the 3rd and if possiable the Tuesday from last year that is as close to the 3rd as possiable. The ultimate results would be a calendar like display that has sales for 2007 and 2006 by day (Monday, Tuesday ect)...

hi all is it possiable to upgrade an msde db on one pc to sql 2005 on a different server? or is the only path to do an inplace upgrade. much thanks

Hi all Is is possiable to copy data from Server A (MySql outside of firewall, internet) to Server B(SQL Server, inside firewall, intranet) using DTS? What I need to do is copy all of the data in tables from Server A to Server B then delete all data on Server A. This needs to happpen like...

Hi all Is is possiable to copy data from Server A (outside of firewall) to Server B(inside firewall) using sql? What I need to do is copy all of the data in tables from Server A to Server B then delete all data on Server A. This needs to happpen like every 5 minutes. Both servers will be v5...

hi all I need to insert client records from a csv file into multiple tables. the client table creates the pk,clientId. how would I go about getting that clientId to insert the remainder of the records into different tables? if you could point me at an example of similar code or instructions I...

Hi all Is there a way to link 2 mysql servers (5.0 and 4.xx) like you can do with sql server? One of the mysql server is "inside" the fire wall and the other is "outside" of the fire wall. Much thanks ;)

Hi all Is it possiable to write one trigger that handles inserts and updates ? my table has has 2 fields, Id and Description. When a new record is inserted my trigger does an insert of this record into table B. That works fine. When a record in table A is updated I want the trigger to update...

Hi all We are using sql 2000 standard and want a cheap solution to move reports off of the production(retail transactions) DB to another DB created just for reporting. Staying with the standard edition is Replication the best solution? Any suggestions/pitfalls would be appreciated. Thanks ;)

hi all I am trying to return the characters between 2 / where the field contains " /abc/defgh " i want 'abc' i am able to remove the first/ but not the second and the characters to the left. substring(field,charindex('/',field)+1 ,len(field)) any pointers would be appreciated

Hi all Is there a way to tell how many time a report has been run in SRS Report manager? and maybe other related stats. thanks

Hi all Is it possiable to use an on insert trigger to insert the same record into another server (linked)? Any hints or issues with this would be appreciated. thanks

Is there a function in Crystal which serves the purpose of lpad in Oracle? lpad(x , 8 , '0') would return x always as a string of 8 characters even if it's original length is less. 0 will be appended to it's left if it is of shorter lenght. Thanks :)

Hi all Using CR 8.5 and Enteprise standard 8. Some of the inserted text is dissapearing from text boxes. The first letter of the word is there but the rest is gone. Sometimes when I run the report, more of the text items display. The size is fine, the reports have worked properly for months...

Hi all Using CR 8.5 and Enteprise standard 8. Some of the inserted text is dissapearing. The first letter of the word is there but the rest is gone. All calculations are working fine. I have deleted it and republished from a good copy of the report. Anyone have any ideas? This is NOT...

Hi all How would I go about using VB.net 2003 to execute a stored proc, then save the result set out to a text file (csv)? I would then need to use another button to rename and move that same file after it is used. Any suggestions will be appreciated. This is for a non profit,we don't have any...

Hi all How would I go about using VB.net 2003 to execute a stored proc, then save the result set out to a text file (csv)? I would then need to use another button to rename and move that same file after it is used. Any suggestions will be appreciated. This is for a non profit,we don't have any...

Hi all We will need to move a sql server 2k database from one server to another. The new server has more cpu's and a different disk subsystem (3 sets of disk). One for the OS, one for Transaction Logs, the last for the data files. Is this something we can do? It's a non profit and we can't...

Hi all Im sure this is simple but, I have a line that prints under the details in the detail section. If there are no details the lines do not print all the way to the page footer. I just found out that the empty lines need to print all the way down to the page footer (like ruled paper). Can...