Thanks. That's what I thought, but wanted to make sure I wasn't missing something.

If you're brand new to SSRS, Brian Larson's book is pretty good. Wordy, but he walks you through pretty much every step. His book covers 2008 (not R2, which...

Check out this article [/url].

It shows one of the reasons to have a Calendar table. It makes a job like the one you are attempting really easy.

The problem you...

Any chance you can post the create table scripts for the 3 tables? (Are these part of an external system? the table and field names are mind boggling!)

I guess you don't have to build stored procedures, but it makes things a lot easier.

Any chance you could post some dummy data, so we can see what...

The query you posted had me confused. Once I took a step backward and slapped up a totally fake dataset, this was a snap. I created a bar...

Yes, I admit a CROSS JOIN would kill performance, but I would definitely filter first and then create the smallest cross join possible.

Glad you got it sorted.

Without table definitions and maybe some sample data, it's hard to tell, but I would guess that if you created a Calendar table and outer joined that to the source...

If you did a cross join between your dates table and your Properties table, it would return all possible combinations of (Property, Date) and that would solve your problem.

...

In my case, I just used an existing Enroll counts report...

=(Fields!NewEnrolls.Value-Previous(Fields!NewEnrolls.Value))/Fields!NewEnrolls.Value

The fun thing about something like this is that if the NewEnrolls.Value = 0 then you get +/- Infinity... so...

Thanks! I told you it was stupid!

sturner-926343 (10/7/2014)

---

I have 2 tables. Based on the Table1 id which is a column in Table2, I would like the following

Table1

T1_Id

1

2

3

4

Table2

T2_IDT1_ID ...

... and I'm having a hard time understanding what you want.

Do you mean you're trying to find all the tables that do not contain a column with a given name?...

If I select 'Add ->New Item ->Report, it opens a blank report in design mode with no option to add a data source or data set.

Once you have done this,...

If you have access to the database, you can do this:

First, you need Jeff Moden's handy DelimitedSplit8K function, which is here[/url].

Then your query would look something like this:

SELECT col1, split.ItemNumber,...