Removed: my assumption was incorrect! Talking **** again 😀

I had assumed that formatting a field would affect any arithmetic done on that field as a result of the formatting....

Good, which solution did you use? Just for the benfit of others.

:w00t: Agghhh a while loop. I'll be back with an alternative solution, unless someone beats me to it (highly likely).

In the meantime read Jeffs tally table article for a clue....

Or you could add the values by referencing the original columns from the report dataset, or do the calculation in your query or stored proc. Either of which is probably...

What are the values in the individual fields?

It looks like it's concatenating three string values of "1.00", "1.00" and "1.00"

You may need to convert to a numeric type before...

Yeah, like what everyone else says - the question is misleading and both answers are actually right in different time zones. Can I have my points now please 😉

Here's a big clue:

SELECT DATEADD(minute,(N-1)*@deltaMins,DATEADD(hh,@startHour,0))

FROM Tally

I've intentionally omitted a where clause as an exercise for the OP.

See the link in my sig for Jeff's tally table article.

Yes, you can use grouping, and do a page break after each group.

You'll need an additional grouping column in your dataset which you can produce something like this:

select groupnumber =...

RandMan-585256 (10/8/2009)

---

I don't think that you are being too harsh. 🙂

Some people want to learn how to do things themselves and just need to be pointed in the right direction....

What about this?

Please click here for help.

I might add this to the links in my sig just for these sort of occassions. 🙂

Don't think I was too harsh do you? I know he's only a newbie but there is a limit!!

Obviously homework or something,as Jeff alluded to earlier. His question clearly shows...

Click here

Like this perhaps?: http://john-sheehan.com/blog/wp-content/uploads/msnet-formatting-strings.pdf

Sam,

Since you're already using SQL Server and you have Crystal experience I'd suggest you give Reporting Services a go since it comes for free with SQL.

Try starting here, and...

So, what do you have experience in? C#, VB, ASP, ASP.NET, Reporting Services?

You'll need to write some server side code whatever.

There are many possible ways to do this but it...