Report design for parent-child audit tables
-
Sunday, February 17, 2013 1:26 PMI am trying to design an interface where a user can query audit activity across 3 tables that are related. The 3 entities are as follows: Program, Item and ProgramItem and each have their respective audit tables. As suspected, the Program and Item PKs are foreign keys in the ProgramItem table. The design challenge i am facing is that each table has columns that are being tracked but I was trying to design an interface which would display the audit transactions of all 3 tables in only ONE report grid depending on the parameters selected. I was thinking of joining the audit entities in one view and then wrapping it into a parametrized stored proc. Issue is that since the entities are at different levels, the result set will return repeating entries for the parent tables. I hope I am clear but please respond if additional info is needed. Hanks in advance
All Replies
-
Tuesday, February 26, 2013 3:25 AM
Hi Lobo0807,
If there are duplicated entries for the parent tables, you can use the parent groups in the report tablix which can remove the duplicates of the parent group values.
Understanding Groups (Reporting Services)
http://msdn.microsoft.com/en-us/library/bb677373(v=sql.100).aspx
Regards, Leo
- Edited by Leo N Tuesday, February 26, 2013 3:27 AM
- Proposed As Answer by Mike YinMicrosoft Contingent Staff, Moderator Wednesday, February 27, 2013 5:49 PM
- Marked As Answer by Mike YinMicrosoft Contingent Staff, Moderator Sunday, March 03, 2013 3:17 PM
.png)
