Weird, its gotta be something silly.

Can you post a small sample of your dataset.

It seems fishy that the field your looking is named TranTypeID.Value, but your comparing it to Text...

I think this will help.

Try wrapping the sum outside the iif

=SUM(iif(Fields!TrantypeID.Value = "INT",Fields!DrAmt,0))

Looking at your dataset, what values are in the tranTypeID?

Is there actually a value called 'INT'?

I think there's an error in your expression. Are you missing the .Value? (Bolded below)

=iif(Fields!TrantypeID.Value = "INT",SUM(Fields!DrAmt.Value),0)

For future reference, Please read this:

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

For the event types you need to put the booking ID in the output.

And you MUST use an order by to get the xml to...

Something to try. I've never found median to be a very meaningful number. Anyhoo. :hehe:

http://techfilth.blogspot.com/2008/07/calculate-median-on-group-in-ssrs.html

Microsoft info regarding browsers.

http://msdn.microsoft.com/en-us/library/ms156511(v=sql.105).aspx

darkhelmutis (5/2/2013)

---

I agree, 700,000 rows in not feasible, thus why I am looking for options. Sadly SSRS 2005 is pretty limited in that regard.

The Transaction ID is one of...

My .02c

From a user perspective, who wants to scroll thru 700,000 id's?

especially because the ssrs drop down does not allow type ahead, and the list is small

From a technical perspective,...

For a simple trend, wouldn't you just figure out Growth by month for the last n... months. Then make a monthly average.

So if it grows 1 gb/Month. Then take Current...

When you are comparing DATETIME Dates = the date AND time must be equal.

If your data Type is DATE then TIME is eliminated, however GETDATE() will return DATE AND TIME....

Sorry I'm confused.

My thought would be your main report would not list Courses, It would just list Teachers that teach the subject you searched for.

And the Subreport should simply return...

Yeah,

Your subreport would just return all courses Taught by TeacherID.

And your main report would return all teachers based off your search.

What does your dataset look like?

If it returns each Multiple times with different dates. Then Use a table.

Create a group on Date, and put the person in the detail rows.

You can't change an outer dataset from a subreport.

You can change your main reports dataset to return teachers that teach the Subject your looking for.

Then the subreport that lists courses...