reporting services - 1 row from DataSet A to many from DataSetB -
i'm trying create report display's document in db across multiple tables. have querys , datasets set fine, i'm having issues grouping right on report itself.
to make clear
i have 1 row dataset needs displayed , under it, each row dataset b.
like
dataset fields (basically "for each") dataset b fields keep repeating "for each"
how go this?
what return relevant field(s) dataset on every row fields dataset b , group on dataset field. example:
select dataseta.id, datasetb.code, datasetb_description, datasetb.value dataseta inner join datasetb on dataseta.id = datasetb.dataseta_id
on tablix, create group changes on id
, put datasetb fields in detail row of tablix. each time dataseta.id changes, trigger new group header , display datasetb rows relate dataseta id under it.
Comments
Post a Comment