Recent content by misterjib

Thanks for the feedback dhookom. I've not used domain aggregate functions much - I shall investigate for future reference. misterjib.

Hi Everyone. I've binned this approach now because I couldn't get it working and instead used a two step process (which I didn't really want/couldn't be bothered to do) where I first create a temp table to get the COUNT of the DISTINCT IDs then UPDATE the target table with a JOIN on the temp...

Thanks Denny for that nudge in the right direction - it's not quite working yet but found this: http://www.sommarskog.se/grantperm.html#EXECUTE_AS which i think is going to prove useful reading. JIB

Can someone please tell me what permissions need to be granted to a role (owned by dbo) in order to execute this SP (All the dbs are sa owned) USE [master] GO /****** Object: StoredProcedure [dbo].[spDatabaseProperties] Script Date: 02/10/2011 11:05:47 ******/ SET ANSI_NULLS ON GO SET...

Hi people. I've got this on the timeline of an MC: _root.seQ1MC.b_seQ1yes.onRelease = function(){ tickVar = _name; //trace("local tickVar = " + tickVar); //trace("this tickVar value = " + _root[tickVar]); if(_root[tickVar] == true){ gotoAndStop("tickOn"); tick = 1; //tick is defined etc when...

Forgive me lbass - your solution works fine in the footer. many many thanks

This is brilliant lbass, really appreciate your assistance, but i'm still having difficulty displaying. can i just say, i'm a graphic person not a programmer... ok so: detail section whileprintingrecords; numbervar INR; if {Reviews.Date} = nthlargest(2,{Reviews.Date}) then ( INR :=...

I'm probably (being) a bit stupid - any help is sincerely welcome. All i want to display is a single record in my report header /footer depending on Nth Largest. I've summarised the Nth most recent date and i cant for the life of me work out how to display values from other fields in the same...