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

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

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

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

Hi, Am running CR 9.0 on SQL 2000. There is possibly a two part problem here which I'll try to explain as fully as possible. 1. Have created a parameter based on project Code, which the user selects to run a single page 'letter'. The problem is that only some of the project codes return the...

Hi, (CR v9.0/ SQL 2000) I need to (cumulatively) calcualte a set of monthly budget figures (which are not held on a Db or anywhere) based on a users date range selection, is this feasible or even practical? I am looking to return just the one value within the report. Thanks in advance

Hi, Having a real problem with this (using SQl2000 with Crystal reports). I have to select all projects starting between 01/04/03 and 31/03/04, no problem, but in addition also have to select project end-dates greater than 01/04/03. Result mainly correct, but still returning the following...

Morning, this requirment has me stumped, am runing CR 9.0/ SQL 2000. My report needs to pick up on Projects started in the last Financial Year (pre 31/03/2003), but finishing post 01/04/2003, AND Projects started post 01/04/2003, (End Date sometime in this Financial Year, but not too...

Hi all, Am running Cr v9 (as of today) and SQL 2000. I would like to be able to show (on screen) all main rpts/ and associated subs where an estimated project value (formula)is not Null (in the sub). The end result is that the output 'should' only print the main and subs that meet this...

Hi, this one has me a bit stumped, am running CR v8 with SQL 2000. The report requires me to do the following: For a given person whose role is Project Sponsor, their name should only appear in the column heading Sponsor, the same applies to Lead Consultant and Project Coordinator (each being a...

Afternoon, Am using CR 8.0 with SQL 2000 and am trying subreports for the first time, with little success. I have two subs which Im using to avoid a data duplication issue. Issue - trying to link these 2 subs via CR's 'subreport link edit' fails, is it a problem that I've got the required sub...