Search results for query: *

When I enter my parameters to connect to the SP I want (SQL 2000 DB) I get the following error - Query Engine Error: '22018:[Microsoft][ODBC SQL Server Driver][SQL Server] Syntax error converting the nvarchar value '%' to a col of data type int. This occurs when I try to add the SP as a data...

Hope someone can help please... I am connecting to an SP and cannot get it changed easily.. I want to be able to enter multiple values to Parameters that have been set up in SQL 2000 (ie I cannot edit them to allow for multiple values). Is this possible or will I have to get them removed and...

I am in desperate need of some advice please? I am trying to delve into using VBA primarily with excel, also envloving the need to develop some macros for the first time. Can anyone recommend a really good book for first time VBA/Excel/Macro development. I am experienced in SQL programming so...

I have been aked to mock up some call centre reports - the only thing i don't have as a starting point is some dummy data to load into my SQL 2000 DB. We have never had a call centre before - anyone know a good place to get a small sample of call centre data? Any help most appreciated!! thanks...

I am trying to find out if I can write SQL in a certain fashion which I want to put into a Stored Proc. I want to select a field from the database which is a text field - ie:- Hello $customer$, You owe me $sales ammount$ can I have it please etc etc The user can define this text and it is...

I havent used SQL 2000 Stored procs much yet with Crystal I think my question is quite basic(!) I have connected CR9 to an SQL Server 2000 DB stored procedure as the data source. this works fine - I get the data I need. When CR9 connects to the Stored Proc tomorrow will the data be the same or...

I havent used SQL 2000 Stored procs much yet with Crystal I think my question is quite basic(!) I have connected CR9 to an SQL Server 2000 DB stored procedure as the data source. this works fine - I get the data I need. When CR9 connects to the Stored Proc tomorrow will the data be the same or...

I have an issue trying to set up a proof of concept. I want to load letter text into an SQL Server DB with CR/LF formatting. I want this formatting to be preserved in the DB. Can Crystal Reports Recognise this formatting when the field is placed on the Crystal Report (ie the paragraph...

I have an issue trying to set up a proof of concept. I want to load letter text into an SQL Server DB with CR/LF formatting. I want this formatting to be preserved in the DB. Can Crystal Reports Recognise this formatting when the field is placed on the Crystal Report (ie the paragraph...

I have built a query which show me how many sales for different products I get each day. Obviously the column is product and the row is day of current month. Data summarised being sales. If I have no sales on a particular day - this row does not show in the cross tab - how can i get the cross...

Can I run a stored proc/DTS package that looks for a condition, ie sales > 1000, and then if this query is true it outputs a file to a specific location - (we can then poll for this file with the Crystal Enterprise Event Server...) The bit I'm really struggling on is how to output a file to a...

Can someone please tell me how I can change the date format display in eportfolio to dd/mm/yyyy It is currently coming up as mm/dd/yyyy next to each report? Thanks if you can help, Tom