Viewing 15 posts - 1 through 15 (of 23 total)
My assumption is no, but I'll ask anyway... Will this migrate data driven subscriptions? Also, does this migrate the report server execution log (containing historical run information)? Regardless, this may...
"When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me
October 13, 2025 at 12:25 pm
I'm inclined to think that is going to fail as well. Each multi-value parameter is going to be stored as an array, and I don't believe you can simply concatenate...
"When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me
September 8, 2023 at 3:34 pm
I'm inclined to think that is going to fail as well. Each multi-value parameter is going to be stored as an array, and I don't believe you can simply concatenate...
"When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me
September 8, 2023 at 3:34 pm
Can you create a hidden parameter in the report(s) to store the user id?
...reporturl?UserIDParameter=UserID1234
Then you could query it from the parameters column in ExecutionLog.
"When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me
June 27, 2023 at 4:21 pm
Instead of querying the ExecutionLog views, take a look at the table ExecutionLogStorage. There is a column there for UserName. Strangely it does not include the UserID, so if you...
"When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me
June 27, 2023 at 1:04 pm
(It's been a while since 2008 R2 and I don't recall everything that has changed. I know my recommendations work on 2016.)
I think you have two options...
"When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me
February 23, 2023 at 3:30 pm
I'm less familiar MySQL, and I also don't use the query builder (so maybe I shouldn't be trying to answer your question!) Anyway, I am looking at this from a...
"When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me
February 20, 2023 at 4:36 pm
I'm wondering if this is a problem with the parameter options refreshing. If you know it isn't, please disregard. However, if you want to humor me - would you mind...
"When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me
February 17, 2023 at 5:02 pm
Is it possible that your 30 second time was based on a cached execution plan on the database server or cached rdl data in SSDT? Depending on whether you changed...
"When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me
February 16, 2023 at 8:45 pm
Which equation are you currently using for that column (looks to be the same as variance)?
"When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me
February 14, 2023 at 6:10 pm
Maybe flip SUM and IIF? It looks like it is trying to sum up things that can't be summed (Sum(Fields!strCategory.Value="Payrole" etc.):
Maybe this?
=IIF(Parameters!IncludePTO.Value=1
,SUM(IIF(Fields!strCategory.Value="Payrole", CInt(Fields!mnyMTDActual.Value),CInt(0)))
+ SUM(IIF(Fields!strCategory.Value="OT",Cint(Fields!mnyMTDActual.Value),CInt(0)))
+ SUM(IIf(Fields!strCategory.Value="PTO",CInt(Fields!mnyMTDActual.Value),CInt(0)))
,SUM(IIF(Fields!strCategory.Value="Payrole", CInt(Fields!mnyMTDActual.Value),CInt(0)))
+ SUM(IIF(Fields!strCategory.Value="OT",Cint(Fields!mnyMTDActual.Value),CInt(0)))
)
...or this?
=sum(
IIF(Parameters!IncludePTO.Value=1
,IIF(Fields!strCategory.Value="Payrole", CInt(Fields!mnyMTDActual.Value),CInt(0))
+ IIF(Fields!strCategory.Value="OT",Cint(Fields!mnyMTDActual.Value),CInt(0))
+...
"When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me
February 14, 2023 at 5:26 pm
I just looked briefly, so maybe I am off but it looks like your "IIF(Sum(Fields!strCategory.Value="Payrole..." expression is missing a lot of closing parentheses? 11 by my count.
"When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me
February 14, 2023 at 3:42 pm
As mentioned by SSC Guru, the term you want to search for is: ssrs cascading parameters
There are any number of tutorials and examples out there. Here's one: https://www.mssqltips.com/sqlservertip/3466/cascaded-parameters-in-sql-server-reporting-services/
If you're having any...
"When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me
February 3, 2023 at 5:19 am
My $0.02. I'm not familiar with either (SSRS Config manager nor MS Graph API), so maybe this is already what you are doing with the former and this isn't helpful...
We...
"When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me
January 19, 2023 at 3:20 pm
You might try changing your IF to IIF? If I remember correctly Excel formulas use "IF" while SSRS expressions use VB's "IIF" (You could also use the Switch function to...
"When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me
October 20, 2022 at 12:11 am
Viewing 15 posts - 1 through 15 (of 23 total)