ssrs 2008 programmatically add tables rows
- by davethecoder
Above is how my report looks, the part in yellow in hidden, and is only shown when the user clicks the + icon on the [name]. the result is basically the percentage difference from the Past [X] - [TERM] i.e there is a dropdown with, [weeks, months, days, hours] and a textbox of qty.
so choosing qty = 4 and term = weeks will delivery a result set spread over 4 weeks based on the parent result sets date range and name ID
I wish to populate here the number of rows, dependant on the value set by the user
and the data will be from a dataset.
Is it possible to dynamically add more sub rows ( like on row data bound )
if my first row is ID 123 [name], is it possible to send this value [123] to a dataset
in order that all subrows are only relevant to the name with ID of 123?
this is my first bash at SSRS so please no half cut answers, that just lead to more questions about the answer given :-) if this makes sense.
Thanks