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...
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
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.