thank you Lowell!

Thank you very much!

Please disregard post I have found the solution.

Here is the link I used to resolve: http://stackoverflow.com/questions/11285923/tablix-repeat-header-rows-on-each-page-not-working-report-builder-3-0

thank you very much!

thank you, that was it!

Hi,

Thank you for you response. I get the following error message:

Msg 22049, Level 15, State 0, Line 0

Error executing extended stored procedure: Invalid Parameter

So it seems my syntax is...

Thanks guys! I have it working in SQL. However, when I try to run it in my .Net app, I get a message saying "Error: Must declare the...

Thank you! Here is my code:

Dim objConn, objRS, strQuery,strConnection

set objConn = Server.CreateObject("ADODB.Connection")

set objRS = Server.CreateObject("ADODB.RecordSet")

strConnection = "User ID=xx;Password=xxxxxxxxxx;"

strConnection = strConnection & "Driver={SQL Server};Server=DB_Server_NAME;Database=MY_DB;"

objConn.Open...

And thanks again, thank you both!

Hi, Is there a way to omit a letter from the list if there is no value?

Using the earlier example, if I do not have a fruit...

To all:

I figured it out, needed to use switch statement:

=SWITCH(

Parameters!getSource.Value = "emp" and Parameters!ContactType.Value = "ext" , "Phone List",

Parameters!getSource.Value = "emp" and Parameters!ContactType.Value = "cell" , "Cell...

Thank you!!!

Thank you everyone.

Hi,

I apologize for the confusion. Yes, ultimately I will be using SSRS (I am a newbie with SSRS) and users will be printing out phone lists. I would...

Hi Lowell,

Thank you for your reply. The data each have their own columns.

My current query is: SELECT EID, LName, FName, Phone FROM EmployeeContacts ORDER BY LName

How would I...