Fetch xml based SSRS report

(0) Share

Report

Posted on by yoselam

Hi All,

I have a requirement to show child records of a parent record on a footer of fetch based SSRS report .

The parent record will be part of the main report body. The problem I have is i can't add table on a footer of a any SSRS report as you know.

Is there any way I can achieve this in fetch based SSRS report? any custom code (can I use plugin perhaps ) any tip is much appreciated!

I have the same question (0)

All responses (5)

Answers (0)

David Jennaway 14,065 on at

Like (0)

Report

One option would be to display the data in a text box in the footer. The textbox could display a concatenated string of values from the child entities. You can use a combination of the JOIN and LOOKUPSET functions to build the concatenated string

Was this reply helpful? Yes No
yoselam 10 on at

Like (0)

Report

That is just going to give me the first child record, but what i want is all the associated child records. If I put in in a text box it only takes the dataset's first element (see pic below)

One parent record have multiple child records associated to it, and wanted to display each child records selected columns, separated by new line in a footer.

so if I have a parent record with two child record, i wanted to get the name of the two child records (one line for each name) on a footer.

Was this reply helpful? Yes No
yoselam 10 on at

Like (0)

Report

Hi David,

Thanks for your feedback, the problem of using text box is limited to a dataset and is returning me the first child record. i.e i wanted to show all child record associated to that parent record. If I use your method I can only pull the first element of the child record. what i needed is the name of all the child records speared in a new line on the footer for every paret record on each page.Right now all I can get is the first child's name on the dataset (see screenshot below of what I am seeing after I put a textbox in a footer and trying to access report child record's name . Please let me know any tips.

Was this reply helpful? Yes No
David Jennaway 14,065 on at

Like (0)

Report

You'll want an expression that looks something like:

=JOIN(LOOKUPSET(Fields!ParentField.Value,Fields!ChildLookupField.Value,Fields!ChildDisplayField.Value,"ChildDataSetName"),vbCrLf)

Where Fields!ParentField.Value is the identifier of the parent, Fields!ChildLookupField.Value is the lookup field on the child, and Fields!ChildDisplayField.Value is the field that has the text that you want to display

Was this reply helpful? Yes No
yoselam 10 on at

Like (0)

Report

Thank you so much David!

Do I need to have a separate dataset for parent and child records?, fetch xml allows me to query them together and right now i have both on same dataset.

Was this reply helpful? Yes No