Thanks Perry!

Just used that URL for a post!

Awesome!  Thank you guys!  This is perfect!

There's no data in the db yet, I was just trying to replicate from another db in the quickest manner possible.

I have my script for the tables and sproc creation,...

Perry,

Do you know where to report a bug about SRS?

I tried to look around here:

http://www.microsoft.com/sql/technologies/reporting/default.mspx

...but no luck finding anything.

Thanks for the interest!

Hi Jim!

What's you query look like?

We've been using SRS for about six months now, and have around 100 adhoc reports.

What I do is something like this:

1.  Set up the SQL...

finally I figured it out by the following expression on the Visibility tab of my 2nd level group "ThreeItems" (table1_Group1 is my top level grouping, and "ThreeItems" is my second...

I've tried to work with the group's visibility expression of:

=IIF(ReportItems!txtPerson is "No Mgr" and rownumber("table1_Group1")

 > 1,true, False)

.....I'm trying to hide the group band if it's "No Mgr" in txtPerson and...

Got it by:

Set detail band Hidden = "True"

Use a textbox in group band for toggle

Got it:

check the allow "Blank Value" box for the parameter, then click "View Report" when the report is run!

Thanks!

My fault...I had the textbox "tag" in the page header and not in the list object itself.

It works!

Thanks!

This is what I've tried so far, but it resets on every page.

So, each page is 1 even if the Unique ID spans 2-3 pages.

I only need it to reset...

David,

Can you send me an example?

I tried yesterday to play with fields from the dataset, but I guess MSRS doesn't allow data fields in the report footers.

Thanks!

Yeah...good point.  Less data / page, but more pages.

I just changed the list object to page break on the grouping (so basically the change of the Unique ID will go to another/new page), and now the report is...