I'm back again. So my second SSRS instance bombed on me also. It must be a permissions issue because when I went back into SSRS Config Manager and added the...

Everyone, thanks for your input. I tried the IIS solution, but unfortunately, that did not work for me. However, I did get it working and here's what I did.

Here's a bit of a backstory of what's going on.
We have AppX that uses Databasics (SQL) database and an Access database in the background.
Databasics decided to upgrade DB1...

Thanks all! Yeah, so all this is happening is in Access with Access tables.

I seen the After Insert event, but couldnt make sense of the steps after I...

TheSQLGuru (1/5/2017)

---

DarthBurrito (1/5/2017)

---

I have the task to convert our company reports from query embedded reports to stored procedures.

Some of the reports require multi-select parameters. I'm currently using a function to...

Luis Cazares (7/12/2016)

---

There's a problem with your sequential number generator. It's explained in here: http://www.sqlservercentral.com/articles/T-SQL/74118/

Here are 2 alternatives. One is using NOT IN as in your original query, the other...

This worked perfectly. Thanks!

Since I already have the start serial number and end serial number on the same one record, which is SN=1 and END_SN =5, I want to create the four other...

Thanks, I'll look into that.

For now as a work around,...

If I understand your question, I believe I've done this before.

I created one parameter that searches several columns.

All you have to do is use a lot of OR in your...

I finally figured it out and it was such a simple solution. Here's the expression I used.

In the detail cell:

=IIF(ISNOTHING(SUM(Count(Fields!RevCategory.Value))), 0, SUM(Count(Fields!RevCategory.Value)))

In the Fill section of the detail cell:

=IIF(ReportItems!RevCategory.Value =...

robert.gerald.taylor (10/8/2014)

---

Probably a silly question, but if the Add-On Column is always green, why not just set the back color to green.

Or are you saying that your grouping's expression is...

Just from the top of my head and without making an actual report, I'm thinking you should create a parent group and group it by fiscal year, yyyy-mm. Then you...

I'm using this for a parameter drop down list for a report I'm creating. Instead of having the user select a Month and then a Year in two parameters, I...

Rick, did consider the data-driven subscription, but we have Standard installed, so doesn't look like that will be an option. The version of SQL was not my call. This was...