locked
Report Header with Member Information and body with claim information RRS feed

  • Question

  • So we are designing this report that has Member Information in the Header of the SSRS Report and it's in the header because we want the member information to repeat on each individual page to identify who it belongs to. Within the report we want to report on all the claims for that member. Now our business user does not want the claim data as a tablix because the amount of claim information they're asking for is just too long. What I'd like to do is for each claim put a data label followed by its corresponding data...kind of an old fashioned report.

    So obviously I'd like to control the amount of claim information so that each page will hous an individual claim.

    What is the best way to do this? With a Subreport?

    Thanks for your review and am hopeful for a reply.

    ITBobbyP85

    Wednesday, September 24, 2014 6:25 PM

Answers

  • Hi ,

    You can achieve this using below;

    1.Insert one List Control in Report Area.
    2.Delete Details from Row Group Area.
    3.Group by on Row Group "claim Name" .
    4.Delete Column from Tablix that is used fro "Claim Name" .use Delete Columns Only.
    5. Right Click on Claim Name Group -> Group Properties-> Page Break ->Between each Instance of Group.
    6.In Tablix -> Right Click on Row ->Insert row-> Inside group below
    7. now you have skeleton use upper cell for Report Header that will be Claim Name in your Case.
    8. Drag one Tablix in Second Cell -> Bind data you require

    Please share if you have any issue.


    Thanks

    Please Mark This As Answer or vote for Helpful Post if this helps you to solve your question/problem.

    Thursday, September 25, 2014 10:58 AM