Viewing 15 posts - 1 through 15 (of 21 total)
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...
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...
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.
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...
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...
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...
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...
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...
February 16, 2023 at 8:45 pm
Which equation are you currently using for that column (looks to be the same as variance)?
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))
+...
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.
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...
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...
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...
October 20, 2022 at 12:11 am
Two thoughts...
...
September 14, 2022 at 1:08 pm
Viewing 15 posts - 1 through 15 (of 21 total)