There's a solution to the gaps and islands problem in Itzik Ben-Gan's book on windowing functions, too. I know I've seen at least one article on the web. Make...

If you base the report on a stored procedure (with the parameters already declared), SSRS creates the corresponding report-level parameters for you.

Otherwise, you would have to create your own parameter...

Welcome to SSC.

Thanks for the sample data. In the future, if you could post it like this, you'll get a lot more responses, and more quickly because people don't...

Wendell,

I'm okay at VBA. I am pretty sure Allen Browne has some code to clone records inside a transaction. The only hard part is retrieving the value of the...

Looks like COALESCE is what you're looking for.

Would be easier to test with a little bit of sample data, though.

Sorry, I meant to add that part - you can't use COALESCE in SSRS directly. It's a T-SQL keyword and not available in SSRS, so you would have to...

be brave. Test it. On a DEV machine.

set statistics io on;

set statistics time on;

-- execute your query here

select *

from dbo.V_OnlineSalesOrder

WHERE IncomeGroup = 'Moderate';

set statistics io off;

set statistics time...

Sounds to me like you should do the whole thing in a stored procedure. If vacation hours is completely dependent on hours worked (so, a timesheet entry), then why...

"giving me errors" is just means it doesn't work. How about providing the error message?

It worked when I based the report on this T-SQL statement:

SELECT field1,

field2,

field3,

field4,

field5,

COALESCE(Field1 + CHAR(10) + CHAR(13),'') + COALESCE(Field2 + CHAR(10) + CHAR(13),'') + COALESCE(Field3 + CHAR(10) + CHAR(13),'') +...

Is there any way to convert this rows to columns.

Yep. PIVOT or use a report with a matrix

Not enough information. Please post your table definition(s).

How do you calculate health? (Or does it matter?)

I think you can create a stored procedure to join the two tables and flatten the data and then just group by...

use STUFF for the concatenated list and SUM with GROUP BY the result of the concatenation

If you want some robust logic, how about a robust explanation of how to get from your sample data to your result?