Create a variable called FileName (or whatever you would like to call it) and set evaluate to expression as true.

Then you can define your dynamic filename in the expression, for...

Have a look here:

http://www.sql-tutorial.net/SQL-JOIN.asp

for joins and here:

http://msdn.microsoft.com/en-us/library/ms187751.aspx

for the MAX() function.

Both will help you to complete what I'm assuming is your homework.

Ok. The problem isn't with your Report Manager setup - that's what the first question was about. So it must be the report, unless I'm missing something big.

Post the .rdl...

Have you tried other reports? Do they behave in the same way?

If you could attach the .rdl (obviously edit it for business anonymity) then I'll take a look at that.

Which is what would happen if you had the visibility set via some kind of data input....

Did you check into any of the other things I suggested?

And the PDF export?

The only reason I ask is that if there is a problem with the Report Viewer settings then you would see the chart when you export it....

When you run the report and it is blank, if you export to excel or pdf does the report then appear in that format?

If you have all of the data for exchange rates per currency then it should be a matter of using MDX to create calculations from your base currency to get...

You're very welcome, I'm happy to help 🙂

Would you mind posting exactly how you fixed it (what settings you changed etc.)? This may help others with a similar problem.

Without knowing your specific environment (OS / Memory / Storage etc.) it's difficult to determine what you should look at.

There are general memory setting in AS which could be having...

A fairly simple solution could be written to do this involving SUBSTRING and CHARINDEX but that is provided the data will always be in the format of "firstname[space]middlename[space]lastname".

for example if...

robin 86662 (6/15/2011)

---

yayomayn, Your t-sql statement was very close. Could you please tweak it so there is a decimal between Seconds and Milliseconds instead of a colon? Your...

This is fairly convoluted and there may be a simpler way, but it will get you the result you are after:

CASE WHEN LEFT(CONVERT(CHAR,GETDATE(),101),2)<10 THEN

STUFF(RTRIM(CONVERT(CHAR, GETDATE(), 101)),1,1,'')

ELSE

RTRIM(CONVERT(CHAR, GETDATE(), 101))

END

+' '+STUFF(RIGHT(CONVERT(CHAR, GETDATE(),...

Ah I see. In which case I would put a data grid viewer before your UPDATE command and verify what exact data is going in. Take a few of these...

Hi Robin,

What is the exact error that you are seeing?

Just a shot in the dark, are the timestamps on each of your databases geographically different? This would explain why you...