You’re offline. This is a read only version of the page.
5
I need to create a SSRS report for online Dynamic CRM 365.
Here my requirement is, I need to fetch data from 4 entities and show in tabular format. Following is exact requirement.
For Example I have Entity A which has a subgird of Entity B. Entity B has 2 subgrids of Entity C and Entity D. Need to show data of all of this entity in following format. A1, A2 records of Entity A .Similarly B1-B3, C1-C6 , D1-D5 are data of Entity B, C, D respectively.
|
A1 Data |
B1 Data |
C1 data |
D1 data |
|
C2 data |
D2 data |
||
|
A2 Data |
B2 Data |
C3 data |
D3 data |
|
C4 data |
|
||
|
B3 Data |
C5 Data |
D4 data |
|
|
C6 data |
D5 data |
Help me with how to create this report as didn’t worked on reports. Also Unable to get show data of entities in same table as I have created different dataset.
Thanks in advance.
*This post is locked for comments
Basically you want to drill down report from parent to child and child to sub child.
You could achieve this by adding groups on row.
Please refer below url for more info
docs.microsoft.com/.../create-a-stepped-report-report-builder-and-ssrs
www.sqlchick.com/.../visibility-settings-in-ssrs-drill-down-to-showhide-report-da.html
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (