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

If I remove Date(), it does display 2010,10,06. I'll try one record, factor out nulls. Many thanks for all your help Whit

Still getting Bad Date Format Field. Your formula puts the string into a format that Crystal says can be changed to a Date Field. It should work and I'm stumped. Thanks Whit

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

LBass - You are so cool - love the way you think. Wish I could think outside the box Thanks Whit Memphis, TN

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

Thanks CRoompa - that is the process I have to go through, but trying to find some way to eliminate this step. I'm opening, modifying, saving reports all day on BOE, and sometimes I forget to go to the CMC to add password; then none of the users can access the report.

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

Works like a charm. You are a Crystal Genius LBASS!

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