Hi,
We have a requirement to generate reportes to list down documents which were modified in a given period. Hence i have joined few objects like DM_audittrail, dm_document, dm_user, dm_group and etc as follows
Select d.r_object_id, f.r_folder_path as loc, a.object_name, u.user_name, g.group_name from dm_audittrail a, dm_user u, dm_group g, dm_document d, dm_folder f where a.user_id=u.r_object_id and any g.users_names=u.user_name and a.object_type='dm_document' and d.r_object_id = a.audited_obj_id and any d.i_folder_id = f.r_object_id and any f.r_folder_path is not nullstring ENABLE (RETURN_TOP 100)
In the crystal reports designer, can i copy the above dql scripts and design the reports templates?
I notice in the crystal reports designer that theire is option to add dctm objects and draw the links between the key fields.. Instead of this can i use the above dql script to design the reports.
Thanks in advance.
With regards
bless
