RE: CRM Reports showing only 10 records by taoyue
taoyue
Mon Oct 23 19:01:53 CDT 2006
------=_NextPart_0001_0A42E7AB
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
"vikramp" <vpuniv@gmail.com> wrote:
> When I run Account Summary report, it shows only 10 accounts and at the
> bottom of the first page, you see a message saying that this report can
> have maximum 10 accounts.
>
> Why is this restriction? What about the other accounts? How will show
> them in the report?
The limit of 10 is hardcoded into the report to ensure performance. The
account reports are very rich reports which join data from a number of
entities. Pulling down every single record would degrade performance for
other users.
You could, however, edit the report in Report Designer to increase the
limit. You should keep a limit, however high -- you don't want someone to
accidentally pull down tens of thousands of records (multipled with all the
related records) and then have to reboot the machine. If you really want
information about a lot of records, then you should design a report which
is very careful to minimize the number of joins and retrieve only the
information needed.
--
Tao Yue
Microsoft Dynamics CRM Development
This posting is provided "AS IS" with no warranties, and confers no rights.
------=_NextPart_0001_0A42E7AB
Content-Type: text/x-rtf
Content-Transfer-Encoding: 7bit
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fmodern\fprq1\fcharset0 Lucida Console;}}
\viewkind4\uc1\pard\f0\fs20 "vikramp" <vpuniv@gmail.com> wrote:
\par > When I run Account Summary report, it shows only 10 accounts and at the
\par > bottom of the first page, you see a message saying that this report can
\par > have maximum 10 accounts.
\par >
\par > Why is this restriction? What about the other accounts? How will show
\par > them in the report?
\par
\par
\par The limit of 10 is hardcoded into the report to ensure performance. The account reports are very rich reports which join data from a number of entities. Pulling down every single record would degrade performance for other users.
\par
\par You could, however, edit the report in Report Designer to increase the limit. You should keep a limit, however high -- you don't want someone to accidentally pull down tens of thousands of records (multipled with all the related records) and then have to reboot the machine. If you really want information about a lot of records, then you should design a report which is very careful to minimize the number of joins and retrieve only the information needed.
\par
\par
\par --
\par Tao Yue
\par Microsoft Dynamics CRM Development
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par }
------=_NextPart_0001_0A42E7AB--