Search results for query: *

Found the answer separately from MisterMo's suggestion. However, many thanks for their input which is greatly appreciated. For interests sake, in basic terms, here is the solution I came up with Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Dim...

Hi, This will no doubt be embarrasingly easy, but I'm stumped. VS 2003 Pro/CR 11 Developer Edition Am printing reports to a Report Viewer and then from there my users can print/export as appropriate. How do/can I bypass the viewer form entirely and (based on their choice from my calling...

Hi, Re: VB.net 2003 I was wondering if anyone knew of a way to find files in a specified location based on their date and time, without recursively having to loop round the directory and it's subs, checking each file individually. I need to quickly put together a simple directory/file...

chelseatech, Thanks for the post. This app will be deployed to 50 users in our organisation. I'd be grateful if you could let me know how this will affect the licencing of the dll. I'm assuming we'd have to distribute it with the app and register locally on all machines that will run the...

JontyMC, Thanks for the reply. Greatly appreciated. Steven

Hi, Have tried that in the Sections Expert, but the hyperlink for the sub-report is still displayed (these are on-demand subreports) and on clicking the hyperlink I am presented with a logon prompt to choose a datasource. I have my main report in the first Details section and all other...

Hi, I have a dataset where some of the values are "". When writing the dataset to XML using the following approach, it only writes those columns that have values. I really need all columns to be written to the file regardless of whether or not a value exists. Dim objAdapter As...

Hi, Using CR.NET (version included with VB.NET 2003 Pro Edition) I have (owing to my inability to access my legacy database directly), created a number of XML data files for each element (page) of my report. I have on-demand subreports defined based on each of these data files. The...

Hi, CR for VB.net 2003 Professional edition Rbase 6.5 ++ database Oterro 2.6 ODBC database driver Running VB.net 2003, I have no problems accessing my legacy databases in multi-user mode using the following DSN(less) connection string: "Driver=Oterro Database Driver...

Hi again, I should have said that the failing update is actually an UPDATE command created as a string (@SQLstring) and run as follows: exec sp_executesql @SQLstring I do know that I can call my SP as follows: declare @vretcode int, @vsetindexno int set @vsetindexno = 592 exec @vretcode =...

Hi, I have an Insert trigger that amongst other things fires a Stored Proc to perform additional updating. One of the updates in the Stored Proc tries to update a column with data that is too long to fit. The Stored proc, when run in isolation as follows: declare @vsetindexno int set...

Perfect. Thanks so much Steven

Hi all, Apologies in advance for what is likely to be the sheer obviousness of the answer to this one ** All data values are (I believe) correctly defined/datatyped and do exist prior to me running the command. It's simply a matter of the live row not existing that I'm concerned about The...

Hello, I have a (what I refer to as a) data translation table that I use to identify the target table, data column and index column for a set of updates. Effectively, in really simple terms, I'd like to be able to pass the table name, column name and index column as parameters to an sp, which...

This is going to be such an easy one, I'm sure, but I can't find anything about it elsewhere. Is there a command (ideally I'd like to run this in a trigger) to allow me to round a value up to the nearest multiple of 5 (or whatever other whole unit I wish) (e.g., 12.5 gets rounded up to 15)...

Hi, Tried it as you have it and it worked fine. Thanks. Funnily enough, I also tried it passing a text value to a datetime column and it failed for me without evaluating the condition (which was along the same lines as my original problem), returning the following message: Server: Msg 241...

Hi, Trying to build error-trapping into my triggers. All of this is being done in Query Analyzer, prior to actually amending the triggers. These commands work, evaluating the error variable correctly as 0 and displaying 'succeeded' as required. DECLARE @IERROR INT INSERT INTO ERRORTABLE...

Hello, Got a large DAO codebase to be updated, but for the time being my first task is to create a DSN-Less OpenConnection in DAO 3.6 to a SQL Server2000 database. Is this even possible? All of the examples I've come across relate to ADO. We'll get there eventually but are stuck with DAO in the...

Hello, My firm has just installed a SQL Server based accounting package and I've been instructed to integrate this with our Word templates. Basic desktop setup is as follows: Win2K Pro Office XP (referencing DAO 3.6) SQL Server ODBC driver installed This code is being run from Word. I can...