Search results for query: *

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

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

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

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, I'm a newcomer to crystal, which I'm running on a win2k on top of a Unify Dataserver database - I'm also a newbie with the database, but I've already hit some walls. I've found out that the Unify dB will not allow outer joins - these have been an essential part of my tools so I've been...

Hi, I have data like this: Pat_Number Code Result CRN Spec_Date 693947 HB 9999 976498 19/09/2003 693947 HB 9.7 976498 19/09/2003 693947 HB 8.8 976498 19/09/2003 693947 HB 8 976498 19/09/2003 693947 HB 16.4 976498 19/09/2003 693947...

Hi, I've used this Median function a number of times with great success: =MEDIAN(IF(D173:D191>=TRANSPOSE(ROW(INDIRECT("1:"&MAX(D173:D191)))),$B$173:$B$191)) Where D173:D191 are the Frequencies and $B$173:$B$191 are the Values. Obviously I'm really happy it works but I'd like to know how...

Hi, I've put a pivot table together that includes the following calculated field: Field Formula Field1 ='Bed Days' /'Total BedDays' *Cost Now each field seems to be fine and when added manually (out of the p-table) the total is what I expected, BUT the Grand Total in the table is out by about...

Hi, I've put together the following simple vB function to convert regular months to financial months for a yr on yr comparison report. It seems to work fine but the results are shown as text, this then leads to problems in getting the Minimum and Maximum etc. Obviously I can convert the...

Hi there, I've got an Excel worksheet linked via ms.query to an query within an Access dB that extracts records from ODBC linked tables. This Access query has to calculate the time difference between either Arrival and Discharge or Arrival and Transfer. This can result in greater than 24 hour...

I'm trying to set up a reporting form for a large dB. I've worked out how to use text boxes, combo boxes etc for setting criteria but I'd really like to use option groups. The problem being I can't get the criteria field in my query to pick up the specific option value. It doesn't seem to...