How to generate report like this in ssrs
-
Hi ! Can you please tell me how can i generate report in this format ?
In this image the food and drinks would be a parent group and inside it the names will come. Also the header including Food , Participants , Address and the line below address will be repeated in each page. Please tell me how can i group like this format ? Please note i dont want + and - expand and collapse here.
-
Forcing page breaks between each occurrence:
the rest is easy.
I created a calculated field...
=Fields!MajorType.Value & ", " & Fields!SubType.Value
and then in my report, I grouped by that calculated field.
-
According to your expected results, you could create recursive hierarchy groups, please refer to this article: http://www.codeproject.com/Tips/860824/Using-Recursive-Hierarchy-Group-in-SSRS
If you want to repeat tablix header on each page, you could enable Advanced Mode by clicking down arrow on the right side of the Grouping pane. Then click the static member, go to Properties pane, set RepeatOnNewPage to True, KeepWithGroup to After. Just as the link posted above by other guy.
-
Take a look at the attached RDL file... It's a very simple layout so it should be a simple matter to "reverse engineer" it to see how it was constructed.
HTH,
Jason
-
It is working perfectly but can you please explain what have you done ?
-
emadkhanqai (5/27/2015)
It is working perfectly but can you please explain what have you done ?Use the file I supplied as a guide and try to recreate it on your own. If you get hung up on specific step or you have a specific question, I'll be happy to walk you through it.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply