I don't believe so as I believe it only use's the 2003 rendering engine. Have you tried renaming the .xls output to the .xlsx?

Let me know if you...

I wasn't aware of a limit on the textbox, is it being outputted (as there is a limit in excel cells) into excel or being cut off when being rendered...

Use the "Row_Number()" function in your SQL Proc or query as a new field as shown here:

SELECT

ROW_NUMBER() OVER (ORDER BY [datActualDate] ASC) AS ROWID,

[datActualDate]

FROM

[Schema].[TableName]

Yes there is, when creating the dataset there is a timeout option which by default is 30 secs, change to 0 for unlimited...

Not a problem at all... Just wait till you start playing with visibility and page numbers, outputting etc using sub reports.... All i have to say is migrane!!!

Not that i know of, however be aware of how this would look in Excel (which wouldn't fit) or PDF, or even the time it would take to run the...

The excel output use's the default cell height which is 12.75. So the first line would be displayed but the second, third etc would be hidden. Have you tried exporting...

Looks like you would be best doing this in SQL first, before it gets into your dataset in the report.

You need to set its control visibility. I have attached a screenshot as an example, hope this helps...

We had the same problem, so we created the following function to properly convert the parameters...

******************************************************************************

******************************************************************************

USE [InsertDatabaseName]

GO

/*** BEGIN CREATE FUNCTION [Insert Schema Name].[funcParseInputStringToTable] ***/

CREATE FUNCTION [Insert Schema Name].[funcParseInputStringToTable]

(@InputString...

The settings you applied dictate the page sizing, it doesn't force your tables and graphs into those sizings... So if you have the A4 settings in the layout properties, you...

Unfortunately that error message is a little vague however take the following steps...

1. Run the report (that is used in the sub report) in Visual Studio ensuring it works...

2. Build...

I believe this can be done with XML StyleSheeting, but otherwise I don't think it can be done... Let me know if you do find anything that works!

You need to use the FORMAT command in the expression builder so example is "=FORMAT(YourfieldName, "MMM yyyy").

Hi, I am using NVARCAHR 255 in my destination tables, I have tried sting, byte stream and T Weaterun (unicode)