Search results for query: *

Hello I have over 2000 users of InfoView at my company. When a user schedules a Crystal Report, selects Destination>Email (SMTP), and enters an email string, the string apprears whenever another user logs in to schedule an instance of the same report. Is there a way to delete the email string...

I'm using Crystal Report XI against an Oracle DB. Is there a way for a pie chart to show the name of the pie slice (label), the number (value) AND the percentage at the same time? I can show Label/Value with % in the Legand, or I can show Label/Percentage with Value in the Legand. I would...

I know this is simple, but can't make it work: Using CR XI against an Oracle DB {PROJECT_MV.CURRENT_PHASE_FINISH_DATE} is a String field formatted as '2010-10-31'. When I add Date or CDate (i.e., date({PROJECT_MV.CURRENT_PHASE_FINISH_DATE})), I get a Bad Date Format String error. Thanks for...

Using Crystal XI against Oracle DB. Anyone have a simple formula for converting a string field (YYYY-MM) to a true date field? Thanks

Afternoon all - I am using Cryatal XI against an Oracle database. In my x-tab, I have 2 formulas in the Summarized Fields section (Rows section is blank) and a date field in the Columns sections. I am summing both formulas, and I get the correct data for each month in the Columns section...

I have to export many reports into Excel for Executive Management to use with Excel Pivot Tables. However, when I export, each row (group) only has a single data element (as in Row 1): Row1 Row2 Total 6/6 6/13 6/20 6/27 Emp Emp 1 43 - - 40 3 Emp 2 43 30 6 8 - Emp 3 41 33 - 8 - Emp 4 62 - - 8...

I'm using CR XI with an ODBC Oracle connection. Is there a way to add the Oracle Database name to the RH? For example, I have 3 Oracle databases (ERDDEV, ERDTEST, and ERDPROD). I would like to add 'Data Source:' and a field that would automatically update when I change datasource locations...

Morning Whenever I add a report to Business Objects Enterprise server from my desktop, I have to go into the Central Management Console and add the database password, even though I ran the report on my desktop before adding. Is there a way to have BOE retain the password of the report? Thanks

I'm using Crystal Report XI against an Oracle DB. Is there a way for a pie chart to show the name of the pie slice (label), the number (value) AND the percentage at the same time? I can show Label/Value with % in the Legand, or I can show Label/Percentage with Value in the Legand. I would...

Is there a way to use the PrintTimeZone function after the PrintTime and show the abbreviations for all the time zones? For example, instead of Central Standard Time,0,CST Daylight Time,-60;3.5.0/01:00,10.5.0/02:00, the formula would show CST. Thanks

Using Crystal Reports XI against an Oracle database. How do I display a field/GH value in a higher group? In this example, Task B has a Start Date of 11/25/2009. I would like to display this value in GH1, but because of the null values, if I drag the field to GH1, I get blanks. The formula...

Using Crystal Reports Professional XI In Excel I have a column of employee numbers. To use these numbers in Excel, I need to convert to a string (the table field is a string value). The only way I can get this to work is to take each employee number, add a " before and after the number, then...

Using Crystal Reports XI Professional, Oracle DB. Is there a way to put an image/text in the RH so that a user can click (hyperlink??) on the image/text and all hidden groups will show? For example, GH1 is Projects, GH2 is Work Activities. GH2 is hidden, but I would like the option to show...

I have a report (Crystal Reports Professional XI) that has one group (manager_employee_nbr) with a cross tab for each manager in the GH1a. Is there a way to schedule this report in Business Objects Enterprise so each manager will only get their section of the report when I schedule as...

Morning I'm using Crystal Reports XI. Anyone have a good way to display an employee's last name, followed by a comma/space, and the first initial of their first name? I've tried this formula, but it does not work: if InStr({FE_ORG.MGR_NM}, ", ") =0 then ProperCase(Left...

Afternoon all Using Crystal XI Professional. I’m trying to create a date parameter that has the following options: 1 – LastFullWeek 2 – LastFullMonth 3 – Specify the Date Range Some of my users would like to schedule the report and need the LFW and LFM options. Other users would like to...

Afternoon all Using Crystal Reports XI Professional I have a simple report with one group (Company - groups data by each company in my Corporation). In GF1, I placed a crosstab. I can not get the InRepeatedGroupHeader to show the Group names on each page because the crosstab brings back...

Afternoon all Using currentdate, I would like to add sequential formulas to add 1 month to currentdate Formula 1 = CurrentDate (03/24/09) Formula 2?? = CurrentDate plus one month - not sure how to write this. When I create a forula: month(currentdate + 1), the result is a number 4. I need a...

I have a formula that concatenates {project.number} &'-'& {project.name} (both are string fields). I need to sort the group in numerical order. 100151-Project A 109833-Project DD 45678-Project ABC 67443-Project AA If I group on tonumber({project.number}), I can sort numerically, and format to...

I have an if-then formula: if certain selection criteria are met then {project_name} The proper results are displayed, but a Null value is included. The field {project_name} does not have a null value in the database. 1. 2. ABC Project 3. DEF Project Distinct count of this formula shows 3...