Search results for query: *

Syn, Actually CR 8.5 doesn't like the Syntax SUBSTR(ACTUAL_KIT_NUMBERS,1,254) and it throws syntax error although it gives result back using TOAD as well as SQL. I'm in dire need of the solution as this has to be promoted to production righ away. Will appreciate a fix for this. Thanks Tek

Syn, In both cases the Driver being used is CR ORACLE 8v3.6 for the connectivity, then why should there be an issue. Is it intrinsic to the SQL Expression field or the Report has to be re-designed?? Tek

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

thanks pgtek, but I don't want to add another sub-report to the main report for this due to efficiency reasons. ~Tek

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

There is no code for this, it is just the connection problem when you do Add Database or Set Location. I can see the TABLES with synonyms but not the VIEWS with synonyms. Also, nothing to do with version of Oracle, it is the Crystal Reports tool that is not resolving/transforming the Database...

Anybody on this.. please. Thanks Tek

I am reporting against an Oracle 7.3.4 database instance. This particular view has a PUBLIC synonym in the sense that it is a common(global) VIEW that is utilized by various departments and hence various database instances. Normally in the Data Explorer window under your database instance tree...

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

Sub report A: Is in GH1a - grouped on : Cl_rqst_btch_link_st.batch_id Linked to Main Report on : Cl_rqst_btch_link_st.batch_id and the record selection is -- {MM_GENEALOGY_LG.BATCH_ID} = {?Pm-CL_RQST_BTCH_LINK_ST.BATCH_ID}and {MM_MATERIAL_SP.MATERIAL_TYPE} in ['ACTIVE','EXCIPIENT','UTILITY']...

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

The link shown in my post is correct and that's the way it works in our business: MM_GENEALOGY_LG."LOT_ID" = CL_RQST_BTCH_LINK_ST."BATCH_ID" (+) I tried with CL_RQST_BTCH_LINK_ST.REQUEST_ID=CL_REQUEST_ST.REQUEST_ID(+) but still it doesn't work. The sql generated is: SELECT...

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

...8.5): @FM_CM_Flag // in the header section Whileprintingrecords; shared booleanvar FM_CM_Flag; if ({MM_GENEALOGY_LG_2.MATERIAL_ID} like 'FM'+ '*' OR {MM_GENEALOGY_LG_2.MATERIAL_ID} like 'CM'+ '*') then FM_CM_Flag := True else FM_CM_Flag := False This is what I have in Sub-report B...

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