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

    Need to insert Average Line in Bar Graph

    Try using trending....I found another thread similar.. On your bar chart, right click and select 'Chart Analyzer'. Select any one of the 'Bars' and right click on that same bar, this will display a menu, hover the mouse over 'Format Chart' and click on 'series' (also notice just above 'format...
  2. btgreen

    conditional format of cells in a cross-tab

    I am being told that this is not possible
  3. btgreen

    Crosstab Totals Formatting

    Hello, Is there any way to conditionally format the totals that are produced in crosstabs? I have applied the typical formatting practices but crosstabs do not react as expected. It seems as if it is evaluating the field on a row-by-row basis and not a total basis. Thank you in advance.
  4. btgreen

    MISSING DATA

    Thank you very much. This resolved the issue. Additionally, if you add a details section with all fields that are displayed on the crosstab report and suppress the detail section it will resolve the issue.
  5. btgreen

    MISSING DATA

    Thank you for your response. Unfortunately, that was never set. There are two options for the filter I am setting. If I set it to the first option data is returned for all 13 months. If I set it to the other option (there is data in the table for both options for all 13 months) it only...
  6. btgreen

    MISSING DATA

    Hello, I am having issues with data not showing with crosstabs. I have tried saving with AND without data. It is dropping data off but the chart which points to the cross tab shows all the data. Any help would be appreciated
  7. btgreen

    Invisible Jobs and DTS owners

    Thank you very much. SA was an option for the time being so we are back in action.
  8. btgreen

    Invisible Jobs and DTS owners

    Thank you for your reply. The information in this above reference seems cryptic and does not provide an apparent answer.
  9. btgreen

    Invisible Jobs and DTS owners

    Hello, Is there anyway to make all jobs visible to everyone. We can currently only see our own jobs and this causes issues with trying to do other people's work when they are absent. I think this has something to do with the permissions on the SQL Server. We all authenicate with Windows NT...
  10. btgreen

    append to nText

    Have you tried using string? I have built 4k strings before and then call exec(string)
  11. btgreen

    append to nText

    What front end are you using to store this 4k value?
  12. btgreen

    ActiveX Tab Control color

    Hello, I am trying to change the color of the Page tabs in Access 97's activeX Tab Control (TabCtl). It doesn't appear to support any color properties for the tabs themselves. Thank you in advance for the help.
  13. btgreen

    subselect query

    This was just a sample query not actually the data I needed. I have to do a subquery as I need all the data in the outside query and only those results that match criteria in the subselect statement.
  14. btgreen

    subselect query

    Hello, I am trying to write a subselect query but am getting an error message. Does DB2 support subselects similar to that of Oracle and MS SQL? Here is an example. SELECT SUM(AMT) as sum_amt, a.SBSR_ID, a.SPSR_ID, (SELECT COUNT(AMT) FROM asouthard.eclaims b where b.spsr_id = a.spsr_id...
  15. btgreen

    CROSSTAB Percentage Totals (dividing running totals)

    I have a report that show percentage based on a/b. I want the total for that to be sum(a)/sum(b) but the crosstab reports tryings to summarize it by sum, count, weighted average, etc.... How do I force a new column with the running totals calculated percentage? Thanks in advance. btgreen
  16. btgreen

    Table Joins In COGNOS

    You will have to have someone set the catalog up with the relationships. It will automatically pull the relationship if that is the case. If not you have to add one of the columns and then within the query tool under the filter tab you have to create an equals statement. The Filter tab is the...
  17. btgreen

    Excel Tabs and Cognos Page Breaks

    If I add page breaks to my IMR report will it export to different tabs in Excel? I am going to be ordering a 142,000 row recordset and would like it to break into different excel tabs for every new row value for which I am ordering.

Part and Inventory Search

Back
Top