Recent content by hsandwick

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

Crystal Reports 2008 Oracle 10g Toad 9.6.1 SAP BO 3.1 My SP runs successfully in Toad, Crystal, and BO Infoview. I am now addressing the Parameters and need some help, please. See SP w/dummy detail and Package examples below. (This is a weakly bound package, yes? Do I need to use a...

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