Are you unable to use the ROUND() function in SQL?

http://doc.ddart.net/mssql/sql70/ra-rz_20.htm

I may be just missing something really obvious, however it appears that your attachment already has those columns added. Perhaps if you could elaborate on what you are trying to...

I've run across something similar in the past, but I was very limited with what I could do. Hopefully you can write another dataset that would pull from both locations...

I found a post that seems similar:

http://www.experts-exchange.com/Database/Reporting_/Q_23992876.html

Summary: Cause the grouping to be done by a parameter of some sort or perhaps an IIF statement. Or perhaps even some custom code....

When everything is hidden(going on memory here) it seemed that it collapsed. Perhaps there is a rectangle, or some other item taking up the space that is not hidden?

I missed your reply Friday. I did some searching and I came across a post stating that the parameter will update only if it is based on a query. So...

Let me see if I am following so far:

You open the report and there are the selections for the parameters. @urgent is the only one dependent on another parameter. You...

Perhaps something to do with where the item is placed or an aggregate?

Try: http://www.eggheadcafe.com/conversation.aspx?messageid=31993456&threadid=31993452

It speaks specifically to a situation where the First() aggregate is being used, I realize that may...

I think I am following what you are looking for. Perhaps what you need is not something that turns on and off the headers but changes what appears there depending...

Not sure what you're are asking. I am sure it seems very straightforward to you. Can you explain a little more what you are looking to accomplish? I do know...

Not sure if this is what you are talking about, but it seemed like the same problem:

http://forums.asp.net/t/1411888.aspx

Also, it seemed the OP was unable to get it to work with reports...

Sounds like you are running into what I have hit in the past. I haven't yet been able to find a way to "refresh" the report without actually running it...

I have seen the same problem here where some Access "applications" were used as front ends for the MSSQL tables. There is a timeout field that you can set. Don't...

I had something similar a time or two not too long ago. What I ended up doing was getting the whole thing over into SSIS and executing each piece by...

I had thoughts about that too. The conclusion I came to was that it's not truly an archive table, as I know it. An archive table would be filled with...