Search results for query: *

Thanks, hilfy, I look forward to receiving your update!!! No other rseponses to my question so far, so grateful for your help. -Helen

Got it. Thanks for the good advice, Madawc. :)

SAP BO XI 3.1 Oracle 10g Crystal 2008 Crystal field size in Crystal remains intact. (String field, field format "lock position and size" checked.) Test same Crystal report in BO XI 3.1 Infoview. Run report. Crystal field size extends beyond right margin of page - size is no longer...

Fiscal Quarters - main and subreports Resolution to this - sorry, lbass, just noticed I hadn't responded last year! Did find a solution, posting in case it's useful for others. Yes, I created parameters for "Month" and "Year" and then the specific db date must fall within the two formulae...

...for performance purposes. I will also probably create a look-up table for Divisions, same reason. CREATE OR REPLACE PROCEDURE HISTDBA.WKMAIN /********************************************** NAME: WK PURPOSE: REVISIONS: Ver Date Author Description ----- ---------...

Excellent. Thanks again!

Thanks so much, Turkbear! Exactly what was needed. These don't mention Crystal 2008. I'm assuming the same applies ... ??? Best, Hsandwick

Crystal 2008 Oracle 9 SAP BOXI3.1 Test Oracle Stored Procedure below. Appears to run successfully created in Toad, in HSANDWICK schema. (1) Cannot access in Crystal Data Source Expert. Is the procedure correct and any idea why it can't be accessed in Crystal? (2) This is just the first...

Thanks, Madawc, that's how I'd approach it, too! I'm wondering how to do it within the group select expert as an alternative. No biggie. Appreciate your feedback. -H

Crystal 2008 Oracle 10g Report has two groups Group A Region Group B City Group A Region results: Region 0 Region 1 Region 2 Region 3 Want to merge Group A results when they are "0" or"1" as "Region 0"; all other Group A results remain broken out as they are. Thanks!

Hi, hilfy: I am using dynamic parameters in the main report, but no cascading dynamic parameters in it or the subreports. Your suggestion got me thinking, though, and some more research led me to believe it must be to do with the system setup and the firewalls. When I run the report on my...

Crystal Reports 2008 Oracle 10g BOXI 3.1 The report comprises one main and numerous subreports. When logging into the report (the crystal report, outside the BOXI environment), there are multiple requests for permissions to connect. The first is the production box, that is expected. This is...

Great! Thank you, lbass.

Crystal 2008 Oracle 10G BOXI 3.1 The report has parameters for Month (can be 3/6/9/12 for Fiscal Quarters) Year (can be any whole year number) A Division There are multiple subreports, also with date ranges, dependent on the date ranges of the main report (e.g., (1) retrieve all prior fiscal...

All right, so back to this one. So, let's say I'm running the main report for the 2nd Fiscal Qtr in 2010. I will want to capture results in the subreport for Fiscal Qtr 1-2 in 2010 (i.e., Calendar4thQtr 2009 through Calendar1stQtr 2010).

Hello, lbass, I did copy the code as suggested: (select max("EVENT_EFF_DTE")from "PDRMF_ALL" Awhere A."SSN" = "PDRMF_ALL"."SSN") ) (copied directly from above once more just now), but it didn't work. So, then I tested it but added the schema name, also, and while this collected results in...

Copied the sql, still received errors (table or view does not exist). Ran tests in TOAD, this works below, where the schema is included: (select max("EVENT_EFF_DTE")from "HISTDBA"."PDRMF_ALL" A where A."SSN" = "SSN") Running the report with this sql expression, it kills the already slow...

Thanks, lbass and FireGeek21 - it'll be early next week before I can test this, will try it out and let you know. -H

(select max("PDRMF_ALL"."EVENT_EFF_DTE")from "PDRMF_ALL" where "PDRMF_ALL"."SSN" = "PDRMF_ALL"."SSN")

Thanks, lbass. I created the sql expression, and now I'm receiving the error message, "Error Compiling SQL Expression : Failed to retrieve data from the database ORA 00942 table or view does not exist" But the error is only relevant to the SQL Expression. The table exists and all results...