Search results for query: *

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

I am being told that this is not possible

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.

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.

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

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

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

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

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

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

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

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.

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.

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

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

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

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.