Ok, I see. What values are listed in the OwnerId field of the subscriptions table?

Thanks

No problem.

Can't help Douglas with his problem though unfortunately.

Can't think of an appropriate iif expression to do it in Report Designer; no doubt there's a T-SQL solution but I wouldn't...

ChrisM@Work (7/30/2012)

---

The query you posted above doesn't generate more than one month. Where do the two extra months come...

If you add a dataset to the report that contains a select statement from the dbo.Image_Table, you can reference the field here in the 'Use this field' option.

Yes, it's using MS T-SQL specific functions. I'm not familiar with SQLite so not sure how to translate it into that dialect, sorry.

How's this? Not sure how it'll scale, but it runs pretty much instantly for me on a few thousand records.

From a design point of view, an extra column in the...

GilaMonster (7/30/2012)

---

That's...

You can also check the values from the performance counters:

select *

from sys.dm_os_performance_counters

where object_name = 'SQLServer:Databases'

and counter_name in ('Percent Log Used', 'Log File(s) Size (KB)')

No problem mate 🙂

Lynn Pettis (7/27/2012)

---

You owe the O...

Don't think you can do it directly.

You might be able to achieve it using custom code in the report definition, or a check in your SQL query that returns an...

Does this work for you?

use ReportServer

go

SELECT UserName, sub.*

FROM dbo.Subscriptions sub

inner join dbo.Users u on sub.OwnerID = u.UserID

jdbrown239 (7/26/2012)

---

Thanks. I found the way to name the worksheet tabs by setting the page break expression.

The problem now is is the column headers do not show on each...

I'd add text box(es) with the expression =Parameters!parmname.Value in.

Concatenate them together or use individual boxes, whichever's better for you.

Lol... Doesn't have to be a long look! :w00t: