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,...

If you right-click the Reports folder in Solution Explorer, and select Add>New Item> and then select Report (not Wizard), you should get a blank report that opens. At that...

Alan.B (10/2/2014)

---

pietlinden (10/1/2014)

---

Is there any alternative to building your own SSAS cubes to report against? I would have sworn that SSAS creates an object that can be reported on...

Guess I have to learn how to build a cube... oh well.

Oh, okay. So right now you have a shared data source. If you Right-Click on the Reports folder in the Solution Explorer, you can add a report (if...

Took me a minute to figure out what you did. If you've created a shared datasource, the Report can't see it yet. You have to create a datasource...

Since I'm trying to learn how to do all this better, I figured I would see if i could get it to work...

SELECT ContractNo

, Pkg

, GrpNo

, Subgroup

, split.ItemNumber

, Item =...

Oh... I thought you already had a report-level parameter... maybe that was part of my problem. Glad you got it sorted.