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!

  • Congratulations strongm 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. jtr9999

    Crystal Report Bubble Chart Data Labels

    Good afternoon, I have a bubble chart that shows fund names as the bubble. Is there a way to list the fund name as the data label? Thanks Jonathan
  2. jtr9999

    Creating a page number

    I have a report that has some subreports in it. The subreports could be any number of pages long. We have a machine in our mail center that would stuff our statements for us. The barcode formula for this machine consists of 5 characters. Charater 1 and 5 are always an *. Charater 3 is...
  3. jtr9999

    Rolling A - Z

    Works great! Thanks for the help.
  4. jtr9999

    Rolling A - Z

    Is there a way to do a rolling count of the alphabet per page instead of numbers? So page 1 = A, 2 = B, 3 = C and then repeat once it hits page 26. So page 27 = A, 28 = B. thanks Jonathan
  5. jtr9999

    Summing a Field that contains a summary field

    I was looking at another thread titled "Cannot sum a field calculated off a summary total" to solve my problem but was unable to get it to work. I have a report that has two groups. Group 1 = Employer Group 2 = Investment I am summing a datatbase field (balance) on Group 2 and Group 1. I have...
  6. jtr9999

    Counting null value

    Excellent. Thanks for the help.
  7. jtr9999

    Counting null value

    thread767-1596997 lbass The formula's you posted in the thread referenced helped me in my report but I have a question why my original formula didn't work when I did a count on it. I show termination date for a person if they have a termination date and are not active. When I do a count on my...
  8. jtr9999

    Crystal Reports Version 10 for Sage

    That was the problem Thanks guys
  9. jtr9999

    Crystal Reports Version 10 for Sage

    A department at where I work just converted from crystal 8.5 to crystal 10 for sage. I think that is what it is. Can anyone tell me what Sage is? They are having trouble just writing a simple formula in version 10 that worked for them in version 8.5. It gives them and error of "a statement...
  10. jtr9999

    Bar Chart Look Flat

    In preview view I right clicked on one bar, selected chart options, and changed the gap width to 0. When I close out of the chart options dialog box the chart bars still look flat. Am I missing something? Thanks Jonathan
  11. jtr9999

    Bar Chart Look Flat

    I have tried your suggestion but it didn't seem to work. I am using CR 2008. Were you able to view the file? Jonathan
  12. jtr9999

    Bar Chart Look Flat

    lbass thanks for the reply. I'm not sure that is what my problem is. The bars look fine in design view. I saved a picture of what my chart is doing here: http://www.savefile.com/files/1964806 I use depth effect in the chart. Thanks Jonathan
  13. jtr9999

    Bar Chart Look Flat

    Hello All One of the charts in my report prints flat looking. It prints the data how it is supposed to. Except the bar looks more like a line. The bars on my other bar charts touch at the sides. This one however has big spaces in between the bars. I have two groups in my report. One is...
  14. jtr9999

    Problem with new datat source

    I dont really know how to explain what I am doing. I have a one sheet excel file that has some participant information in it. When I go in crystal and set my database connection and then click Update I get the following error. "some tables count not be replaced, as no match was found in the...
  15. jtr9999

    Page Footer

    Thanks for the reply. I guess I could but I have a cover letter as the main report and I didnt want to have a page number on that Jonathan
  16. jtr9999

    Page Footer

    Is there a way I can get a page footer in a subreport? Thanks Jonathan
  17. jtr9999

    Distinct Count

    I am trying to count the number of participants that my report returns. I have my fields in a group footer sorted by ssn. I suppress the section if their balance is 0. I insert a summary and do a distinct count on the ssn and place it in the Grand Total (report footer). The count I get is...
  18. jtr9999

    Report Gives Bogus Data

    I have a report that has 4 sub reports in it. The report prints for certain people based on the record selection in the main report. most of the sections in the main report and sub reports suppress based on some database fields. The main report and a couple of the sub reports have personal...
  19. jtr9999

    Right Function

    I have a database field that is a number. I am trying to only return something if that database field is an odd number. I tried using the right function to do it but that didn't seem to work for me. What I tried is below. It doesnt like that it is a number. I tried converting the field to...

Part and Inventory Search

Back
Top