Recent content by edoherty

I've got a cross-tab containing retail pricing by retailer (columns) and commodity (rows). I've hidden the Total column that contains the totals for each row and would like to replace it w/ an Average column to contain the average for each row's values.

thx for the info. and prompt responce! I've already unchecked "show cell margins". I couldn't drag the lower border up to reduce the size of the field much. I could reduce the field height using the Object Size and Position screen but only to .05 and it still pushes 3 rows on the full report...

That's beautifully done. Although now the new summary field, even though "suppressed" is requiring additional row heigth and page real estate is very important for this report. Any tips for hiding the value all together in the cross tab?

It looks like it's not doable the way I was hoping too: http://support.businessobjects.com/library/kbase/articles/c2011156.asp Anybody have any tricks to get around this? I'm going to see if I can provide the ad pricing as negative #'s from the stored procedure but display as positive #'s and...

I've got a cross-tab containing retail pricing by retailer (columns) and commodity (rows). In the data set, each row for a retailer and commodity also has flag to denote that price as an "ad" price or not. I have a simple IF statement checking that value to change the background color of the...

In order to detach the model, msdb and tempdb databases, SQL Server must be started with the -T3608 trace flag enabled.... http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

It's resolved!!! We discovered a startup parameter (-T3608) used during the migration so we could move the Model & MSDB database for performance and standards reasons hadn't been removed. After removing it and bouncing SQL Server yesterday afternoon the tempdb log file hasn't been larger than...

I haven't tried shrinking this tempdb log file using dbcc shrinkfile and I don't want to do it at the moment since it's a production box. I've used it before on user db's but I've read that it shouldn't be used on the tempdb log file unless the server is in single user mode because it can cause...

That's SQL Server 2000 SP3... The OS are different though...the 1st box was Windows 2000 Server and the OS of the 2nd box is Windows 2003 Server.

Both boxes have version 8.00.760, which I believe is SP3?

I wanted the space used throughout the execution of the View on the OLD box and the spaced used grew linearally from approx. 20-MB to 800-MB and then about 75% through the execution the space used dropped to approx. 500-MB. Why isn't it dropping on our new box? The Recovery Model for the...

We upgraded our primary production SQL Server box a few weeks ago from a 2-processor/1-GB RAM/4 year-old server to a 4-processor/2-GB RAM/brand new server. We've consolidated a few more small database onto this new box, but it added less than 5% more transactions and connections. Since the...

I'm looking into the using the Exchange Workflow Engine for simple routing applications and I'm not finding very much info. or samples on the internet. Can you direct me to some good resources? Is there a reason why this isn't used more?

I've modified the name of a parameter in a store procedure and am now trying to update the report. When selecting Verify Database, the new paramter name is used when the parameters are requested but after clicking OK I'm not receiving the accept changes window and when I then run the report the...

Thank you, that worked! I made a few attempts @ syntax similar to this, but missed this somehow. Thx again.