Have you given these users the URL for the folder which has the A report or just the URL of Home? If the former and it still gives a blank...

create a view in one database to refer to the table in the other, e.g.

select * from server.databasename.dbo.tablename

then write query for your report to join the two.

Yes, this occured to me later in the day and it does work. However I'm still one step away from getting this completely working. The single report parameter I'm specifying...

you could use sum(Fields!Quantity.value, "table1_group1") where table1_group1 groups all your orders for a given item.

Yes, now I think about it, the userid isn't going to be important anyway. Still, there's nowhere in any documentation I've seen that tells you about this hidden criterion for generating...

Found the answer on http://www.sqlreportingservices.net. If you use User!UserID in the report, you can't create a subscription for it. But what's the workaround?

Brilliant. Mind you I haven't worked with external assemblies as yet, but there has to be a first time I suppose!

Not having a development job per se(!), I can't pursue this in the short term, but it sounds like it might work. Anyone else out there want to give it...

That's a shame, but thanks for trying. I'm in the process of replacing an Ms Access-based report application which does loop through the relevant parameters on a front screen and prints the...

Thanks. That's certainly one way. But, ideally, I'd like to build a template I can use with any report. Hence the idea of looping through the defined parameters using some code....

try:

format(Globals!ExecutionTime,"dddd, MM/dd/yyyy")

Thanks - I just wish they'd document these things...

That works fine, thanks guys.

One thing you can easily change is the text on the top: 'Reporting Services'. This is held in the ConfigurationInfo table under SiteName. Inerested to hear about more extensive changes too.

you'd think this sort of thing would be documented somewhere obvious, but... anyway thanks.