We are trying to make a custom report to show the opening balance at the top and then related entries just like in Customer - Detail Trial Bal.
here I inserted a table and added the dataset fields by
1. inserting table later I inserted a row below and added the No and Opening balance
2. Clicked on Opening balance and added Row group on no (Adjacent below) [Here have a look in RDLC]
Here is the layout
this is how I made grouping
1. Click on the Opening balance and Add a Row Group against the Name
This is the result, it gives all entry balance and next their entries
Here are my requirements
1. Need to show the opening balance at the top and follow by related entries [like in Customer detail trail balance ]
2. Grouping that fulfills my requirment
3. New page for the customer (when this boolean is true in the request page in the report each customer a new page )
thanks.. :)