as mentioned the flat file destination is a definition of what the file will look like. It does not offer any runtime configuration.

To do as you mention then you need...

Well in your a DateKey dimenstion table you should have columns like below.

copied this from adventureworksdw

CREATE TABLE [dbo].[DimTime](

[TimeKey] [int] IDENTITY(1,1) NOT NULL,

[FullDateAlternateKey] [datetime] NULL,

[DayNumberOfWeek] [tinyint] NULL,

[EnglishDayNameOfWeek] [nvarchar](10) NULL,

[SpanishDayNameOfWeek] [nvarchar](10) NULL,

[FrenchDayNameOfWeek]...

I don't believe SSRS exposes anything like Tabs.

You can do 2 things.

Put your tablix and chart on the same page but separate by a page break (I would prefer this...

Your sample query

QUERY

Select Empid, Deptname From Employee E INNER JOIN Department D ON (E.Dept_id=D.Dept_id) Will this work??-----

Insted if i write

Select Empid, Deptname From AdventureWork .Employee E INNER JOIN...

Thats great, you posted sample data.

Can you please take a few minutes create a script that put the data in a Table or create a crude cte just so we...

If I understand it correctly if the subreport is returning more than you want.

Seems like you need to construct the sub report to accept a parameter to restrict the data....

I was thinking this could work

;WITH MySample AS (

SELECT 101 AS Record_id, 'A' AS Col1, 'A' AS Col2, 'B' AS Col3, 'A' AS Col4, 'A' AS Col5 UNION ALL

SELECT 102,...

Consider using a table of dates.

I'm not saying this is the best solution, I'm just showing you can do it without using a loop.

DECLARE @Dates TABLE (ID INT IDENTITY, Date...

Are you concatenating a string in one of your cells together? might be tough to find. but thats what my guess is.

Well Done Mr. Moden 😎

yeah, you need to fenagle with the path, I'll check it out reall quick.

Updated sql select

SELECT *

FROM OPENXML (@docHandle, N'/hearingData/employees/employee',2)

WITH (employeeID nvarchar(50) 'id'

,EmployeeLName nvarchar(50) 'name/last'

,EmployheareeFName nvarchar(50) 'name/first'

,EmployeeMName nvarchar(50) 'name/middle'

,EmployeeStatus nvarchar(10)...

I don't see a place where it will let you do this.

Other than removing the horizontal borders in this cell I don't think it can be done.

From what you posted you have @xmlDocument declared as nvarchar(1000) but your string is 2997 chars long, so its getting truncated.

after increasing the length. It runs. but returns no Rows

I don't think the IN is going to work the way your trying to use it.

Whats happening behind the scenes is SSIS Is converting your sql to Dynamic sql and...

If you think it would be so beneficial why don't you create one and post for all to see.

Why don't you try it, and if you get stuck somewhere let...