Recent content by acjim

Firstly, apologies if this is the wrong forum! I've been tasked with interpreting some files that I'm informed are DB2K source code (.prg, .dmd extensions). From my research DB2K seems to be unsupported and unavailable for download so how best can I get into these files and understand them...

Thanks Geoff, Typically I've dived into using SSRS from the blank report and not bothered with the wizard! It does just as you say. Many thanks!

Hi, I'm using SSRS 2005 to produce a simple datasource. Basically to replace excel spreadsheets with linked data. The resulting file is just a flat file with approximately 30 columns. Is there a way of quickly laying out this format in reporting services? I'm thinking of a "select all" type of...

That worked a treat [2thumbsup] have a star for your troubles! re: Option Explicit, of course! I should have remembered my vb lessons, I guess the wdConstants are not in the office reference library. jim

Hi, I'm trying to automate the copy and paste of a chart into a word file from an Excel source file (using a form as the control platform in Excel). I've managed to get this to work but instead of pasting in as a wdPasteEnhancedMetafile (which is unlinked to the excel source) the automation...

Hi, I'm using the "Power" trendline in an XY scatter chart and want to use the formula and the rsquared result in a worksheet. The formula is: y = 644.691x^-0.895 I've looked at LINEST but that seems to only give a straight line trend? LOGEST gives me the exponential result? Basically I'm...

hi rob, I've kind of tried that out and it works well, using RegSetValue and RegCreateKey - not done anything with the Registry before and I'm impressed. Much easier than trying to set the DSN up with SQLConfig...blah blah! Have a star for your quick responses and for getting me onto a new...

Hi Rob, There's nothing in that Folder apart from the "Data Sources" folder. I'm on win 2k btw, don't know if that makes any difference. Thanks Jim

Thanks Rob, I think that may work for some DSN's / DB's but all my system shows is: [ODBC] DSN="DSN Name" The details are held for the system DSN, which is where this instruction is linking to, in the Registry. I've tried using some or all of the attirbutes listed there but I'm getting...

Hi, I'm trying to setup DSN's dynamically using VB in Access. I've used the following source code (modified) from MSDN to try and connect to a Unify DBIntegrator Database. Option Explicit Const ODBC_ADD_SYS_DSN = 4 'Add data source Const ODBC_CONFIG_SYS_DSN = 5 'Configure (edit) data...

I had a look at that but it seems (as no SQL Functions are listed in the SQL Expression builder) that my combination of a Unify db linked by odbc has no sql functionality. When you add an sql expression the function "tree" shoud expand to show available functions, right? The connection driver...

Hi, I've been writing a decode formula for what will be a suite of crystal (v8.5 off Unify db) reports. The field that I really want to decode is a memo type and Crystal won't let me use it in a formula. Is there any way of working around this? I don't have the flexibility of a data warehouse...

Hi, As PHV has it, but with additional link between dates to keep the ranking contained to a particular date: SELECT tblHbInput.Pat_Number, tblHbInput.Code, tblHbInput.Spec_Date, tblHbInput.CRN, tblHbInput.Result, Count(tblHbInput.Pat_Number) AS Rank FROM tblHbInput INNER JOIN tblHbInput AS...

Hi Turkbear, I've now got the subreport working within a basic table-style report. What I need to do is make this report into a crosstab style. This doesn't seem to be possible, any ideas? Great help so far! Jim

Hi Turkbear, I kind of get what you're saying, and I've created a grouped subreport that shows just the records I need - conditional formula fields - but how do get the data from the subreport to integrate? When I tried it just looked like all of the subreport was squeezed inbetween the parent...