Sage CRM

Welcome to the Sage CRM Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Report Question

Posted By Deb - AMCG over 10 years ago

I have created a report with four different search criteria. From another CRM I have used, I assume that the criteria

utilizes "and" , not "or". However, when I run the report with the criteria of only showing >$100,000 in the Opp forecast field, I am

getting records showing $0.00.

Wisdom, please.

Thanks in advance.

0 Toby.Prince over 10 years ago

Are you familiar with SQL? The answers as to what is going on will be in the SQL log if you turn it onto full logging, and then run the report.

If you are not, post a screen shot of your report criteria up here, to see if there is anything conflicting etc.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Deb - AMCG over 10 years ago

Hi, Toby.

Weirdness abounds.

I ran the report again yesterday and it worked. Didn't change anything but it worked.

Thanks for your willingness to help!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage CRM

Report Question

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING