Completly re-write it

SELECT

....

FROM

....

INNER JOIN --=

.....

ON ..... = .....

LEFT OUTER JOIN --*=

ON ..... = .....

RIGHT OUTER JOIN --=*

ON ..... = .....

WHERE

.....

As you have only provided half of the query, it is...

Not a problem, glad I could help

Create a host header record in DNS that points to the URL you want.

So report.domain.com is the URL, then DNS resolves that to http://computer/reports

You could cache the shared data set, that way when the subreport runs it runs against the cache instead of the database for each user.

Might not be feasible if the...

Generally the licence key is built into the media, the only thing you have to say its licensed or not is a piece of paper saying I have X amount...

But the command you are executing is ALTER INDEX,

So it will print out ALTER INDEX indexname ON tablename .....

So you can debug what you have told SQL to build...

From what I have read on the error your getting, it is because you are mixing the two types of join.

*= and =* are only included for backwards compatability with...

Instead of exec (@command), do print @command, then you can see where the failing object is.

Do you have the old style joins in the query or the object crv_productos

*= or =*

Expressions in SSRS are C based expressions not HTML expressions.

Instead of having the textbox display the URL, set the action on the text box to go to the url instead.

The...

Your account needs the correct rights in AD to be able to create SPN's, you could always ask your domain admins to assign the permissions to the service account so...

Jayanth_Kurup (1/15/2013)

---

select * from sys.sysaltfiles will tell you where the files are located , if your looking for a dedicatde disk drive volume lable then the first char ( C...

No worries, glad the issue is resolved.

Whats the SMTP authentication mode for the account in the DB Mail config screen?

Windows Auth

Basic Auth

Anony Auth

Timeout would indicate that there is a problem in the connection, can the server...

As detailed, create a file share on Server1, ensure that the nessesary permissions are set on the file share, then use a UNC path to access the server like the...