I'm not aware of anyway to stop Remedy from overriding the selection criteria, I do have a trick that might work if you not reporting against a huge table of data. What you can do is create a formula within the report that equates to true/false. Then use this formula to suppress the records you don't want. Unfortunately, this means when you're running the report, you're collecting ALL the records. So if this is a huge table, then there's a serious performance hit. So not the best idea, but if you're stuck and the data is not that much might be viable. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701
>>> [EMAIL PROTECTED] 07/18/08 11:24 AM >>> Has anyone found a way to view a crystal report with embedded qualifications and not have ARS strip them ? I am trying to view a report from an AL that comes from an external data source and has a .rpt file that has the correct qualifications, but I get all records because Remedy does not use the qualifications. Since it is an external database, I can't build the qualifications in the report AL because Remedy does not recognize the fields. You would think if you called the report with no qualifications, it would run the canned report as is. ARS 7.1 Crystal XI Midtier 7.1 Windows 2003 IIS Tomcat //SIGNED// Robert R. Gornto, YC-02,37 CS/SCOO Chief, Network Operations DSN 945-0483 Comm 210 925-0483 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
