You mentioned the following, "In Edge, you can experiment with different document compatibility models".  Can you tell...

The following pertains to what you mentioned above:
1. 'You could use WHERE EXISTS and correlated subqueries,. Would you show me an example of using the where exists? Would you...

How about what is wrong with what I just submitted? The splitter function works for everything else at my company. I would like to know why it does not work...

I like the idea of having a third report that lets you select 1 report or the other report. However how about if the user wants to select both reports...

So the only thing I can do is on each parameter is to say this parameter value is only used for the 'new' report as part of the parameter name...

I have a tablix at the bottom of the report that contains only two columns that displays the report parameters and this works. Thus are you saying that if I...

Depending upon the rdl the report comes from, the report takes 1 minute and 30 seconds to display. There is no stored procedure. The sql is embedded in the report....

Sorry wrong thread.

Would you show me how to use a switch statement?

Yes I did read his answer. However my IT manager does not want me to use that code.
Thus would you show me what you mean by 'table-valued parameter'?

Can you show me how to do both of your options? The table-valued parameter and/or use something like DelimitedSplit8K ?

Where can I access NGrams8K or DelimitedSplit8K in the sql server 2012 database?
I want to use either NGrams8K or DelimitedSplit8K as you suggested but I cannot find them in the...

Thanks for showing me the sql:

Here is the table with the canned 'comments' listed below:
CREATE TABLE [dbo].[GradingCommentTemplate](
 [commentID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
 [schoolID] [int] NULL,
 [comment]...

Yes there is a table where the canned statements are stored at. The problem is the unique identifier stored in the canned table are not passed along to the table...