Recent content by brendanj68

Hi, am setting up a 2003 Db, which has as its 'data' the table structure (Column Name, datatype, etc) of a SQL2K application. What I am trying to do is call-up a particular table name (through a parameter - as below) from a list of table names (source one), and then either via a subform (?) pull...

Hi mikiap, There are two ways to do this. But firstly it always helps if you state which version of CR and the datasource involved - but that's another issue. If you are using CR 8 or 9 (the version I use) then you can create a sub report (an embedded *.rpt) within your 'main' report. To do...

Synapsevampire, thanks for the feedback - changed the structure/ nature of the report to be based on current month only - no user selection. B

Hi, Using CR9/ SQL2K. This report requirement should look straight forward but I can not get my head around it. I have four sub rpts grouped on GH3 that all use a datetime field. The user needs to select the current month (param to be defined) which retrieves data for sub 1,2 & 3 but sub 4...

Hi, Am running CR9 on SQL2K. My relatively straight-forward report uses a typical (user) selection criteria as follows: {?Sort Choice} is 'By Region', By CPA Rating', etc All of which are defined as default values - works well, no problems. GH1 = {?Sort Choice} {@Sort Choice} is set up as...

Hi, Running CR9/ SQL2000. The following represent some budget periods that needed to be 'hard-coded' for another purpose, now I've been instructed to represent this data in a line chart which is manipulated through a date range parameter. What I would like therefore is as per a budget period/...

Hi All, Am using CR9 with SQL2000. My report has two aims (main rpt - show a cumulative monthly total of new Projects (monthly value, based on 'View1') and via a subreport another cumulative monthly total for invoices raised during the same monthly period as new Projects but via a 'View2'. I...

Hi all, I am running CR9/ SQL 2000, and have a budget/ target related report which I am totally unsure about where to start - so if someone can sugest an alternative to the following I'd appreciate it. The deal is: I have three groups of management types - AD, MC and PC/C each refers to a job...

TomKane, Thanks for the pointer will hopefully find what I need, in answer to your question, we use a product called Pivotal (from Pivotal Corp) and this version only works with CR8 as the 'internal' report writer. Brendan

Hi all I am hoping that someone can give me a few pointers - I have just been informed by our highly efficient central Technical team, that they want to re-engineer all the CR v9 reports I done back into CR8 so we can run them directly from our corporate CRM system. My request is, is there any...

LB, You were right in your assumption I was looking for the Sum (as opposed to Count). Your suggestion was probably the one variable I had not considered i.e. Reset on ClientName. The result is exactly what I was looking for - so once again many thanks. B

LB Here's a sample of data: Employee_Id Employee Start_Date End_Date 0x00000000000001F6 Alasdair Robertson 01/04/2003 30/04/2003 0x00000000000001F6 Alasdair Robertson 01/04/2003 30/04/2003 0x00000000000001F6 Alasdair Robertson 01/04/2003 30/04/2003 0x00000000000001F6 Alasdair...

Hi, Am running CR9/ SQL 2000. My report is supposed to show all Contracted 'days'(and Actual invoiced days) for a number of consultants. The nature of this data means a 1-2-many relatinship is unavoided. I have shown and summed up the contracted days with no problem, but am unable to determine...

Hi Ngolem, Was tring to follow your advice on this issue but have run into some problems - unexplained eror messages, etc., wondered if you could point me a way out of them. Am running CR9/ SQL 2000. 1. array 'Store' - error Result of a formula can't be an array (?) 2. My grouping is as I as...

Guys forget last note, resolved that error, but having got it running successfully am not sure that this will resolve the original issue. Going back to drawing board - but cheers for time taken. B