No-one has come up with a solution for this. Do I take it that it can't be done?

Is there any way of relating different totals together? For example, if...

There is also a closing bracket missing for each part, but it still doesn't make any difference. I get the same error message as before regarding the scope. In addition...

Thanks for the suggestion. However I get an error message with that method. I also tried just using the first part, i.e. "=Sum(IIF(Fields!Accountgroup = "Cost Of Goods Sold" , per_net_amount,...

Thank you Michael and Russel. They both work well.

Thanks for taking the time to help me out.

Mark.

Sorry, I was trying to keep the problem brief. Here is some sample data:

CREATE TABLE #GPSEvents

 (EventID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,

  EventDatetime DATETIME,

  MachineID INT,

  EventType...

The only way I have found to get the numbers to line up is to use an expression to alter the right padding on each textbox. This is done with...

Hi Kurtis,

Did you manage to solve your problem? You say the text boxes are formatted the same, but do you have a negative format specified? For example I use the...

Hi Mark. I'm no expert but this may be of some use. I would not try to do the sum function in your report; I would include what...

Thanks Lisa, that does help. I would have thought that if Reporting Services was listed in the help contents you would also be able to filter for that in index...

In Help About it is listed as Microsoft Development Environment 2003, version 7.1.3088. In the start menu it is listed as Microsoft Visual Studio .Net 2003.

We have not used...

Lisa, your setup sounds completely different. In Help About the installed products includes "Microsoft SQL Server Report Designer", which I assume is Reporting Services, because when you choose Help Contents...

Thanks Martin - I'll try that.

David, I did get one or maybe two error messages but can't tell you exactly what they were. However I did just cut and paste from the...

I have found (via a search on sqlservercental.com) the following article which shows how to create user defined functions and a stored procedure for commonly requested default dates:

http://www.developer.com/db/article.php/3513996

This seems...

Thanks for that Raj - I have made some progress.

I only want to go back one week, so I have changed your formula to the following:

=DateAdd(dateinterval.DayOfYear,-7,Today)

This does set the parameter...

My formula was based on one of William Pearson's articles in DatabaseJournal.com

I'm new to this game and didn't realise you could put "null" in there. I had tried leaving it...