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

    Dynamic Dates in Charts

    I am using CR10 and am creating a line chart that displays the number of calls by week, on a rolling 3 month basis. I am showing data on a rolling 5 year basis, over those same 3 months. So for this instance, i will have a data line for 2003, 2004, 2005, 2006, and 2007, with data points on...
  2. sarend

    Dynamic Dates in Charts

    I am using CR10 and am creating a line chart that displays the number of calls by week, on a rolling 3 month basis. I am showing data on a rolling 5 year basis, over those same 3 months. So for this instance, i will have a data line for 2003, 2004, 2005, 2006, and 2007, with data points on...
  3. sarend

    Watermark in Crystal Reports

    I already know how to create a watermark in Crystal, however, I need to know how to make it permanent. Most of our reports are delivered to our internal customers as word, pdf, or excel files. These customers tend to share our reports to others. Because of this, we would like some sort of...
  4. sarend

    Calculating monthly totals based on what month the week begins

    I am creating a report in Crystal 10, that will run weekly (Sunday - Saturday) showing records that were opened in the prior week. In addition, the requester wants a monthly report showing records that were opened in the prior month. At first we created a formula using lastfullmonth function...
  5. sarend

    Calculate prior month using all weeks that began (Sunday) in that mont

    I am creating a report in Crystal 10, that will run weekly (Sunday - Saturday) showing records that were opened in the prior week. In addition, the requester wants a monthly report showing records that were opened in the prior month. At first we created a formula using lastfullmonth function...
  6. sarend

    Need help substringing part of a field

    Thank you lbass and turkbear! Our team is going to tell the users that unless they all key in the decription using the same format, there is no way for us to report on this due to it being a free-form text field. Thanks again for you help.
  7. sarend

    Need help substringing part of a field

    Thanks! I just tried it and it works for some records but not all. here is example: Here is the ACTION field. 04/03/07 16:26:14 US/Central (empname): Updated 04/03/07 16:18:08 US/Central (empname): Added to Windows Server Maintenance calendar. As stated above, I display the record everytime...
  8. sarend

    Need help substringing part of a field

    I have a field that grows each time a record is updated. It contains the Date, Time, employee, and a description. I am pulling this field everytime it is updated, however, I only need the most recent record and I don't want all the other information. Here is an example of the field...
  9. sarend

    Conditionally Suppressing Group Headers

    I tried that formula, but since GH3 and GH2 are both summaries, it will not allow to me to do a count on a summarized field. This is what i have: DistinctCount(GroupName({sub-dept}),GroupName({team}))=1 and GroupName({team}) = GroupName({sub-dept}) The error I get is: field cannot be summarized.
  10. sarend

    Conditionally Suppressing Group Headers

    I am working on a project in Crystal 10 that involves three Group Headers. GH1 gives totals for the Division, GH2 gives subtotals per Team in that Division, and GH3 gives subtotals per Sub-Dept for each Team in that Division. Here is a section of the report: GH1(Division) -->...

Part and Inventory Search

Back
Top