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

  1. thelittleone

    Hide a Calculation Field in a Chart

    Hello, I have added a Calculation field to a chart to sort 'Date' values in a specified order (JAN, FEB, MAR). I would like to hide this Calculation field so that it does not render on the report. However, I do not see an option to modify the font settings, nor am I able to use CTRL > X to...
  2. thelittleone

    Cascading Prompts On Same Page

    Keep in mind that reports with prompts on a single page cannot be scheduled.
  3. thelittleone

    Conditional Formatting and Grouping

    CategoryCode is a numeric field. For some reason I had to enclose the CategoryCode values in apostrophes. You would think that the datatype was string, but it really is integer. I have one more step to take. Now that I have the CategoryCode values grouped and the BudgetValues summed, can I...
  4. thelittleone

    Conditional Formatting and Grouping

    Can you please outline the procedures to follow. I added a calculation to the report incorporating the above statement and the application returned a SQL error. The only way that I have been able to progress further is by adding a Group Calculation field to the report. After adding the Group...
  5. thelittleone

    Conditional Formatting and Grouping

    Hi All, I have the following result set and would like to Conditionally Format and then Group the data: CategoryCode OriginalBudgetValue 18000 5000 18001 3250 18002 1450 18005 6200 Conditional Format - If CategoryCode BETWEEN 18000 and 18005 then...
  6. thelittleone

    Format DateTime Value in Cross-Tab Report

    Hi All, I am attempting to create a Cross-Tab report with a datetime value as one of the measures. Upon adding the query item to the measure and modifying the Data Format type to Date, the value continues to display as 20,041,217. I would like the date value to display as 2004/12/17. Thanks in...
  7. thelittleone

    SQL One to Many Relationships

    RFI 001 AECOF RFI 001 ABDRC RFI 001 GFVDE After grouping the above example by RFI number and suppressing duplicate values, I am faced with the following layout: RFI 001 AECOF ABDRC GFVDE Is there a formula that I can create to display the information in the following manner...

Part and Inventory Search

Back
Top