FKBEYS - I think you are thinking about the calculation wrong or I may be looking at it wrong.  If I understand right, your table contains the columns "Price", "Discount1","Discount2","Discount3",...

I like the idea of moving SSRS to the web server.  I will run that past our IT team.

PolyServe was a fun tool when configured correctly for sure.  We ran...

Thanks for the tips!

We currently have a single SSRS instance, but were toying around with the idea of a second to handle a subdivision of the company.  One instance per...

Are you getting the same error?  If so, my next thought is a trigger on the table is doing something silly.

But, just to address potential other pain points, how large...

Hello Steve,

Thanks for the reply.  I was not aware of the 25 instance limit; that is a good thing to know!

That is a good future state for sure, but current...

What have you tried so far?

I can think of a few ways to do this.  A LEFT JOIN onto table #location where the values match is the approach I'd take. ...

Thanks Thom!  I didn't actually look into the permissions on this, was just going based on our setup.  We have 3 DBA's all of who are sysadmins so just went...

My first step would be to compare datatypes on a lot of that.  For example, what is the datatype of TBL.City and N.City and N.CompanyID (guessing that is N.CompanyID and...

One way to do this would be to have a stored procedure with EXECUTE AS in it.  This way, you can set the stored procedure to run as sysadmin then...

you say that the system needs to be pluggable into "any SQL database" then talk about using reading from the data page and the transaction log files.  Not sure I...

heh... now you have me second guessing myself on that atom file thing... Been forever since I used that as I found it to be unreliable and annoying to work...

As far as I know, if a row has no guaranteed way to be unique, SQL adds a hidden column onto the end to make it unique.  Since you didn't...

Disadvantage to exporting to Excel from the SSRS site is that you get a static output of the report.  Nice thing of Power Pivot is you can click a button...

I forgot about one - power pivot inside Excel.  Using that you can pull the data from the SSRS server into Excel.  Still technically uses the SSRS web stuff and...

If you are running Windows 10 and have it stored in your profile, that could be your problem.  I've had files (not specifically dtsx files, but pictures) just disappear on...