Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: acjim
  • Order by date
  1. acjim

    DB2K - how to interpret

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

    Add all dataset fields to Reporting Services table?

    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!
  3. acjim

    Add all dataset fields to Reporting Services table?

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

    Excel/Word Automation: Pastespecial Reopens Source File

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

    Excel/Word Automation: Pastespecial Reopens Source File

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

    Excel Function to Match Power Trendline in Chart?

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

    SQLConfigDataSource how to guess Attributes?

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

    SQLConfigDataSource how to guess Attributes?

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

    SQLConfigDataSource how to guess Attributes?

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

    SQLConfigDataSource how to guess Attributes?

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

    Using Memo Fields in Crystal Formula Fields?

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

    Using Memo Fields in Crystal Formula Fields?

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

    Setting Crosstab Dynamic Columns

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

    Crystal 8.5 and Unify Dataserver - No outer joins aloud...help!

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

    Crystal 8.5 and Unify Dataserver - No outer joins aloud...help!

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

    Crystal 8.5 and Unify Dataserver - No outer joins aloud...help!

    sorry "Allowed!
  17. acjim

    Crystal 8.5 and Unify Dataserver - No outer joins aloud...help!

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

    Setting Crosstab Dynamic Columns

    JonFer, I needed to add a GROUP BY to make your query work. But it does, and is definately smoother than using SubQueries. Thanks Have a little star for your extra help. jim
  19. acjim

    Setting Crosstab Dynamic Columns

    Duane, You were the person I was hoping to find! I've actually worked around the problem now. By doing what you suggest, I ranked the results - made a table and then a crosstab from that table. This worked but is very clunky and means I've got to build a macro for the process to be user...
  20. acjim

    Seniority list with incremental number changing if hiring/quitting

    PHV, I've been trying to twist the ranking feature into life all day! Have a star for allowing some extra insight. Thanks!

Part and Inventory Search

Back
Top