Search results for query: *

Hi Bob, Thanks for your code. I have tried it but it does not populate my time list. Also I need some help closing the frame once I submit. My project navigates between 3 frames. But I want to close the desired frame. Here is the code for the TimeSlot Class <code> class TimeSlot2 extends...

Hi Bob, Thanks for your reply. I could understand what you said, but was unable to figure out how to implement it. Can you please send me a small piece of code how to implement it. It would be really great thanks. Uday

...from the list. Can someone help me how to implement this, Here is the code that creates a the frame for the TimeSlot, <code> import java.awt.*; import java.awt.event.*; import javax.swing.*; class TimeSlot1 extends Frame { Choice day,time; Label l1,l2; Button submit,cancel...

Hi, I'm using CR 8.5 and SQL server 2005. When I run my report I get an error message, The page size was not large enough to format the contents of an object in the report. Can some one please help why does this happen and how to overcome this. Thanks, Rahul.

Hi, In my report I want to display the Month and year for a date entered by the user. Say if the date entered is [1/1/2007] My report should display As of January 2007 And for that I'm using the following formula MonthName(Month({?Start_Date})) + " " + totext(tonumber...

Hi angelana, I have a sub-group,whose field has just two values, Peak and off-Peak. So I used running totals for with the sub-group totals in the main group footer.And it worked for me. But as discussed earlier, if the sub-group field has more values then I think a sub-report will give you...

Hi, I have been struggling with this report for quite sometime now. I have a problem,which is counting the number of calls for each employee. Here is how my data looks EMP_ 1.EMP_ID 2.EMP_GID 3.PID 4.EMP_NAME 5.EMP_TITLE ... ... EMP_GOALS 1. EMP_ID 2. EMP_GID 3. EMP_PID 4. NAME_EMP 5...

...sub-total2 (fld1+fld4+fld7)(fld2+fld5+fld7)(fld3+fld6+fld9) (Grp-footer) total sub-total1-points (=sub-total1) sub-total2-points (=sub-total2 * 2) Total Points (=stotal-pts1 + stotal-pts2) But for some employees it shows as: Emp_NAME (Main_Grp) Peak_Flag (sub-grp1) 2007...

Finally, succeeded in completing my report as desired. I just had two groups under my sub-group, so decided to use Running totals for all the fields with the Fields to be evaluated to be the Sub-Report's sub-total fields...and It turned out to be perfect. Anyways thanks guys for your help and...

yep. I tried the same thing. But the style of cross tab in CR 8.5 doesnt look good. With such a big report and such a huge crosstab...I just want my data in a single page...So was looking to accomodate it in a single page...I guess a sub-report as suggested 'Madwac' would do.. Let me try that...

Also I'm using Crystal Reports 8.5 and SQL Server 2005.

...... ... ------------------------------------------------- sub-total2 (fld1+fld4+fld7)(fld2+fld5+fld7)(fld3+fld6+fld9) (Grp-footer) total sub-total1-points (=sub-total1) sub-total2-points (=sub-total2 * 2) Total Points (=stotal-pts1 + stotal-pts2) Hope this helps...

I tried doing that but that doesnt work. Is there any other approach that you can suggest. Thanks, Rahul.

Hi Alex, How do I clear all the data from the table 'GOALS' once I copy the data into a temp table. Thanks, Rahul.

...... ... --------------- subtotal2 (Grp-footer) total sub-total1 points (sub-total1) sub-total2 points (sub-total2 * 2) Total Points(stotal pts1 + stotal pts2) This is how it looks... So I need the values of sub-totals again in the main group to calculate the...

I did place all the fields in the detail section, and my complete detail section is being duplicated again and again and also its being added to the total at the end (which I dont expect my report to do). I have now figured out that my database itself has duplicate records,with the same name...

Yes it is the first case, that I'm facing with. Already there is a record with the same data with the property as 'Westin'. But now when I changed the records with the property from 'The Westin' to 'Westin',I have another record with the same data. How do I eliminate this. Rahul.

Hi, Let me be more clear. I have duplicated data and my report looks the following way: Emp 1 (Grp-1 main grp) sub grp (Peak) 2007 fld1 fld2 fld3 2008 fld4 fld5 fld6 ... ---------------------- subtotal sub grp (Off-Peak) 2007 fld1 fld2 fld3 2008...

Hey Mike, Thankyou as well. I'm really sorry. Rahul.

Thanks Alex, It worked. But there are some duplicates which I want to eliminate. Can you please help me how to do that. Thanks, Rahul.