Hello - Let's say in reporting services 2005 I have a table (reporting services table populated from a dataset) which has column headings like:
State | FirstName | LastName | Address
and the table in the report is currently showing row data such as:
Hawaii | Joe | Someone | 123 volcano rd.
Hawaii | Jack | Blades | 54 peach street
Texas | John | Smith | 123 street
Texas | Bill | Jones| 456 street
Texas | Sally | Struthers | 1345 street
could someone please give detailed steps on how i would do the following with the data?
end up with 1 row for Hawaii and one row for Texas that toggle, when i click the "+" next to hawaii, it expands to show the user info data for hawaii, and the same thing for texas, etc...
i know it has to do with visibility/toggle and grouping, but apparently i'm not putting things together exactly right