Inogic is a hub of like minded professionals who believe in innovativeness and are committed to putting our time and efforts to R & D on Dynamics CRM.We endeavor to share some of our work on this blog by introducing Tips, Tricks and products from our labs.
We created a SSRS
on-premise report using CRMFiltered parameter and the report was working
fine except for the case when we ran this report on more than 25 records. In
that case the report was crashing. When we used Diagnostic Tool then we found
the below error.
The error was that it was
concatenating the GUID’s instead of separating each other.
We found that the CRM
FilteredAccount parameter only returns 25 records, not more than that. Hence,
to fix this we used CRMAF_filteredAccount parameter and then the report
was working fine.
As we all know, we can export the CRM report in various
formats and one of them is “Excel sheet”. After exporting the report in
the excel sheet, there are chances that you may not be able to see the filter
on certain columns. You will also notice that two columns get merged in single
column and have empty columns. Hence there are two issues, one with column
filter and other with the merged columns, as you can see in the below :
The actual problem is with the report column and not with
the excel sheet. The problem in report is the column width. If a column
has width more than 1in then it adds a column extra in it.
Now you just need to set the column width to 1in which is
default width of a column, which will solve these problems and there will be no
extra column or filter issue.
Hope this help while
designing the report which can be exported to the excel sheet.
New to Dynamics CRM or already using Dynamics CRM? But do you do CRM the way it should be? Learn to CRM from the experts.
Roughly around 20 CRM MVP's (I was not one of them) have got together and come out with a collaborative offering called CRMFieldGuide.
To say the least.. Its simple and powerful. CRM is simple and the book will let your CRM be effective by letting you keep it simple.
The book touches upon all offerings/tools related to Dynamics CRM. It is not restricted to explaining the functional concepts of Sales/Marketing and Service. It goes way beyond and includes the entire process right from Installing and Configuring CRM to the Best Practices for customizations and Server Maintenance. It has a total of 25 chapters to touch upon the various topics some of which we generally need to search on the web to find information on like
Best practices for upgrade from CRM 4 to 2011
Understand Solutions to make it work better for you
Who better than the experts to share with you their collective knowledge in one CRMFieldGuide.
Its a must have for anyone who needs to CRM the right way!