List of report instances

[HouDog]

Hi all, I hope someone can help me. I am new to CE 9.

I am trying to create 3 web pages. The first to list all reports. Clicking on a report title will take me to a second page listing all reports THAT I HAVE SCHEDULED (not the actual historical instances) regardless of the schedule type. Clicking on a particular scheduled report will take me to the 3rd page listing all instances for that scheduled report.

I know how to do page 1 and page 3. The problem is page 2. How do I get a distinct list all reports that I have scheduled ???

Thanks in advance.

Jae.

 

[PaulDeshayes]

> How do I get a distinct list all reports
> that I have scheduled ???
--------
Add something like this to the Crystal Query:
"AND SI_OWNERID=" & iStore.EnterpriseSession.UserInfo.UserId

/Paul

 

[HouDog]

How do I get a DISTINCT list of all reports that I have scheduled regardless of recurrence type ?