Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rahulroy08

    How to select the Time slot...

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

    How to select the Time slot...

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

    How to select the Time slot...

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

    error: the page size was not large enogh to format the contents of the

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

    How do I change the format of the Year

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

    How do I use the totals of sub group in the main group...

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

    How do I count the total number of calls per each employee

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

    How do I eliminate the duplicates.

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

    How do I use the totals of sub group in the main group...

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

    How do I use the totals of sub group in the main group...

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

    How do I use the totals of sub group in the main group...

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

    How do I use the totals of sub group in the main group...

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

    How do I use the totals of sub group in the main group...

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

    Updating a field in a table..

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

    How do I use the totals of sub group in the main group...

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

    How to select distinct rows...

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

    Updating a field in a table..

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

    How to select distinct rows...

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

    Updating a field in a table..

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

    Updating a field in a table..

    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.

Part and Inventory Search

Back
Top