I think I have it...

does this look right?

The next trick is going to be figuring out how to save this so it's compatible with SSRS 2008, since I did...

I'm working on it... it's giving me fits getting it exactly right... (Seems it should be easy, but maybe it's not as easy as it looks...) more when I think...

a hyperlink goes nowhere unless you tell it an address (or in this case some records to jump to).

What does the signature of your stored procedure look like? (what parameters does it expect and what types are they?) What are you doing with the parameters so...

If you're trying to go to a specific order number, then yes.

you have to add a parameter to the report you're opening (a hidden one is fine). And then in the calling report, you have to specify that parameter to...

Is this a one time thing? Does the destination database and the tables already exist in the destination? SSIS could do it. Not enough details to know...

"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...