The only thing I can think of is that you have another object named "Report1" in the database. Otherwise it should work.

One way might be to read the names of all the files in the directory into a variable one at a time, then parse off the date into a date...

Not sure I understand. Do you mean you don't want the chart to print, but still be visible on the screen?

Looks like this article should give you at least...

Post what you tried.

And while you're at it , could you explain how the logic works to generate what you're describing? I have no clue how you got from your...

You can probably do that following the examples in Jeff Moden's article. http://www.sqlservercentral.com/articles/T-SQL/63681/

I would be nice and work on it, but it's almost 2 AM here... start there and if...

Do you have any control over the underlying database? The fact that you have a bunch of data coming from different tables makes me wonder if if they underlying...

Thanks for posting the data, but if you could post it in consumable format, then people could help you a lot easier - and you would get tested solutions. ...

Super cool!! That should fix it. Definitely a solution I will have to keep in my bag of tricks.

Thanks!

Pieter

Seriously?

SELECT Column1, Column2, Column3

FROM Table1

WHERE Column1<12 -- another random filter

UNION ALL

SELECT Column4, Column6,Column2

FROM Table2

WHERE Column3 != 2 -- random filter

the columns have to be union-compatible, and there must be...

First off, I don't think having PivotTables in Excel and having reports in SSRS are mutually exclusive. That said, there are a ton of tutorials on YouTube that cover...

The only rule is this:

1. Symptom names are always in uppercase.

The next column is usually Causality[n]

3. The column after that is Relatedness[n].

So a table could look like this:

CREATE TABLE BadTox...

I could be wrong, but if you want all possible combinations of ProductID and each date/time value from the existing query (well, what others have helped build), you would create...

If you are allowed to write your own stored procedures for reporting, I would do it there. You could pass a value for the units to the DATEDIFF function,...

--Excel 2007-2010

SELECT * --INTO #productlist

FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

'Excel 12.0 Xml;HDR=YES;Database=C:\temp\Products.xlsx',

'SELECT * FROM [ProductList$]');

But that way, the teacher will know he was cheating, because he won't be able to explain how it works.