Try this:

https://www.mssqltips.com/sqlservertip/1674/retrieve-excel-schema-using-sql-integration-services-ssis/[/url]

martin.whitton (6/3/2016)

---

Anyone who doesn't terminate SQL statements with a semicolon should note the following (from https://msdn.microsoft.com/en-us/library/ms177563%28v=sql.110%29.aspx ):

Transact-SQL statement terminator.Although the semicolon is not required for most statements in this version...

It's a common misconception that the columns SELECTED in a subquery have to come from the tables in the subquery.

If you use table aliases and two part naming on all...

I think that's just the way it works.

A possible workarounds is to have the header include the padding you require and place the tablix right up against the header

You probably didn't use the namespace.

DECLARE @x TABLE (Payload VARCHAR(max));

INSERT @x (Payload)

VALUES ('<NCOAPACP xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="uri://www.gen.da.hob/VC/Contract/QualityManagement/EMSM">

<VID>3656183</VID>

</NCOAPACP>');

WITH XMLNAMESPACES (DEFAULT 'uri://www.gen.da.hob/VC/Contract/QualityManagement/EMSM')

SELECT nd.value ('./text()[1]','int') AS vid

FROM @x AS x...

How about a slightly different pattern?

Send the #results to the LinkedServer.

Run the Merge, OUTPUT the desired data

store the results locally

Something like this:(untested)

INSERT INTO [LinkedServer].tempdb.dbo.Results

SELECT

CoL1,

Col2,

Col3,

Col6,

FROM

#Results SRC;

INSERT @Inserts(ID,Col1,Col2)

EXEC('MERGE [Database].[Schema].[Table] AS TARG

USING

(

SELECT...

It's possibly to do with the Join on ACCOUNT, one table has account as a string, one as a FLOAT!

Here's an updated outer report with SSRS filtering for you as an example.

I suspect all...

So, are you saying that your Main report only has one item/table on it - the first one?

How are you using the parameter to filter? Are you passing it...

Charmer (5/24/2016)

---

Hi Magoo,

Thanks for the suggestion. I am not able to open the RDL you have attached in here.

I tried with 2008 and 2012 VS as well. May I know...

Yes, you can use a "List" control with a subreport.

Create a report with a "Country" parameter that filters your dataset.

Place a table with the columns from your dataset on the...

Have you thought about using subreports for the graphs?

SqlBarbarian (5/6/2016)

---

You know the fantastic SQL Sentry Plan Explorer Pro has an anonymizer feature that lets you share an execution plan with anonymized table/column names. I was thinking that perhaps...

True, but the reason I said save as a different name is because that also works in report builder.

Use whatever suits you best.

Open it in your report designer and save it with a different name.