Manually type the relative report path on the server into the textbox, for example if you were calling /Sales/SalesReport from /Human Resources/Staff you would enter "../Sales/SalesReport" into the box.

This is...

Do the 100 files contain SQL scripts to create the stored procedures? If so, is the purpose of the output being saved to a folder to tell if the stored...

It looks like you don't have enough information to solve the problem. There way too many things that could be.

I expect it's likely a problem with Excel on their computer, rather than SSRS. Without knowing what error message your client is getting when they attempt to open the Excel...

What do you mean by they're facing an issue? Is there an error that appears when they try to export, or is the issue related to page breaks? A screenshot...

I would do something like below, but you will need to specify all fields listed in your SELECT statement except LID as part of a GROUP BY clause. Your SELECT...

Yeah - I felt pretty embarrassed when I saw Scott's reply and realized I'd missed part of the question. Good to see you've found a solution.

You should be able to directly add the DATEPART condition to your IF statement, as below.

CREATE PROCEDURE MyProcedure

AS

BEGIN

IF OBJECT_ID('tempdb..#tmpClosedPOs') IS NOT NULL AND DATEPART(MINUTE,GetDate()) <= 5

...

To set the default value for a parameter, in the properties window for a parameter, switch to the "Default Values" tab, select "Specify values", click "Add", click the "fx" button,...

SSRS has a DateInterval.Quarterly field which could make for more readable code:

= DATEADD(

DateInterval.Day

, -1

, DATEADD(

DateInterval.Quarter

, DATEPART(DateInterval.Quarter, DateTime.Now )

, DATESERIAL(YEAR(Now), 1, 1)

)

)

You could also replace DateInterval.Quarter to DateInterval.Month to get month...

If I were to do this query, and I understand it correctly, I would do it like this:

SET NOCOUNT ON;

if exists(

select *

from...

You've got two table row end tags in your header row, remove the </tr> from <th>Db_denydatareader</th></tr>

Are you able to post some screenshots of the errors you're receiving? It's a little difficult to tell what the issue is.

Great - glad you've got this working. I would have given more direct suggestions if I had access to a PC with SSRS installed earlier, so sorry about that :-).

In Reporting Services Configuration Manager, go to the Web Service URL tab, and click the hyperlink beside URLs: under Report Server Web Service URLs. This should bring up a page...