Search results for query: *

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

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

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!

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

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

Crystal 2008 Oracle 9 Business Objects 3.1 In a subreport, I am retrieving TopN = 5 results for each Division (a group), based on the total count of all unique employee ids within each group that exist within a date range. So, results look like this Group Employee Total Count A...

Crystal 2008 Oracle 9 SAP BO XI 3.1 A. I need to capture all results in a main report based on parameters for (1) Fiscal Qtr (2) Year (3) a Division (or group). How do I capture a Fiscal Qtr, please? B. I have a subreport linking to this main report that will retrieve all results based on...

Crystal 2008 Oracle 9i BOXI 3.1 In a subreport, I want to show descending results for the Occupations within a Division that have the 5 greatest total # employees within each Occupation. So: Division ABC Occupation Code Sum Total # Employees in Occupation 12345 500...

Crystal 10.5 Crystal 11.5 Crystal 12 Are there any known contentions when multiple versions (above) of Crystal reside on the same computer? Thanks!

Reports work with: Crystal 11.5 SQL Express 2005 Visual Studio 2005 Windows XP I have a client that runs a handful of reports successfully in the environment listed above. However, it ran into contentions when it upgraded to Crystal 12. Unfortunately there has not been a solid versioning...

Is it possible to capture data for 2 months ago using "lastfullmonth" in the record selection criteria? I.e., lastfullmonth -1 is what I am trying to achieve. Thank you, Helen

Hello, I need to retrieve data for the entire last month (and then run a scheduled report any day of the current month). In its simplest form, this is what I'm looking for: SELECT TABLE.DATE_RECEIVED FROM TABLE WHERE TABLE.DATE_RECEIVED IN ..... LAST MONTH Appreciate your help, Helen

The field being retrieved from the database is a string field, but is presented as 1:00 1:15 (hrs:mins). Total should be 2:15 Summarization of the field does not calculate correctly. So, convert the field to number type as total mins, e.g. 60 75 Total 135. How do I calculate that 135 back...

We have just one user receiving this error message, only in the Test environment. It works in Dev and Prod, and for everyone else. -------- Error This field name is not known. Details: errorKind Error in File /var/tmp/{02FA4450-0563-11DD-92E4-0003BA8559A9}.rpt: Error in formula . 'IF...

BOXIR2 Infoview Crystal Reports 11 Hello: I have a published Crystal Report in Infoview, requesting user input in a parameter (text field). Is there a way to focus the mouse inside the text field, ready for the user's input, rather than having the user click within the field, and then enter...

BOXIR2 Crystal Reports 11 Oracle 10G INFOVIEW I have a Crystal Report published in Infoview. Within the report, there is a field that links to an external application. The Crystal Report automatically opens the link in a separate window, allowing the client to review both the external app and...

Crystal Reports 11.0.0.895 Oracle 10g BOXIR2 Infoview Hello: I am testing a crystal report that is to be scheduled to run at a specific time daily, and delivered to several recipients. The crystal report includes a currency field which retains the correct position in the physical crystal...

Crystal Reports 11.0.0.895 Oracle 10g BOXIR2 Infoview Hello: I am testing a crystal report that is to be scheduled to run at a specific time daily, and delivered to several recipients. The crystal report includes a currency field which retains the correct position in the physical crystal...