One report 2 data driven subscriptions

Daily subscription query

SELECT DATEADD(dd,DATEDIFF(dd,0,GetDate()),-1) AS StartDate

,DATEADD(dd,DATEDIFF(dd,0,GetDate()),-1) AS EndDate

Monthly subscription query

SELECT DATEADD(mm,-1,DATEDIFF(dd,0,GetDate())) AS StartDate

,DATEADD(dd,DATEDIFF(dd,0,GetDate()),-1) AS EndDate

Later in the subscription wizard you associate the StartDate value to...

In the report manager go to the Properties tab and click History. You can configure your snapshots there.

Try

=iif(ISNOTHING(Fields!total.Value),true,false)

I have only seen blank pages when the report pushes out the width beyond the page margins. Check to make sure that your report body width + left margin...

It's my opinion that doing calculations, when practical, in SQL is a better path. I have done plenty of calculations in SSRS though when it would be much harder...

Hmmm Thor's Day - Thursday. Coincidence?

And the URL link will bring them to the portal, I don't see the problem, this way is fewer clicks for the end user.

Yeah, this is a bit tedious. You also want a separate header for your detail data. What you need to do is add a row at your group...

The Longest Yard....not really a classic.

I guess I don't understand the issue of providing a link to the report. This just makes it easier for the user to get to the report on the...

In a report subscription you can "Include report" or "include link" or both. In your case I would just include the link.

I probably should have been more specific than "Data element." From what I understand you want to group on client.

If you have a report subscription, you can execute that subscription on demand using SQL. If you want, you can do the same thing using the Execute SQL Task...

I have only used VB for embedded code. I am not sure if it will take another language. Although if you really need another language (and if it...

I would use a list, and if you need repeating data put a tablix/table inside the list. Group the list and tablix on the same data element and you...