The problem with presenting data is that inevitably the presentation of the data comes into play 🙂

True.

I tend to err on the side of more customizable presentation.

First step would be to build the report and deploy it.

Verify that you can run it manually on the report server.

After that, you'll be ready to go in and create...

I would toss that query into a simple SSRS report and then set up a subscription with email delivery and excel render type.

Should get you what you are wanting.

Do you have an SSRS instance available to you?

Could always set up a subscription.

Excellent!

Glad you got it up and running.

=iif(len(value) > x, "8pt","10pt")

Or am I misunderstanding your needs?

I've most often seen this technique used prior to doing manual data manipulation on the source table so you have an easily accessible copy of the original data.

Also, using it...

I'm not certain how that worked to begin with but I know 2008 changed how it handles certain nodes.

Also, I assume your RDL is redacted as it is missing some...

DECLARE @Y4 AS INT

SET @Y4 = 3

SELECT

CASE

WHEN @Y4 = 1 THEN '6.0'

WHEN @Y4 = 2 THEN '5.4'

WHEN @Y4 = 3 THEN '4.2'

WHEN @Y4 = 4 THEN '3.1'

WHEN @Y4...

Good times 🙂

Glad you were able to get it working.

Hey Michael.

Is it possible SSRS is intalled on x64 and MySQL is on x86?

If so, have you tried creating the DSN in using ODBC admin tool in System32 -and- SysWoW64?

I assume you are referring to the look of the report as your column limit?

You can have up to 256 columns in Excel 2000/2003 and 16384 in 2007.

Can you provide...

As far as I know, you can only do this if you are willing to use a drop down list of available dates, as opposed to the calendar control.

You could...

Might try something like:

DECLARE @query1 AS NVARCHAR(1000)

SET @query1= 'SELECT * FROM table1'

DECLARE @query2 AS NVARCHAR(1000)

SET @query2= 'SELECT * FROM table2'

SELECT @query1

EXEC sp_executesql @query1

SELECT @query2

EXEC sp_executesql @query2