Would it work to change your select for that field to something like LEFT(Field, 255)?

You should be able to easily do this with a nested IIF expression in the color property of the field in question.

Here is the query with some formatting:
SELECT
    firstprintcardfooter.footernotes,
    firstprintcardfooter.printflag,
    dbo.vmainmembers.transactionno,
    dbo.vmainmembers.paymentdate,
    dbo.members.membercode,
    dbo.members.specialcode,
    dbo.members.NAME,
    Cast(Cast(LEFT(dbo.members.specialcode, Charindex('/', dbo.members.specialcode + '/') - 1) AS NVARCHAR) AS INT) ...

The select in your CASE is just selecting @valicolName as text. As a result, SELECT DISTINCT @valiColName as

FROM DIM_Product 
is functionally the same...

I don't know if this will solve your particular problem, but in the past I've had some luck with aligning objects by placing them in Rectangles.

WHERE Val IS NOT NULL gives you your expected results.  However, in your example, 1003 doesn't look like a NULL value - it is just the word "Null."  The query...

AFAIK this is nature of the beast with MHTML output.  All the MHTML subscriptions I have arrive with resized and smooshed columns, and it's just something I have to tell...

For question 2, there shouldn't be any problem keeping two versions of Visual Studio.  I have both 2005 and 2008 on my workstation (yeah, I know, we're supposed to be...

You're treating everything as INT, but there must be a VARCHAR field in there somewhere.  Here are the fields you are treating as INT - are they all in fact...

When you successfully export other reports to Excel, are they in .xls or .xlsx format?  Excel.xls files have a 65,000 row limit, and for many years that was SSRS's export...

The IIF statement doesn't look like it follows the conditions, but it's hard to be sure.  You have an OR in your conditions that could parse a couple of different...

This is a VERY clunky way of doing it, but in the past I've put something like this at the begin of my query:
IF @paramA IS NOT...

Have you tried passing the dates in 2017-09-30 format instead of 9/30/2017?  Depending on the language settings, SQL or SSRS could be interpreting the dates as DD/MM/YYYY..

It returns three rows because they all match your WHERE clause.  The question is by what logic do you expect to only get your single result?  Do you only want...