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

thanks for that - looks pretty good indeed. are macros covered in this bit - PART VI: Developing Applications. ?? it doesnt seem to mention macros specifically in the topics? Tom

Thanks for your help guys - one last thing - does John Walkenbach's Power Programming With VBA start from the beginning in terms of using vba/macros with excel? i ve not done this type of dev work b4..! thanks tom

thanks. does it cover using macros with the vba coding it goes over? tom

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

Thanks that great to know and good advise!

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

Thanks i ll try that

Cheers thats great - another things cropped up. if you want to show two groups next to each other ie not nested can you do this? ie product sales then department sales for each day as opposed to department sales within each product? Thanks in advance tom

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

Thanks I seem to be getting somewhere with this..! Cheers again

Thanks for this - It's exactly the second bit im struggling on after the begin statement - I want to load a file, (any file), to a location , ie c:\\mis.... Do you have any help with the syntax?

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

I've looked at the history page and there does nt seem to be a referance to mm/dd/yyyy or any equivalent date ordering..? Any more ideas on this csp editing? Thanks