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 derfloh 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: *

  • Users: ETCS
  • Content: Threads
  • Order by date
  1. ETCS

    Determine specific date within a date range

    Hey all, I have a report used for determining whether or not a task was completed within service level agreements. Basically I am calculating the date diff to make this determination. However, holidays are giving me some heartburn. I need a way to determine whether or not a holiday fell...
  2. ETCS

    Formatting Charts in Crystal XI

    I have a report that shows the total number of help desk calls taken by my team. There are two groups; First a date field for the Year, and the second group a date field for the Month. The Month group displays the count of calls taken by the team. I inserted a graph so I could do a year over...
  3. ETCS

    Is There A Way To Sort Running Total Fields?

    I have a report that counts occurrences of trouble tickets. It uses two groups. The first being the product family and second the issue Category. I have a sum field showing the total number of issues in each category. I have a group sort on the category summary field to display only the top...
  4. ETCS

    Saving Formatted Data as Actual Data Value in Excel

    I have a spreadsheet with a list of clients that I need to import to my database. The Phone and Fax numbers in this sheet are 10 straight digits with no formatting. They need to be in standard Phone format before they are loaded to the db. I can change the cell format in excel, but it only...
  5. ETCS

    Charts and Multiple Columns

    I am creating a report that needs to show a chart and it's corresponding detail. Is there a way to have the chart show across the full width of the page but place the detail into the multiple column format? When I attempt to do this, the detail that shows in the second column is going to the...
  6. ETCS

    Accurately Calculating YTD Average in Excel?

    I have an Excel spreadsheet that is being used to graph an average Year To Date value based on 12 individual monthly values. Obviously, as you move through the year there will be later monthly values that are zero because you don't yet have data for them. This causes the AVERAGE formula to be...
  7. ETCS

    Server Login Prompt from Parameter field??

    I have added a new parameter field to an existing Crystal XI report. I have set it up as a Dynamic list and pointed it to the field in my database where the values are stored (in this case Client Names). When I refresh the report and indicate that I wish to be prompted for new parameter values...
  8. ETCS

    Combination Chart Type?

    In Excel, there is a chart option that allows you to show one set of values as a bar graph and a second as a line. Is there any way to do that in Crystal? Barring that, I need to insert a "goal line" into my chart to show which values rose above or fell below the management goal for that...
  9. ETCS

    Page Footers in Cross Tab Report

    I'm using Crystal XI and have built a cross tab report. The report exceeds the bounds of the right margin. That's not a problem as the remainder of the report simply wraps to a second page. However, Crystal apparently doesn't recognize the fact that there are now two pages. This is an issue...
  10. ETCS

    Conditional Formatting Not Working

    I have created a cross tab report in Crystal XI. I need to display any negative numeric value as red rather than the default of black. This is the formula I am using in the format editor for font color: If {SigVarBalances.Variance} < 0 Then crRed Else crBlack My problem is that, when...
  11. ETCS

    Pulling values from different tables into Detail record

    I am creating an employee evaluation report. The report is grouped by the employee's manager. Though all the employees in the detail record have the same manager, they have one of two different positions. Their manager fills out evaluations for each employee based on the responsibilities of...
  12. ETCS

    Moving data from subreport to main report in Crystal XI

    I am having a problem passing values from a sub report to the main report. My main report lists tech support personnel and the number of support tickets they closed for the month. The main report is grouped by user name. The sub report provides the number of days the user was available to...

Part and Inventory Search

Back
Top