Can you use this logic to unpivot that part? (so you get a column for each)

=IIF(Parameters!IncludePTO.Value=1,IIF(Sum(Fields!strCategory.Value="Payrole", CInt(Fields!mnyMTDActual.Value)

+

IIF(SUM(Fields!strCategory.Value="OT",Cint(Fields!mnyMTDActual.Value)

+

IIf(Sum(Fields!strCategory.Value="PTO",CInt(Fields!mnyMTDActual.Value)

,IIF(Sum(Fields!strCategory.Value="Payrole", CInt(Fields!mnyMTDActual.Value)

+

IIF(SUM(Fields!strCategory.Value="OT",Cint(Fields!mnyMTDActual.Value)

Use something like this in your report:

= IIF(Parameter!IncludePTO = "Yes", [Payroll] + [OT] + [PTO Sales], [Payroll] + [OT])

Or use a CASE statement in your T-SQL code to do it.

oh, right. That's the part I was going to try to avoid: SSIS.

Also, I wanted to maybe summarize them first, and then query... basically like if I were querying a...

• This reply was modified 2 years, 8 months ago by pietlinden.
• This reply was modified 2 years, 8 months ago by pietlinden.

So just follow the instructions for it in an article like this?

Create a Format File (SQL Server) - SQL Server | Microsoft Learn

oh god no don't use UNION ALL unless you really need to.

Why not just something like this to get all the records you need from each source?

INSERT INTO tempdb.TableName(col1, col2,...

This works except for the "Top 4" rule, but you can do that using CROSS APPLY.

use tempdb;
go

CREATE TABLE #Diags ([ChartProcedureId] UNIQUEIDENTIFIER, [DiagnosisCodes] VARCHAR(200))

INSERT INTO #Diags ([ChartProcedureId], [DiagnosisCodes])...

Congratulations on finding a relevant post that has the answer you need. Did you try it??

Something like this maybe?

use tempdb;
go

CREATE TABLE Reading ( readingDate date, quantity int);
GO
INSERT INTO Reading VALUES ('02/03/2023', 170),('02/02/2023', 90),
('02/01/0223', 160);

SELECT readingDate, 
quantity, 
prevQty = LAG(quantity) OVER (ORDER BY...

• This reply was modified 2 years, 9 months ago by pietlinden.

I would use LAG([Recordcount],1) OVER (PARTITION BY TableName ORDER BY SomeDate)

I would use LAG([Recordcount],1) OVER (PARTITION BY TableName ORDER BY SomeDate)

Cascading parameters...?

Make your life easier.  Create a stored procedure in the database (or send the query to whoever is allowed to do it) , and then create a dataset in SSRS...

Reassemble the (date, hour, minute, second) back into a proper date and then use DATEDIFF?

Failing that, you'd have to check if ExitHour < EntryHour, and then use (24 + ExitHour...

Sounds like you need to cross join the two tables (creates all possible combinations... be careful with these!), and then subtract out the matches.  (It would help us a LOT...

• This reply was modified 2 years, 9 months ago by pietlinden.
• This reply was modified 2 years, 9 months ago by pietlinden.

That's Oracle syntax. Are you connecting to a SQL Server database?