Search results for query: *

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

Hi guys, Thanks for the feedback, has resolved some of the issues but am now experiencing this one - realting to the third element in the Thread solution: //@DisplayStrengths WhilePrintingRecords; Stringvar result; {PCH_Individual_Strengths_Pen_Portrait.Strength_Category} +...

Ngolem, I am running CR 9 / SQL 2000 and the problem identified in Thread 149-714484 thought would provide me with the answer I was looking for. I have multiple records across a range of criteria - Strenghts/ Qualification/ Experience/ Skills. No matter how I structure the report (Group...

Hi, Tried juggling around the Grouping order with Company_Name (1st sort) and {@Sort Choice} (2nd) Unfortunately this over rules {@Sort Choice} therefore the report always shows Company_Name alphabetically irrespective of the choice made in {@Sort Choice} - which has no affect on how the data...

Hi, am running CR v9 and SQL 2000. A report change has been requested which I'm uncertain is possible but I have to try and look into it. The up-shot is that the report has a user defined sort option (which works well and sorts data at a top level), but now I need to try and introduce two...

You were right something is 'odd' between CR and SQL. I'll just have to go back to basics and check it all out again. So don't think that anyone can help on this - thanks anyway. Will drop a line when I find out what is happening, mightbhelp someone else! Cheers