Makes total sense!

You certainly can have multiple datasets using the same stored procedure. I do it when I want to show MTD and YTD information on the same report - I call...

Oh, didn't think of that! I'm glad you figured it out...sometimes it's the simplest things that can trip you up.

Did you open the report through solution explorer (i.e. open the project/solution, then open the report).

I've seen this happen when I opened a .rdl file directly...I think it opened in...

Didn't think about the index implications - thanks Jeffrey for the better solution 😀

You can use the following to convert the date column to the date with a time of midnight:

SELECT DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0) AS DateOnly

(Replace GETDATE() with the name of...

I thought you had to do it through a view...I'm not sure if there's another way.

On your summary report, where you have (or want) the link to the detail report to be, right click that object and select Properties, then select the Navigation tab.

You'll see...

Data-driven subscriptions are in the enterprise edition only (not the standard edition)...hence the SSIS package Doug provided if you're not using enterprise.

Do you have a test system where you can adjust the data the query should return? I'd be curious to know if it's a specific record (or subset of records)...

I'm new at building reports, and I had the same dilemma.

After trying it both ways, I now go for stored procedures over SQL directly in datasets.

Several reasons I found for...

Thank-you both for your suggestions!

@CirquedeSQLeil - Unfortunately, I don't have access to update the source table, but otherwise that would be a really elegant solution.

@john-2 - I do...