"but that didn't work because the selected DateGroup column needs to show even if there is no data for it."

If you outer join the DateGroup columns to the other data,...

Not entirely sure where your columns start and stop...

Could you provide a CREATE TABLE script and some INSERT scripts to populate your table?

Or something like this? It's just hard...

What kind of value are you trying to pass to the main report? A total of some kind?

could you post some sample data? Maybe a create table and insert scripts so we can see what you're doing? it looks like you can use a Matrix to...

You would have to open a parameterized report and pass that parameter value, right?

Are the queries already in SQL Server (as views or stored procedures), or are they completely ad hoc and being written by the people using Excel? One way might...

Funny, I would have thought the SSIS solution would be perfect. It even has the Excel destination that you could configure... Execute a stored procedure? Nothing doing. ...

I need a query to fill in the data for each Calendar_Month. This should look at the actindx column and Calendar_Month column if there is no data for a specific...

Very true... I was probably having flashbacks to "databases" created by people that didn't have a clue what they were doing... so a LOT of cleanup was required... in that...

One way would be to create a stored procedure to do the import/massage of data and then schedule that in a Job. Then if the Job executes on an...

This part looks iffy:

CDate(Fields!Month_Name.Value + " 01, "+Fields!Financial_Year.Value)

Why not use DateSerial(Year,Month,Day)?

Sounds like you could do this with a parameterized query (so a stored procedure) with a join between the two tables in question.

one way...

SELECT [Reason1] AS Reason, [Comments1] AS Comments

FROM [mytable]

UNION ALL

SELECT [Reason2], [Comments2]

FROM [mytable]

WHERE [Reason2] IS NOT NULL

UNION ALL

SELECT [Reason3], [Comments3]

FROM [mytable]

WHERE [Reason3] IS NOT NULL

then you won't have repeating...

One way to do it might be to store the T1 total in a variable, and then just divide by that variable in your T2 tablix.

normally, you would do this WITH ROLLUP in T-SQL.

http://technet.microsoft.com/en-us/library/ms189305(v=sql.90).aspx