Did you copy the 2nd script I posted? just checked the output on mine and it seems ok

Edit - Just ran that script and the output it generated and...

I have. It's the script above your last post unless I'm totally missing something

My answer was wrong anyway :blush:. It turns out the variables you are using were not declared (but you had attempted to declare them but in the wrong place)

Amended...

Should it not be

SELECT DB_NAME()

Never tried. I'll knock something up and give it a try 🙂

There is a AutoRefresh option on the report properties which you set the rate in seconds when rendered in HTML.

I have never tried it so can't comment if it does...

If your wanting to get into formats for different customers and logos it may be worth trying a HTML tag to an image on the web for the company logo...

What so you mean by preview?

That error rings a bell.

Try

Run the SP in SSMS. Any errors?

Strip the SP and run it outside of the SP.

Do all returned columns from SP have a proper...

As far as I know there is no way to do this in the report itself. However.

You can create a subscription for that report and set the delivery to...

Ok, so what part do you need the help with. As from what you say you have the SQL which will return the individual company and also the All...

So surely in that case all you need to do is add a check somewhere in your SQL to say "If I have selected all 18 companies" then "Display the...

There is a AutoRefresh option on the report properties which you set the rate in seconds when rendered in HTML.

I have never tried it so can't comment if it does...

Ok, so what happens if you only select say 3 or 4 companies?

Just to clarify.

You select one, the income statement for that selected company displays.

You select more than one. What happens on the report?