Recent content by jwrjwr54

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