Search results for query: *

PH, any ideas? I'm stuck as the first query just takes about half and hour or so.... and the bottom one doesn't work. Matt London (UK)

Hi, I would like to know more! in the main worksheet the key field is Project Number. It appears only once for each project. I need to retrive all of the finance actuals for each of those projects from a table with multiple occurances of each project number. thanks, Matt London (UK)

Is this possible? I've just realised that the data I need to use in one of my worksheets comes from a table with hundreds of thousands of rows. I only need to retrieve values with Project numbers from a list in another worksheet (of which there are about 600) Is it possible to perform a VLOOKUP...

Hi all, I have two Excel worksheets containing project actuals - from two data-sources (one datasource per worksheet) Each project will have several rows for each time entry. What I need to do is compare the two and highlight where there are differences between the two worksheets. (They...

PH, any idea why the first of the queries doesn't seem to run quickly? its been 10 minutes and nothing.... I've tried the second SQL and I get the error: "Table reference has to be a table name or an outer join escape clause in a FROM clause." is there something wrong with the query? Matt...

Can anyone tell me if pre-loaders are only used on a 100% flash site? Or are they used with an html site including a few basic flash 'bits; (such as menu, logo etc)? Matt London (UK)

Skip, each time a user adds a comment to a project, it created a new record in the table, containing those three rows. all comments will be different. I just need the most recent comment (going by the one with the most recent CreateDate Field) for EACH project. much like PH suggests. Im just...

the latest one is identified as being the one with the most recent CreatedDate. I'm using MAX(CreatedDate) to achieve this, but I have to group on both of the other fields. Matt London (UK)

Hi, I have 3 columns from a table (Comments) I need to report on. 1. Comment 2. CreatedDate 3. ProjectNo I need to return the latest Comment, but when I try to write some SQL and use the GroupBy expression, I have to group by all fields (apart from the Created Date, as i'm using a MAX...

Right, i DO have CR 9 installed on the same server as CE10 - although I can't uninstall CR9, as I need the Notes SQL driver that comes with it. (i'm assuming that uninstalling CR9 will also uninstall the data access drivers?) That article implies that CR10 and CE10 will work together without...

I am using CE10 and its installed on an NT server. i'll have a read of the blurn and let you know if it solves my problem. thanks for your reply, Matt London (UK)

right, I got around that error by choosign a different viewer in the preferences, but now I am getting an error when I enter my parameters and all is going well, it displays: "Failed to load database information. File dd03b5658bc1d39.rpt [on Cache/Page server: escalus.pageserver]" with escalus...

yet another error, accessing some of the objects that come with CE. I click ont he object once have logged in to the admin launchpad. when I try to 'preview' the report I get the error: Unable to retrieve Object. Object doesn't support this property or method does anyone know why this might...

Hi, when I try to log into Crystal Enterprise using the Administrator user/password I get the error message: "There was an error retrieving data from the server: Plugin Manager error: Unable to locate the requested plugin CrystalEnterprise.ePortfolio on the server. " does anyone know what...

Hi, I'm need to write an insert statement on one of my tables. This is an example of the table: Proj_ID Text_REF_UID TEXT_FIELD_ID TEXT_VALUE 8192 0 188743734 UKPROJECT1 8192 0 188744007 Fred Bloggs 8192 0 188744011 11.3.2 8192 0...

thanks, PH, I adapted this script to Oracle SQL and tried running it in SQL+, but it returned the following message: ERROR at line 1: ORA-00001: unique constraint (MSP_TEST.I_MSP_TEXT_FIELDS) violated any ideas? the table is MSP_TEST.MSP_TEXT_FIELDS - which is what I entered, but for some...

Hi, I'm need to write an insert statement on one of my tables. It is a linked table from an Oracle Database for Microsoft Project. This is an example of the table: ProjID Text_REF_UID TEXT_FIELD_ID TEXT_VALUE 8192 0 188743734 UKPROJECT1 8192 0 188744007...

Hi folks, I need to build a flash website rather soon! I have dreamweaver MX 2004 and Flash MX 2004. I want to have one of those 'loading' screens when users first click on the site. I'm not sure how to do those. (I am a complete beginner, and I've just bought 'Flash MX for Dummies'!! After...

thanks for that. it works well. I substituted the 0 for a message to be displayed. Matt London (UK)

have you tried using the auto-filter so that you can choose which codes you want to filter on? Matt London (UK)