11/25/2024 7:38:51 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
no history records
Posted: 05 Apr 07 8:03 AM
|
fiogf49gjkf0d I'm trying to develop a report that would list all accounts that do not have a history record(not including db changes) in the past "X" days. But I can't seem to get a formula that would build those exclusions. Any ideas?
I also built a running total field that had the max of the completeddate field which worked OK. But when I set the select expert to not include 262156, then those accounts that didn't have any other history, quit showing up.
thanks,
Dave |
|
|
|
Re: no history records
Posted: 06 Apr 07 11:35 AM
|
fiogf49gjkf0d For something like this, I would probably create a view first that showed all the history records but the ones with type 262156, and only include the fields you need to look at - then you can do all the rest of the things you did and probably get a better result. Since SQL views can be synchronized now, this method works well. |
|
|
|
Re: no history records
Posted: 06 Apr 07 11:56 AM
|
fiogf49gjkf0d thanks Jeff. I'll give that a shot. This has been a real head-banger.
thanks,
dave |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|