AnsweredAssumed Answered

Script for Reports (How to get a new found set for different reports)

Question asked by bess on Jan 9, 2012
Latest reply on Jan 13, 2012 by bess

Title

Script for Reports (How to get a new found set for different reports)

Post

 Dear Forum Users

I have a problem with writing an effective script for a report. 

In my database, the table which holds the data is called CLIENTS.  I have 2 report problems.  1 report "Referral Source Totals" runs a report on ALL the Clients, the other "Referral Source 2006" runs a report on the Clients of 2006.  Both work but only if I go to the original table (CLIENTS) and click on "Show All (Records)" followed by "Unsort (records)".  I cannot swop from one report to another without going back to the table & carrying this out show/unsort each time; if I fail to do this, the report runs on the previous found set (I think) & produces incorrect information.

I've done my best to sort this out but failed.  Is there a way of writing a script which wi automate this process?

I should be very grateful for any help. 

E M Harvey

Outcomes