Search results for query: *

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.

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.

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

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.