How to add a collection prompt to a report
Several people have asked repetedly how to make a report focus on a collection. Well the secret is the
v_FullCollectionMembership view.
Here is how to add it.
The
best way to do it is this:
SELECT
v_GS_SYSTEM.Name0
FROM v_GS_SYSTEM INNER
JOIN
v_FullCollectionMembership ON
v_GS_SYSTEM.ResourceID =
v_FullCollectionMembership.ResourceID
WHERE
(v_FullCollectionMembership.CollectionID = @collid
)
Start with this as your base report and add your other tables/joins and selects to it.
Collection ID code
(@collid)
SELECT CollectionID,
Name FROM v_Collection order by Name