Search results for query: *

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.

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

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

I've used the COLLATE clause for an expression in the WHERE clause of a SELECT statement. For example, when comparing 2 tables that contain a unique id that's case sensitive: SELECT... FROM... WHERE sdo1.SDO_Unique_Id *= sdo2.SDO_Unique_Id COLLATE SQL_Latin1_General_CP1_CS_AS But how do I...

I know SQL 2000 Enterprise Edition is a requirement for Log Shipping. Is MS SQL 2000 Enterprise Edition a requirement for replication? Our SQL servers are Standard Edition. Is there an alternative solution to updating another copy of a database on a remote server on a daily basis (i.e...

We needed to rebuild our reporting server and since it's been rebuilt, everything is working properly, including the distribution of reports via email. But when reports fail, the notification emails are not being sent. I've double checked the recipient list and used the "Check Names&quot...

For disaster recovery and recovering from simple user errors, how do I backup and restore the APS scheduler configuration (Info Desktop directories, scheduled instances, ...)?

Is there a way to add a Group #1 to a report that already contains multiple Groups?

How do you repeat a header of a subreport that spans multiple pages? The header is in the Report Header section.

Is it possible to add additional columns to a cross-tab? I've got a cross-tab that contains Customers as the rows and Retail Weeks as the columns. Besides the volume sold per Cust per RW and Grand Totals, I'd like to add an RW Avg. Vol. column and one for the previous year. Thx in advance!

2 questions: How do you display a header onto multiple pages for a grouping in a subreport that spans multiple pages? How do you display a Page Header onto multiple pages for a single cross-tab of a master report (opposed to a subreport) that spans multiple pages? Thx in advance! Eoin