I've been a member of this forum for 17 years, mostly a lurker with very occasional posting or replying.  I am the baby Jeff at my company.  My scope isn't...

Actually no, no he cannot. I blocked him years ago...

You may have already found your solution, but here's how I have it configured in one of my reports.  I've obfuscated some names.  In my case, the report is under...

This might be a long shot, but see if this query gives you any insight.  If the subscription is complaining about the parameters, then it's possible it won't even get...

Old post... but wanted to add my screenshot with similar behavior.  Job has 2 steps.  Each were 1 second in duration, but Step 2 started 20 seconds after Step 1. ...

I can help you with the new window.  You just need _blank:

="javascript:void(window.open('http://east-rpdb01/reports/report/Testing/Profitability%20Report%20All%20Clients&FiscalYear=" & Fields!FiscalYear.Value & "','_blank'))"

Per this link:

https://learn.microsoft.com/en-us/sql/reporting-services/pass-a-report-parameter-within-a-url?view=sql-server-ver16

They show this format for multiple parameters:

https://myrshost/ReportServer?/AdventureWorks 2008R2/Employee_Sales_Summary_2008R2&ReportMonth=3&ReportYear=2008

But based on this error:...

• This reply was modified 2 years, 5 months ago by SoCal_DBD.

Hmmm... I'd say "new normal".  Our CEO thought we should come back 5 days a week in mid 2021.  Needless to say, didn't go over well.  We now have a...

• This reply was modified 2 years, 6 months ago by SoCal_DBD.

Yes, I like that Drew!  Thank you!

Argh!  Yes!  I knew I need to group (grp_cte) but couldn't figure it out for the life of me.

Thanks!

I do this kind of thing all the time using a crosstab.  There is a range of date differences so I put it into buckets.  This is merely a jumping...

I just had to do this for the first time myself and had a little trouble but got it working this morning.  Here's a high level:

I'm assuming you have a...

Thanks for following up with how you solved this!

Oh my goodness..... THANK YOU!  Or should I say... curse you! LOL

You should still share your solution!  Someone may encounter the same issue and would want to know how you solved it.  🙂

I almost hesitate to jump in at this point, but if I may.... I generally have an aversion to anything that's a triangular join.  Indexes aside, if I were to...