Search results for query: *

I had this SQL Expression field working in CR 8.5/Oracle 9.2.0.6 based on advise in the posts here since last 2yrs. However when I switched the report to point to different database instance of the same Oracle version 9.2.0.6, it throws an error: Error in Compiling SQL Expression - Invalid Field...

Hi, I have the following data: Section Countries 1 USA 1 IND 1 CHN 2 KRA 2 BRZ I want to retreive the name of countries for a particular section in a single field on the report...

I'm looking for some Project Management Tools that can handle back-scheduling (like if the product has to be delivered by 15 Dec. 2005, then set up scheduled tasks from April to Dec. based on the time taken by each task)and roll-up capability (like if one of the tasks is held up and can't be met...

Hi, I am having problem in CR 8.5 returning Views with PUBLIC synonym. I can see the tables and stored procedures with PUBLIC synonym but not VIEWS. This is a global View that resides in a different database than what I'm reporting against(but my database instance has access to this View) and...

Hi, I am in need of some advice as to how to handle and get rid of blank spaces created in the sub-report because of suppression of rows by the formula. For example: I have a sub-report A in which the records appear like this: 123 jsdhfdsfsdafdsfjsaj dfksd 345 fdsfklsjfdslfdsfjkm...

Hi, I have 2 sub-reports A & B. B is placed below A(CR 8.5). Sub-report A returns Material ID's from the database. I have to display only those Material ID's in sub-report B which are not displayed in sub-report A. For example: Database Returns following Mat ID's for sub-report A 18052717...

Hi, I want to display the following information in the sub-report which is linked to the Main Report on Batch_ID. Mat_ID Request_ID FM12 123 FM34 234 FM56 345 249 934 But the report only shows the following: Mat_ID...

Hi, I want to access a shared variable value in a sub-report that is below another sub-report having the same shared variable, however the shared variable is not returning the true value. This is what I have in Sub-report A(CR 8.5): @FM_CM_Flag // in the header section Whileprintingrecords...

Hi, I want to conditionally suppress or display values in Sub-report A, based on the values in the sub-report B which is after or below the sub-report A. Is is possible with shared variables or not? Based on other posts on this site it looks this is possible only if sub-report A is below B...

I have this report in CR 8.5 which I published on CE 8.0. Somehow I'm not getting the Thumbnail image of this report. Any clues what do I need to check or implement... Thanks Tek

I have this report in CR 8.5 which I published on CE 8.0. Somehow I'm not getting the Thumbnail image of this report. Any clues what do I need to check or implement... Thanks Tek

I have the following formula in the sub-report which is linked to the Main Report by Batch_ID: //@Country_Code_GH -- In Group Header - Suppressed whileprintingrecords; stringvar TheCountries:=""; //@Country_Code_DT -- In Detail - Suppressed whileprintingrecords; stringVar TheCountries; If...

My report CR 8.5 with Oracle 7.3.4 has one mandatory (date) and 3 other optional parameters. I am able to push all other selections to the server except this: Parameter -- Country ( If {?Country} <> '' then {CL_REQUEST_ST.REQUEST_TYPE}="PSR" and {MM_LOT_ST.RETEST_DATE} <= ({?Recert date}) and...

GH1 -- Mat_id GH2 -- Lot_id GH1a -- Mat_id GH2a -- Lot_id GH1b -- Mat_id GH2b -- Lot_id Or is there some other solution to achieve the above ? Alternatively, I can GH1a- GH2a and GH1b-GH2b in 2 different sub-reports in 2 sections of GH1(1a and 1b) but I definitely need to have...

I have Group Headers 3a and 3b based on MatId. Group 3b has a sub-report. For different values of MatID GH 3a gets printed. However when sub-report has no values then the section 3b is empty(because sub-report is suppressed if no value returned). In this case, there is a blank space created for...

Can formula fields be used for conditional formatting of a Section in CR8.5? I want to suppress a section if the result of a formula field in the section returns no value or is empty. I tried to use -- ISNULL(@G_LG_Mat_Id) but it throws an error saying -- "The )is missing" Thanks for your...

I have the following information displayed like this: -- GH3a(Group by Material_ID) Material ID: Description: FM3051-1-1 STANDARD PLACEBO CAPSULES #1 BLUE (LACTOSE), BULK FM3806-1-1 SCH 420814 CAPSULES 25 MG/CAP, #1 BLUE, BULK Lot: Recertification Date: Expiration Date...

Hi, I have the following database structure: Table:B_LINK Batch_ID 2 3 Table:G_LOG Batch_ID Mat_ID Lot_ID 2 FM321 H05 2 KX123 H03 2 23456 H04 3 FM123...

Hi, I have the following records from the database: MatID Country 2 US 2 PR 2 PR 2 2 2 US 2 CA 2 US 2 US Display Requirements: 1) The values in field Country should be...

Hi, I am in need of a formula to suppress a Section in order to resolve this: I have the following material types - A, B, C, D, E, F 1) If the records returned from the database are of Material Type A + Material Type B OR Material Type A + Material Type C, THEN Display the Section with...