Using A CTE and some aggregates,

Please test this throroughly, No guarantees implied.

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

DROP TABLE #mytable

--===== Create the test table with

CREATE TABLE #mytable

( ID INT...

Can you post additional information.

Other than trying to select the rows >= 7 Days What problem are you trying to solve here?

Please read this.

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

The requirement is very odd, and given...

Worth a look.

http://rsbuild.codeplex.com/%5B/url%5D

OR Possibly

http://msdn.microsoft.com/en-us/library/ms162839(v=sql.105).aspx

Are you trying to do the equivilent of like a sql Union, ie

Show rows from the table, and below show rows from excel?

If not, how would you do this in...

Leave the Date in the dataset as well as your Letter, and Group by The date, and use the Letter for your headers.

Same question different thread:

http://www.sqlservercentral.com/Forums/Topic947570-391-1.aspx

No need to cross post.

Follow here

http://www.sqlservercentral.com/Forums/Topic1375434-391-1.aspx

I am confused on what you call the data section. and row section.

sounds like you put the Expand and collapse on the actual detail row which will of course not...

What have you tried, and where are you getting stuck?

Please read this

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

Look up Case statement, and

group by Es

Or the Pivot Functions

Like this?

"Select "+(DT_STR, 20, 1252)@[User::BatchID] + " as BatchID, '" +@[User::BatchDateISO] + "' as BatchDateISO, 'FH' as RecordType, 'AS400' as SourceSystem, " +RIGHT("00" + (DT_STR, 10, 1252)@[User::BatchID],2) + @[User::BatchDateISO] +...

I'm not totally sure that this is the issue

However at the end of your proc I would modify it to this.

IF @XmlOutput IS NULL

SET @XmlOutput = '<Export/>'

SELECT @XmlOutput

I'm assuming your...

What does this mean?

I'm just guessing here.

You have 3 different reports.

And you want all 3 on the same page ie like a dashboard.

Create another report then place 1 subreport item...

Other than trying to explicity setting the lenght of the varchar.

convert(varchar(10), getdate(), 101) I'm guessing the proc is returning no data, when you leave this in there.

in the proc...

when you go in to the execute sql task editor, On the left on the Result set are you assigning the xml to a variable?

ResultName should = 0

and Variable name...

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...