Hi
I have an SQL table with 40000+ rows in it. The columns are from MSCRM 4.0 FilteredPhoneCall, FilteredCampaign, and ActivityPointer.
The strange thing is that when I run =NL("Rows","FilteredPhoneCalls",E5:G5) with the appropriate NF it only returns 128 rows.
I can't for the life of me figure out why. Anyone got any ideas?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
I don't know a lot about MS CRM, but I do know that the SQL views such as FilteredPhoneCalls are, as their name implies, filtered. I know they are filtered based on user security, but I don't know what other filters are being applied in the view. I would guess that you need to look at the definition of the view and figure out what the view is actually giving you, since it's obviously not the full table results.
Regards,
Hughes
Please sign in to leave a comment.