For a similar task , rowcount task to see the records got processed daily. Plus unit test the package for 100 records and monitor the db file growth as the...

Someone may disagree,

but Don't think you can merge server1 Report server databases with server 3 rs dbs.

why not create another ReportServerDB and ReportServerTempDB on Server1 with different names and...

Don't think we need to restore ReportserverTempDB

=Join(Parameters!RodZacxxxx.Label, ",")

You may ran this query,

Just change the name of the table: [dbo].[VB8_DA] with yours.

or call it from SSRS

create Procedure dbo.VendorReport

(@VendorOrders varchar(10),

@LimitToTopParameter int,

@Flag int

)

As

Begin

--if @Flag=1...

I worked on a SSRS project which we converted it to web based from Windows based.

to filter a report based on the user logged in , we added a column...

Contracts on W2, or 1099 or Corp-to-Corp which is better really depend on your personality and the take home money difference worth it. you must do the numbers before you...

Steve , thanks for detailed response , that's true money should not be the driver here, but if you like what you are doing and good at it , no...

ABLITY, sure it is the factor , I agree 100%, Sometimes you have lets say 10skills you acquired through time , and a particular Client requires may be 2 or...

bitbucket-25253....wasted my time what a response

let me answer it myself.

Fully qualifying the stored procedure fixed the issue...

Its weird though

The set up was done inhouse, I created the models , it is not using cubes

I am thinking to create reports and schedule them to run at the same time!

the queries are relatively simple ,

but these are simantic queries that report builder creating behind

or do you know how to simulate and test this with 25 users

We are thinking to use available tool to help us to do the administration part

any tool you guys recommend?

Thanks

Let me explain more,

I have a folder called "A" and it has 50folders named "A1 to A50"

and each subfolders have 10 or more reports.

the requirement is , without deleting the...