Are the users in a Group in Active Directory?  Are the objects they need permissions to in the same schema by themselves?

Sue,
Thanks for the reply. I figured I had nothing to lose, so I installed the Data Mining Add-In... Now to figure out how to set up SSAS Multi-Dimensional... =(

How long does it take to run the report if you run it directly?
Did you look at the stored procedure that the report is based on? (it is based...

Why not make things easy for everyone and tell us all what your expected output is given the data you have already provided?

Use OR/IN in the your WHERE clause.

SELECT itemno,item code,closedate
FROM item a INNER JOIN itemcode bFROM item a INNER JOIN itemcode b

July 24, 2017 at 8:42 pm

#1952487

There's even an example XLS file...
http://www.daxpatterns.com/budget-patterns/

If you want Q1 to ignore the previous quarter (Q4 of previous year), you could do something simple like

IF(Calendar[Quarter]="Q1",BLANK(),...

How about the CREATE TABLE and INSERT scripts?

https://stackoverflow.com/questions/8435963/how-to-find-a-string-inside-a-entire-database

You're looking for strings in any column in any table? Sounds like the design of your database is seriously dodgy.

Thanks for the data sample... however, that's not super helpful. (Imagine copying and pasting that into SSMS and trying to run it.)  Here's how to do it:

[code...

You really need to open up SSMS and try learning something.

How about the painfully obvious:

SELECT *
FROM #Dummy
WHERE RandomString LIKE '%Mr. %'
OR RandomString LIKE...

Go crazy. Post your code in here...

PROCEDURE [dbo].[USP_AUTO_MOVE_TBMESSAGEREDUCE_DONE_AND_REJECT_TO_SENT]
    @TopRecord INT = 50000
    , @ManagementID TINYINT
    , @ResText VARCHAR(MAX) OUTPUT
AS
DECLARE
    @NEWLINE CHAR(1)
    ,@SubLoop_Rows...

Why are the month numbers in quotes? They're numbers, not text.

You would need to update those, removing the proper number of characters (Use LEFT() and LEN() in an update query... Since you only have a few cases, you could write...

Lowell posted some code that output a dataset as an HTML table not too long ago. Look around for it.