very urgent ....problem showing one of the detail rows after group subtotals in a table report (ssrs 2005 )

hi all,

i have problem showing 1 of detail rows after group subtotas ...

i have dataset looks this:

here need group on left field(city names) in report .for each group each row appearing 'r' value calculated based on seperate conditions.is there way can show 1 of these detail row under group containing 'r' can shown after group subtotal?

the output report should this:

i want show pointed row after group sub total...

please ask me further clarifications...

 

hi nag1234,

thanks post.

according description, specify report table showing 1 detailed row after group subtotal in each group. if use table control show data, can take use of group header show subtotal value. can specify expression detailed row control visibility of detailed row.

show subtotal value on group header.

1.right-click row handle of group row, select edit group.

2.check include group header item, click ok.

3. right-click relevant textbox, select expression, edit expression below:

=sum(fields!field.value)

specify expression detailed row, please refer steps below.

1.right-click handle of detailed row, select properties.

2.scroll visibility category, specify expression hidden property,such as:

=iif(fields!field.value<500,true,false)

if have unclear, please feel free let me know.

thanks,
bill lu

 

---

please remember mark replies answers if , unmark them if provide no help.

SQL Server  >  SQL Server Reporting Services, Power View