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.

The only way for SSRS to know is if you specify a dataset for the parameter to get its values from. If you right-click on your parameter, and go...

However, the Value field in the dropdown list (CityID in your example) isn't making the connection to the main dataset query where clause (even though the spelling is the same)....